Error when pass date from PHP to MYSQL database

Question

This is my PHP code to send a date to MYSQL, but when i open the management tool of my database i get this values: 0000-00-00 00:00:00 Mysql type is set to "datetime".

...    
$dataprova = date("Y-m-d H:i:s");   
$query = "INSERT INTO oxybet(data) VALUES ('&dataprova')";
if (mysql_query($query)) { 
   echo "ok";
   echo($dataprova); 
} else { 
   echo "error"; 
} 
...

While in my page i correctly obtain: 2014-04-20 15:22:15, db show 0000-00-00 00:00:00

What is the error?

There is no error. If you want to see the error, enable MYSQL strict mode. You're right now casting some stringy '&dataprova' to a date which is correctly 0000-00-00 00:00:00 as date. So no error. - Lesson one for Mysql debugging: Check what the actual query was. Don't fly blind. — hakre
– hakre, Commented Apr 20, 2014 at 13:28
You can prevent such errors to some degree by using parametrized queries or just good old sprintf() even. — hakre
– hakre, Commented Apr 20, 2014 at 13:32

Lucas Henrique · Accepted Answer · 2014-04-20 13:52:23Z

1

$query = "INSERT INTO oxybet(data) VALUES ('&dataprova')";

Change to:

$query = "INSERT INTO oxybet(data) VALUES ('$dataprova')";

answered Apr 20, 2014 at 13:52

Lucas Henrique

1,3641 gold badge11 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Error when pass date from PHP to MYSQL database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related