posting date/time of form usage to mysql db?

[paulmo]

want to post date/time of form execution in db field. thanks

[gevans]

Do you have any code yet? This isn't a place to get free work, we're here to help solve problems

[flyhoney]

Just use the mysql NOW() function.

 

example:

 

INSERT INTO table SET created = NOW()

[paulmo]

yikes! (was writing reply while previous posted. that NOW function seems so easy. how does it know what table to go to?) i need to post date/time in same table row as the following when the form's submitted:

mysql_connect("xxx", "xxx", "xxx") or die(mysql_error()); 
mysql_select_db("xxx") or die(mysql_error()); 
$name = mysql_real_escape_string($_POST['name']);
$theme = mysql_real_escape_string($_POST['theme']);

mysql_query("INSERT INTO interactive (name, theme) VALUES ('$name', '$theme') ") or die(mysql_error());

 

i'm reading about date (format, [timestamp]); but unsure how to start.

 

would "created" in example above be the date/time field in table?

 

thank you!!

[flyhoney]

Something like this?

 

mysql_connect("xxx", "xxx", "xxx") or die(mysql_error());
mysql_select_db("xxx") or die(mysql_error());
$name = mysql_real_escape_string($_POST['name']);
$theme = mysql_real_escape_string($_POST['theme']);

mysql_query("INSERT INTO interactive (name, theme, created) VALUES ('$name', '$theme', NOW()) ") or die(mysql_error());

[paulmo]

very cool, thanks! missing the time though. easy fix?

[flyhoney]

Make sure the created column is a mysql DATETIME

[paulmo]

you're the greatest! so simple. seems that php, mysql, js, all can do similar things, but this one has to win for simplicity. i'm guessing it's all gleaned from the mysql manual? i'm referring to that, but defintions can seem cryptic to a noob without knowing the applications.

 

thanks again!