CODEWITHSUNDEEP
phpmysql
James
James

Reputation: 23

Inserting a datetime value from php into MySQL

I have a column with datetime datatype called 'updated_at' in a mysql table,where i want the current date and time.Im trying to insert a record into the mysql table from php,as follows:

mysql_query("INSERT INTO my_table (service_name,service_status,service_comment,user_name,updated_at) VALUES($service_name,$service_status,$service_comment,$user_name,$updated_at) ")

$updated_at is defined as follows:

$updated_at = date("D, d M Y H:i:s O");

But the insert is not taking place. Any way to fix this problem ?

Please help Thank You

Upvotes: 2

Views: 6579

Answers (3)

ncs
ncs

Reputation: 454

date('Y-m-d H:i:s') OR use NOW() OR set default value to collumn CURRENT_TIMESTAMP

Upvotes: 0

baton
baton

Reputation: 297

INSERT INTO my_table (service_name,service_status,service_comment,user_name,updated_at) VALUES($service_name,$service_status,$service_comment,$user_name,NOW())

For mode details, see reference for NOW() function.

Upvotes: 1

deceze
deceze

Reputation: 522616

Use a date format that MySQL understands:

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

Upvotes: 8

Related Questions