[stealth04]

Hi,
I am a beginner, so I have some problems with coding.
I would like to create a script which would insert date and time informations into the database and then read those informations.
I have created a database with fields date (type date) and time (type time).
I have written:
.....insert into information(date, time) values('$date', '$time')....
could anyone help me defining $date and $time variables?

How to change format when I will read these iformations from the database?
Thank you.
Regards,
Niko

[kvnband]

Just wondering....Have you even looked at the manual?

http://www.php.net/manual/en/ref.datetime.php

[Spirit]

Hi, Niko! Yeah, I had trouble w/dates and times at first, too. I got confused the most with the word "timestamp". In the MySQL manual, there are several variations of the timestamp type and it took me a while to realize my use of it was in yyyymmddhhiiss format. In the PHP manual, it referred to timestamps but it was referring to an integer (seconds since unix epoch).

You can store dates and times in the db however you want. What I do is parse the dates/times to comoponent parts and then convert the dates to unix epoch integers using PHP's mktime() function. Then, you can show your dates and times in any format you want using PHP's date() function, e.g. date ("m-d-Y g:i:s a", $myunixepochfield)

This is what I do...

formpage > transitionpage (INSERT...) auto-refreshes to > confirmpage (SELECT...)

Hope this helps!
--ST

[<?Wille?>]

if you want to insert current time and date this should do:

PHP Code:

$query = mysql_query("insert into information set date=CURDATE(), time=CURTIME()"); 

[infinitylimit]

What are you trying to store this for? Maybe a simple timestamp field might be a better solution.

[stealth04]

I have done this way:
$date = date("Y-m-d");
$time= date("H:i:");
"insert into guestbook (comment, name, email, site, date, time, userip) values(...'$date', '$time'...);
This works for now.
I would like to do a guestbook and later I would like to add some functions to sort comments...
Is there any better way to store date and time information?
I don't have much experience with PHP and mySQL and I am still learning...