I am trying to insert current date (in d-m-Y) in a prepared statement into mysql table. I can't get the code right. I am calling current date in php by and then including in a prepared statement like this In the table, the date does not get inserted. It remains 0000-00-00. How can I rectify this? Answer You should use

Inserting date in PHP prepared statements

I am trying to insert current date (in d-m-Y) in a prepared statement into mysql table. I can’t get the code right. I am calling current date in php by

$dat = date("d-m-Y");

JavaScript
​x
 
$dat = date("d-m-Y");​

and then including in a prepared statement like this

$stmt = $mysqli->prepare("INSERT INTO mytable (name, date) VALUES (?, ?)");
$stmt->bind_param('ss', $name, $dat);
$reslt = $stmt->execute();

JavaScript
 
$stmt = $mysqli->prepare("INSERT INTO mytable (name, date) VALUES (?, ?)");$stmt->bind_param('ss', $name, $dat);$reslt = $stmt->execute();​

In the table, the date does not get inserted. It remains 0000-00-00. How can I rectify this?

Answer

You should use the YYYY-MM-DD format:

$dat = date("Y-m-d");

JavaScript
 
$dat = date("Y-m-d");​

Advertisement

Answer