CakePHP - Error saving date field

Question

I have trouble saving my date field into database using CakePHP.

Table column name

[User].[dob]

View

<?php echo $this->Form->input('dob', array('type'=> 'date', 'label' => FALSE, 'dateFormat' => 'DMY', 'minYear' => date('Y') - 111, 'maxYear' => date('Y'))); ?>

I get the following error when I submit the form -

2011-12-29 00:33:57 Debug: Notice (8): Array to string conversion in [C:\xampp\htdocs\dearmemoir\cake\libs\router.php, line 1573]

This field is part of the Auth User Model. Any ideas what might be going wrong?

You're concatenating an Array like it were a string, I think. Try to replace that with var_dump(...); to see what you're really returning there. — Aram Kocharyan
– Aram Kocharyan, Commented Dec 29, 2011 at 5:43
Also, date('Y') - 111 is a string - an int, maybe try intval(date('Y')) - 111 ? No, my bad, it works! — Aram Kocharyan
– Aram Kocharyan, Commented Dec 29, 2011 at 5:45
Ah, I think what has happened is that an Array has been passed as an argument in your args array, and cake is trying to concatenate it like a string. — Aram Kocharyan
– Aram Kocharyan, Commented Dec 29, 2011 at 5:47
I replaced [date('Y') - 111] with 1900 and still see the same error! — jagamot
– jagamot, Commented Dec 29, 2011 at 6:04
Yeah, it turns out PHP won't mind there, but I'd try to do: <?php var_dump( $this->Form->input('dob', array('type'=> 'date', 'label' => FALSE, 'dateFormat' => 'DMY', 'minYear' => date('Y') - 111, 'maxYear' => date('Y'))) ); ?>. Is this the method: api.cakephp.org/class/form-helper#method-FormHelperinput — Aram Kocharyan
– Aram Kocharyan, Commented Dec 29, 2011 at 6:06

jagamot · Accepted Answer · 2011-12-29 15:15:37Z

2

This line of code did the magic for me -

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

I am able to save data now!

answered Dec 29, 2011 at 15:15

jagamot

5,48418 gold badges62 silver badges97 bronze badges

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

1 Comment

Umar Sid Over a year ago

Where did you added this code. I mean which file and where.

Community · Accepted Answer · 2017-05-23 11:48:07Z

0

I suspect that you are looking in the wrong place. The error message is coming from the CakePHP routing (router.php) - i.e. possibly the redirect URL that you are using.

The example code you give looks correct, it almost exactly matches an example from the Cake cookbook:

echo $this->Form->input('birth_dt', array( 'label' => 'Date of birth', 'dateFormat' => 'DMY', 'minYear' => date('Y') - 70, 'maxYear' => date('Y') - 18 ));

You can add in a check for any validation errors.

edited May 23, 2017 at 11:48

CommunityBot

11 silver badge

answered Dec 29, 2011 at 12:23

icc97

13.1k9 gold badges84 silver badges99 bronze badges

Collectives™ on Stack Overflow

CakePHP - Error saving date field

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related