How to add submit time to form programming?

Question

My form is:

Firstname:
Lastname:
Age:

insert.php file:
$con = mysql_connect("localhost","peter","abc123");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("my_db", $con);

$sql="INSERT INTO person (FirstName, LastName, Age)
VALUES
('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";

mysql_close($con)
?>


How do I add in timestamp(yyyymmddhhmmss) into the form and file so it is stored in my database?

Thanks

Answer 1

You should pull it from your own server as a internal variable. Consult MySQL for "time" as environment variable or a date/time function. You don't want client's "local" time any way. It'd be impossible to sort properly. Better use your own server time.