Inserting a datetime value from php into MySQL

Question

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

datetime field format is mile away from "D, d M Y H:i:s O" one — Your Common Sense
– Your Common Sense, Commented Sep 9, 2010 at 9:03
@James In addition to what @Col says, you need to wrap the values in quotes. '$updated_at'... — Pekka
– Pekka, Commented Sep 9, 2010 at 9:05
Thanks for the reply col. What change should i make to the code ? — James
– James, Commented Sep 9, 2010 at 9:06
Inline values? C'mon, you're asking for trouble. Use parametrized query, it'll take care of quotes for you. — vartec
– vartec, Commented Sep 9, 2010 at 9:08

deceze · Accepted Answer · 2010-09-09 09:06:37Z

8

Use a date format that MySQL understands:

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

answered Sep 9, 2010 at 9:06

deceze♦

525k89 gold badges806 silver badges954 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

baton · Accepted Answer · 2010-09-09 09:11:15Z

1

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.

answered Sep 9, 2010 at 9:11

baton

2971 silver badge3 bronze badges

1 Comment

Your Common Sense Over a year ago

do not reproduce the OP's mistakes in your answer, but rather correct them

ncs · Accepted Answer · 2010-09-09 09:18:52Z

0

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

answered Sep 9, 2010 at 9:18

ncs

4541 gold badge3 silver badges13 bronze badges

Collectives™ on Stack Overflow

Inserting a datetime value from php into MySQL

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related