Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

reverse the date in find

Posted on 2014-10-09
7
106 Views
Last Modified: 2014-11-01
Hi, In cakephp how can I get the date in reverse order as when I add this to a select input box I see the date as Y-m-d.
The database stores the date in this order.
In the find I want to have the date formatted before assigning to a select box.

  $dateoptions=$this->Lesson->find('list', array(
               'fields' => array('Lesson.lesson_date')  ));
0
Comment
Question by:jagguy
  • 4
  • 3
7 Comments
 
LVL 109

Expert Comment

by:Ray Paseur
ID: 40370640
Not sure about the "Cake" part, but in PHP we use strtotime() and date() functions to reformat dates.
http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/PHP/A_201-Handling-date-and-time-in-PHP-and-MySQL.html

Example:

<?php
$today = '2014-10-08';
$timestamp = strtotime($today);
$pretty_date = date('F j, Y', $timestamp);

Open in new window

0
 

Author Comment

by:jagguy
ID: 40372831
The cake part is the MVC and this is important.
I meant getting the date reversed in the find itself
0
 
LVL 109

Expert Comment

by:Ray Paseur
ID: 40373317
I understand that Cake is the MVC framework.  I don't think you can do the date "reversal" in the find().  It's a bit of an exploratory process, but if you work with me we can get a good solution.  After this function call, please add var_dump() as shown here.  Use "view source" to see the output from var_dump().  Copy it and post it back here, thanks.  Also, please tell me the format you want to see for the date.

$dateoptions=$this->Lesson->find('list', array(
               'fields' => array('Lesson.lesson_date')  )); 
var_dump($dateoptions);

Open in new window

0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:jagguy
ID: 40389466
sorry I have been away for w awhile so I will get on to it
0
 

Accepted Solution

by:
jagguy earned 0 total points
ID: 40407669
$sdate= date('d-m-Y',(strtotime( $sdate )));
echo $sdate;
0
 
LVL 109

Expert Comment

by:Ray Paseur
ID: 40408224
Are you sure there was nothing in this comment that helped you?
http://www.experts-exchange.com/Programming/Languages/Scripting/PHP/Q_28534478.html#a40370640
0
 

Author Closing Comment

by:jagguy
ID: 40416993
i found the answer
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This article discusses how to create an extensible mechanism for linked drop downs.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question