Forum Moderators: open
I have a php form which users fill out and I would like a timestamp input in the database so I know when it was input.
I have REMOTE_ADDR to collect the IP address....what do I use to find time & date?
I already used REQUEST_TIME but it gives back a funny number like : 1218013726
Many thanks!
SQL standards allow you to use values such as CURRENT_DATE, CURRENT_TIME and CURRENT_TIMESTAMP. The value is pulled from your server.
date_default_timezone_set('GMT+1');
$date = date('M jS Y H:i');
just used these variables and then used $date to output to email and into a mysql field.
into a mysql field
There's a more efficient way with mysql. :-)
insert into table (timestamp) values (now());
now() is a combo date AND time stamp.
2008-08-06 10:47:48
It's also a good field to rely on for sorting by date/time. The field must be a datetime type.
insert into table (timestamp) values (now());
Wouldn't it be even easier to set a default value for the column and not mention it in the insert?
