Generate and insert date into MySQL database using php

Question

I used following code to insert the yesterday date into my_table of MySQL database. It worked fine in WAMP and MAMP. But it doesn't work in my host. What would be the reason Please help...

$dt = new DateTime();

$d = date_add($dt,date_interval_create_from_date_string("-1 days"));

$date = $d->format('Y-m-d');

$import="INSERT into my_table (date) Values('$date')”;

mysql_query($import) or die(mysql_error());

where is the code of this function? `date_interval_create_from_date_string()` — Sumit Bijvani, Feb 17 '14 at 11:11

score 4 · Accepted Answer · answered Feb 17 '14 at 11:16

4

Maybe your host doesn't support the DateTime() function ...

Try with date() and strtotime() functions :

$today = time();
$yesterday = date('Y-m-d H:i:s', strtotime('-1 day', $today));

answered Feb 17 '14 at 11:16

Antoine Subit

9,803
4
36
52

1

Of cause that was the problem and this works fine. Thank you! – Dexpras Feb 17 '14 at 11:33
You're welcome, for more informations on **strtotime()** : http://www.php.net/manual/en/function.strtotime.php – Antoine Subit Feb 21 '14 at 09:50

score 1 · Answer 2 · edited May 23 '17 at 11:44

1

Remove ” and use "

$date = new DateTime();
$date->add(DateInterval::createFromDateString('yesterday'));
$YesterdayDate = $date->format('Y-m-d H:i:s');

$import="INSERT into my_table (`date`) Values('$YesterdayDate')";
                                               .....^

NOTE: Use mysqli_* OR PDO functions instead of mysql_* functions(deprecated)

edited May 23 '17 at 11:44

Community

1
1

answered Feb 17 '14 at 11:11

Krish R

22,583
7
50
59

Thank you but here it works both the way. So this wasn't the problem. – Dexpras Feb 17 '14 at 11:29
@user3206125, Thanks to pointing. For the better practice you need to use `"` – Krish R Feb 17 '14 at 11:34

Generate and insert date into MySQL database using php

2 Answers2