|
|
Posted by MS on 08/06/06 18:08
<mpar612@gmail.com> wrote in message
news:1154887476.661483.210720@m73g2000cwd.googlegroups.com...
> 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.
>
> 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!
>
strtotime("now"); // gives a 10 digit timestamp which can then be
interpreted by the date();
http://uk.php.net/manual/en/function.strtotime.php
http://uk.php.net/manual/en/function.date.php
Best Wishes
MS
Navigation:
[Reply to this message]
|