|
|
Posted by mpar612 on 08/06/06 18:22
I tried this and the date still shows up as 0000-00-00 in the database.
Any other thoughts?
Thanks!
MS wrote:
> <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]
|