[support] How to store/retreive date fields into/from MySql

[Austin Einter]

Even with this I get warning.
Say the code is

*strtotime($form_state['values']['birthdate'])*

But $form_state['values']['birthdate']  is an array, but strtotime expects
string.

So I get warning "warning: strtotime() expects parameter 1 to be string,
array given in
C:\MyWeb6.20\wamp\www\livejobs1\sites\default\modules\resume_submit\resume_submit.module
on line 564."

How do I overcome this issue....

Thanks
Austin

On Mon, Mar 28, 2011 at 8:57 PM, Brett Evanson <brettev at gmail.com> wrote:

> You might want to look at the strtotime function in php. I believe it
> would take that date and turn it into a Unix epoch number (i think
> that's what you're looking for)
>
> Brett Evanson
>
>
>
>
>
> On Mon, Mar 28, 2011 at 9:15 AM, Austin Einter <austin.einter at gmail.com>
> wrote:
> > Hi All
> > I have date field, I am storing it as "int" in table.
> > When I checked the table in database, the value shows as 1.
> >
> > My code is as below.
> >
> > 'INSERT INTO {rs_table} ( uid, name, qualification, email, altemail,
> phone,
> > altphone, dob, yrsofexp, prefworkloc) '
> >       ."VALUES (%d, '%s', '%s', '%s', '%s', '%s', '%s', '%d', '%d',
> '%s')",
> >      $user->uid,
> >      $form_state['values']['persname'],
> >      $form_state['values']['hqualif'],
> >      $form_state['values']['email'],
> >      $form_state['values']['altemail'],
> >      $form_state['values']['phone'],
> >      $form_state['values']['altphone'],
> >     $form_state['values']['birthdate'],
> >     $form_state['values']['yearsexp'],
> >     $form_state['values']['prefloc']
> >   );
> >
> > Whats the wrong here, is there any API I have to make use of to convert
> from
> > date to int value??
> >
> > Regards
> > Austin
> >
> >
> >
> > On Mon, Mar 28, 2011 at 8:36 AM, Austin Einter <austin.einter at gmail.com>
> > wrote:
> >>
> >> Hi All
> >> I have a date field in my form.
> >> How do I store/retreive the value into/from MySQL.
> >>
> >> On google search, I saw people are suggesting to use either "int" or
> >> "datetime" type.
> >> Please suggest which one needs to be used.
> >>
> >> If I use int (I hope core uses int), while storing can I just
> >> store "form['values']['date1']" as %d and while retreivin, what are the
> >> related apis to convert back to date.
> >>
> >> Regards
> >> Austin.
> >>
> >>
> >
> > --
> > [ Drupal support list | http://lists.drupal.org/ ]
> >
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20110328/c637753a/attachment-0001.html