Set current time field for MySQL

Question

I am trying to set the value of a field via a hidden form field to the current date and time using either PHP or Javascript that would conform to MySQL's datetime field.

Answer 1

You can use PHP to get and format the current system date/time for use in MySQL like this:

$now = date('Y-m-d H-i-s');

Answer 2

You can directly set current date and time in your SQL insert query using NOW():

INSERT INTO table_name (current_time, column2, column3,...) 
VALUES (NOW(), value2, value3,...)

where current_time is the field where you want to put current date and time.