php mysqli insert date to DATE type

Question

$NOW = new DateTime();
$date = $NOW->format('Y-m-d'); // return 2018-05-17

I want to update date in database to now date.

Query:

$sql = "UPDATE table SET date = $date WHERE id = $id";

But it update time like this => 0000-00-00

The type of this column is DATE

Why? what I have done wrong?

Kawaljeet Singh · Accepted Answer · 2018-05-17T06:40:44.023

4

You can try mysql now() function to update date.

$sql = "UPDATE table SET date = now() WHERE id = $id";

Or you should add single qoutes in query

$sql = "UPDATE table SET date = '".$date."' WHERE id = $id";

edited May 17 '18 at 06:40

answered May 17 '18 at 06:36

Kawaljeet Singh

1

Is it return in this format? `Y-m-d` ? look like it return timestamp, right? – Jack The Baker May 17 '18 at 06:38
No, it will save date in Y-m-d format, because your mysql column is date type not timestamp. – Kawaljeet Singh May 17 '18 at 06:42

score 1 · Answer 2 · answered May 17 '18 at 06:40

1

Simply add your date value in quotes then try. Change your query to :

$sql = "UPDATE table SET date = '$date' WHERE id = $id";

answered May 17 '18 at 06:40

B. Desai

2 Answers2