Posted by IchBin on 08/06/06 18:49

mpar612@gmail.com wrote:
> Hi everyone,
>
> Pretty new to the forums, PHP and MySQL here. I am having an issue
> inserting the current date and time into a MySQL database using PHP.
>
> My table in MySQL is setup with add_date as date not null.
>
> Here is my query:
> $db->query('INSERT INTO lounge (isbn, artist_name, album_title,
> release_date, add_date, description, price)
> VALUES (?,?,?,?,?,?)',
> array($_POST['isbn'], $_POST['artist_name'],
> $_POST['album_title'], $_POST['release_date'], curdate(),
> $_POST['description'], $_POST['price']));
>
> My issue is with automatically entering the current date and time into
> the add_date field of the database. I did some searching and tried the
> curdate() function in MySQL and that did not work. This is not a date
> that is input by the user. I would like the date to be automatically
> added to the database without it being known to the user.
>
> Does anyone have any thoughts on how this is done?
>
> Thanks!
>

You can define your DB 'add_date' column as a timestamp with the
following format:

add_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP

This way you could eliminate any reference to 'add_date' in you code but
have it automatically inserted on a insert or update to that DB row.

Look at this link
http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html

Thanks in Advance...
IchBin, Pocono Lake, Pa, USA http://weconsultants.phpnet.us
__________________________________________________________________________

'If there is one, Knowledge is the "Fountain of Youth"'
-William E. Taylor, Regular Guy (1952-)

[Back to original message]