PHP Guestbook - Retrieving date visitor added comment (MySQL)

Funky_Monk

I have a MySQL database that has a field 'date_added'. At the moment I have it set as the type 'timestamp(14)'. I am building a Guestbook and want to display the date and time that the visitor entered their comments.

I DO NOT want the current date. I know how to do that. I can do this with ASP and an Access database, and it takes about 5 minutes. But I'm working on this project in PHP so...

I'm really under pressure in terms of timescales so please make it really simple for me to understand (as much as possible). Thanks.

I know there are numerous articles on this subject on the Internet but I honestly cannot make sense of it.

dalecosp

Personally, I seldom use MySQL's date & time types. You can, of course. I use a "bigint" field that holds a UNIX timestamp, and do all my date conversion(s) via PHP.

To do it your way, probably this should be close (as an example):

$posted=date("YmdHis");
$success=mysql_query("update mytable set date_added='$posted' where whatever is foo");

In PHP, I just do:
$now=time();
// then insert $now into a bigint field during the db stuff

HTH,

Rayman3_tk

Maybe this link will be of any help.

http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html

Good Luck