Add date to MySQL using PHP

Question

I am trying to add current date to MySQL table using PHP. I have the following code:

$date = date('Y-m-d');
mysql_query("INSERT INTO book_order VALUES($date)")  or die (mysql_error());

MySQL returns this error:

Incorrect date value: '1996' for column 'date_order' at row 1

date_order attribute is type date.

I've tried to echo the $date value and prints out 2013-05-12

Why I can't add the date to the table and what is this strange 1996?

This may help: stackoverflow.com/questions/4588748/…

user1247034
– user1247034

2013-05-12 21:57:27 +00:00
Commented May 12, 2013 at 21:57 — user1247034
– user1247034, Commented May 12, 2013 at 21:57

Ragen Dazs · Accepted Answer · 2013-05-12 22:12:50Z

2

If you can send local date use:

mysql_query("INSERT INTO book_order VALUES(NOW())");

The your problem is because your SQL have an typo - $date variable must be quoted:

mysql_query("INSERT INTO book_order VALUES('$date')")  or die (mysql_error());

In addition, if this not work edit your question and paste the result from SQL EXPLAIN book_order

answered May 12, 2013 at 22:12

Ragen Dazs

2,1803 gold badges30 silver badges58 bronze badges

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

1 Comment

Dinesh Over a year ago

or in the format:(yyyy-mm-dd) - mysql_query("INSERT INTO book_order VALUES(format(NOW(),'YYYY-MM-DD')");

Siamak Motlagh · Accepted Answer · 2013-05-12 22:11:14Z

2

Use STR_TO_DATE :

$date = date('Y-m-d');
mysql_query("INSERT INTO book_order VALUES (STR_TO_DATE('".$date ."','%Y-%m-%d'))");

edited May 12, 2013 at 22:11

answered May 12, 2013 at 22:02

Siamak Motlagh

5,1547 gold badges47 silver badges66 bronze badges

1 Comment

Lukas Over a year ago

Read my comment on Owen's answer. You have to wrap the date string in quotes (not only PHP's string quotes, but quotes in the query too). Else, your input will be interpreted as math expression like MattyF stated in his comment on the question.

Lukas · Accepted Answer · 2013-05-12 22:05:33Z

1

tried

$date = date('Y-m-d');
mysql_query("INSERT INTO book_order VALUES('$date')")  or die (mysql_error());

????

edited May 12, 2013 at 22:05

Lukas

1,4898 silver badges20 bronze badges

answered May 12, 2013 at 21:52

owenmelbz

6,60618 gold badges70 silver badges122 bronze badges

1 Comment

Lukas Over a year ago

Either escape the quotes in the query like \" (which is MySQL-spcific syntax) or use ' (which is standard SQL syntax). Can't understand the downvote, comment instead. Suggested an edit to correct the errors.

Nwafor · Accepted Answer · 2013-05-12 21:58:43Z

0

try this

$date = date('Y-m-d');
mysql_query("INSERT INTO book_order VALUES('$date')")  or die (mysql_error());

answered May 12, 2013 at 21:58

Nwafor

1826 bronze badges

Collectives™ on Stack Overflow

Add date to MySQL using PHP

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

1 Comment

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related