php :: datetime

gmarais · 03-04-2004, 07:31 AM

hi,

i have created a mysql table where i would like to store the date and time whenever a user logs into a web site. the login is done through php/mysql as well but i'm not sure what the php code is to add the current date/time into a mysql database. the field in the db is created as a 'datetime' field.

thanx

crabboy · 03-05-2004, 09:55 PM

I just use something like this:

Code:

      $DateTime = date( "U" );

      $query = mysql_query( "insert into failed_logins ( login_id, password, ip_address, date_time ) values ( '$name', '$password', '$ClientIP', $DateTime )")
               or die ("Unable to insert into failed_logins");

You will have to format the date into a readable format when you pull it back out. The "U" get the date in the number of seconds since Jan 1970.

crabboy · 03-05-2004, 09:56 PM

The php manual has some good code examples:

http://www.php.net/manual/en/function.date.php

Longinus · 03-06-2004, 04:33 PM

heheh i think i know how to do this

you use a function called time()
time() just returns the current date in seconds (really long number)

do something like this when they enter your website:

$time = time();

mysql:
create table mytable(time int unsigned);

in your php code, connect to the database and insert '$time' into the field 'time'

thats it!

now all your time is gonna be like: 268729263 or something like that

so to convert the time into human readable format use the php function called

date()
http://www.php.net/manual/en/function.date.php

hope that helped