Satans_Banjo

Hi

I'm pretty new to PHP/MySQL and I am having trouble entering dates into a database. I've got the database set up and one of the fields is a DATETIME field. What I want to do is put the time that the record was entered into that file. This is what I'm currently doing, but it leaves the date as the default value in the database (0000-00-00 00:00:00):

[PHP]$phpTime = time();
$mySqlTime = gmdate("YYYY-mm-dd H:m:s", $phpTime);
$dateAdded = strtotime($mySqlTime . " GMT");[/PHP]

Is that completely wrong or am I just missing something trivial and/or blindingly obvious?

Thanks,

Banjo

Styx

With this, you get time(), format it in the second line, then reconvert it to time with strtotime, which wont be stored correctly in the database. In fact, your conversion in the second line is completely off, since gmdate is basically the same as date and will result in "2007200720072007-" etc.

Really, you should just set the field to INT(11) and store time(). It's much simpler to work with.

But if you really want to keep that format, you would do gmdate('Y-m-d H:m:s', $phpTime) and add that with your query, not $dateAdded, unless you wanted a GMT version of time().

Satans_Banjo

Thanks for the quick reply. I think I'll keep the format so that I can do queries like showing items posted after a certain date etc.

It's working now. Cheers!

EDIT: One more thing: how do I make it so that the time is in GMT, or make an offset to the server time or something like that? The server is somewhere in Germany so the time isn't in GMT

Styx

gmdate should return a GMT version, but check the documentation for the function, or see the other functions listed on the side for something that might help.