this is a php date issue

[rr1024]

Hello everyone, thanks for the help on the phpbb forum class login, it's working great.

Anyway here is my current issue which I don't understand.

I'm wrting the date the user registers to the user table for phpbb.

If I echo $reg_date on a page it displays the date correctly, however when it is writen to the data base, in the table as in today all I get is the number 22 for Today 11/21/04

phpbb shows this 22 as Dec 31 1969, LOL
When phpbb writes the date into the table it looks like this 1103503202 and the date shows up correctly.

A couple of things, why does $reg_date show up correctly but not get writen to db correcly?

Anyone know what the proper date format is for 1103503202...lol

Thanks for any help

           $phpbb_user_dateformat = "d M Y h:i a";

       $reg_date = gmdate('d M Y h:i a');
         $res = db_res( "INSERT INTO phpbb_users (
                                                       user_id,
                                                       user_active,
                                                       username,
                                                       user_password,
                                                       user_regdate,
                                                       user_level,
                                                       user_posts,
                                                       user_timezone,
                                                       user_style,
                                                       user_lang,
                                                       user_dateformat,
                                                       user_new_privmsg,
                                                       user_unread_privmsg,
                                                       user_last_privmsg,
                                                       user_viewemail,
                                                       user_attachsig,
                                                       user_allowhtml,
                                                       user_allowbbcode,
                                                       user_allowsmile,
                                                       user_allowavatar,
                                                       user_allow_pm,
                                                       user_allow_viewonline,
                                                       user_notify,
                                                       user_notify_pm,
                                                       user_popup_pm,
                                                       user_rank,
                                                       user_avatar,
                                                       user_avatar_type,
                                                       user_email,
                                                       user_sig
                                                  )
                                            VALUES
                                                  (
                                                       '$arr_iamembers[ID]',
                                                       '$One',
                                                       '$arr_iamembers[NickName]',
                                                       '$phpbb_Password',
                                                       '$reg_date',
                                                       '$Zero',
                                                       '$Zero',
                                                       '$phpbb_user_timezone',
                                                       '$One',
                                                       '$phpbb_user_lang',
                                                       '$phpbb_user_dateformat',
                                                       '$Zero',
                                                       '$Zero',
                                                       '$Zero',
                                                       '$Zero',
                                                       '$Zero',
                                                       '$One',
                                                       '$One',
                                                       '$One',
                                                       '$One',
                                                       '$One',
                                                       '$One',
                                                       '$One',
                                                       '$One',
                                                       '$One',
                                                       '$Zero',
                                                       '$phpbb_user_avatar',
                                                       '$phpbb_user_avatar_type',
                                                       '$arr_iamembers[Email]',
                                                       '$arr_iamembers[Headline]'

                                                  )"
                      );

[planetsim]

Originally posted by rr1024
Hello everyone, thanks for the help on the phpbb forum class login, it's working great.

Anyway here is my current issue which I don't understand.

I'm wrting the date the user registers to the user table for phpbb.

If I echo $reg_date on a page it displays the date correctly, however when it is writen to the data base, in the table as in today all I get is the number 22 for Today 11/21/04

phpbb shows this 22 as Dec 31 1969, LOL
When phpbb writes the date into the table it looks like this 1103503202 and the date shows up correctly.

A couple of things, why does $reg_date show up correctly but not get writen to db correcly?

Anyone know what the proper date format is for 1103503202...lol

1103503202 is just the Unix Timestamp you can find more about that by searching google. However its the amount of seconds since 1st January 1970.

$reg_date = gmdate('d M Y h:i a'); should be a Unix Timestamp so use time() or mktime instead.

[rr1024]

very easy so I feel pretty stupid...:o
I replace reg date with.

Once you pointed me in the right direction I also figured out why was getting 21 and 22 in the mysql table for reg date.
This was due to the table being integer only...and I did not understand that date or gmdate was a string and that I needed to convert it..

This was the fix

gm time was way off for some reason but this worked fine...

Thanks very much.

This was the fix

$reg_date = strtotime( date('d M Y h:i a') );

[planetsim]

Its better if you used time or mktime instead of strtotime it doesnt always work as expected.