DateTime not save properly in cakephp 3.x with bootstrap datetimepicker

Question

i am using cakephp 3.x, i have one form in which one field is of date. in backend i am using mysql.

my field structure in mysql is dob of type date.

now in cakephp 3.x i had use below syntax to create input.

echo $this->Form->input('dob', array(
    'label' => (__('Date of Birth')),
    'type' => 'text',
    'required' => false,
    'class' => 'form-control date'
));

and i had used bootstrap datetimepicker like,

$('.date').datetimepicker({
    format: 'YYYY-MM-DD'
});

now when i submit the form at and i print_r the request data at that time i got this field like this

[
....
'dob' => '2016-02-11',
....
]

but when i save the record and look in database then it show me random date like 2036-10-25

can anyone help me please?

So it's en_US then. In that case this seems to be a duplicate of stackoverflow.com/questions/33734683/…. You should be able to apply similar to date instead of datetime, respectively to \Cake\I18n\Date instead of \Cake\I18n\Time — ndm
– ndm, Commented Feb 12, 2016 at 11:26

Hitesh Hadiya · Accepted Answer · 2016-02-12 09:02:52Z

1

and this is the Final General Solution,

//File : src/Model/Table/PatientsTable.php
namespace App\Model\Table;

use Cake\ORM\Table;
use Cake\Event\Event;
use ArrayObject;
use Cake\I18n\Time;

class PatientsTable extends Table
{
    ...
    ...
    public function beforeMarshal(Event $event, ArrayObject $data, ArrayObject $options)
    {
        if (isset($data['dob'])) {
            $data['dob'] = Time::parseDate($data['dob'], 'Y-M-d');
        }
    }
}

answered Feb 12, 2016 at 9:02

Hitesh Hadiya

1,0731 gold badge9 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rana · Accepted Answer · 2016-02-11 20:45:28Z

0

You declared dob type as date but tried to save date in string format instead of date time format. Try this

use Cake\I18n\Time;

$this->request->data['dob']= Time::parseDate($this->request->data['dob'],'Y-M-d');

answered Feb 11, 2016 at 20:45

Rana

3463 silver badges9 bronze badges

1 Comment

Hitesh Hadiya Over a year ago

thanks, it's works. but i need global solution that can be put in entity or somewhere else.

Collectives™ on Stack Overflow

DateTime not save properly in cakephp 3.x with bootstrap datetimepicker

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related