Re: Date picker for CakePHP 2.0.3

I followed the instructions and it works. The problem is when I try to save it to database (MySQL) where it expects date in 'YYYY-mm-dd' format while I set it to be displayed in 'dd/mm/yy' format in the form.

So, I insert codes to change the format as expected by mySQL in beforeSave function in the model as below:

$this->data['Posttest']['submit_date'] = date('Y-m-d',strtotime($this->data['Posttest']['submit_date']));

In add view, it works perfectly. But in edit view, the date is still displayed in 'YYYY-mm-dd' format.

On Saturday, December 27, 2014 at 4:07:09 AM UTC+7, Sandeep Kumar wrote:

Thank you Florin Trifu for your answer, it saved a lot of time..

I made some changes to script to include date format to hope that helps someone else

<script>
$(function() {
       $(".datepicker").datepicker(
        {
                           dateFormat: 'yy-mm-dd',
                           onSelect: function(dateText, inst){
                                 $('#select_date').val(dateText);
                                 $("#datepicker").datepicker("destroy");
                          }
        }
      
      
       );
});
</script>





On Wednesday, November 30, 2011 4:11:27 AM UTC+4, Florin Trifu wrote:

Thank you very much! Indeed it worked.

Just to let the other users know in case they will have the same problem:

1. Download jquery (http://docs.jquery.com/Downloading_jQuery) and put the file in $project/app/webroot/js (e.q: $project/app/webroot/js/jquery.js)
2. Download jquery-ui (http://jqueryui.com/download); I, for example, downloaded a zip archive called: jquery-ui-1.8.16.custom.zip. From this archive you will have to copy the followings:

a. $archive_root/js/jquery-ui-*.js in $project/app/webroot/js (give it a shorter name e.q: jquery-ui.js)
b. $archive_root/css/smothness/* to $project/app/webroot/css (including the images; rename the css file to something shorter)

3. Include both js files in your layout. eq:

//$project/app/views/Layouts/default.ctp
-------------------------------------------------------------
echo $this->Html->script(array('jquery',
                                        'jquery-ui'));

4. Include the css file. Eq

//$project/app/views/Layouts/default.ctp
-------------------------------------------------------------
echo $this->Html->css('jquery-ui.css');

5. Put this lines of code before calling the date-picker:

<script>
$(function() {
       $("#datepicker").datepicker();
});
</script>

6. Call the date picker in your form:

echo $this->Form->input('expire',
        array(
           'id'=>'datepicker',
           'type'=>'text'
        )

This is it!

Best regards!

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.