Posted by mpar612 on 08/06/06 18:06

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!

• Next in forum: Re: Entering current date and time into MySQL database using PHP.
• Prev in forum: Re: how to compare rows
• Thread view: Entering current date and time into MySQL database using PHP.

[Reply to this message]