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
– Sumit Bijvani, Commented Feb 17, 2014 at 11:11

Antoine Subit · Accepted Answer · 2014-02-17 11:16:09Z

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, 2014 at 11:16

Antoine Subit

9,9534 gold badges40 silver badges53 bronze badges

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

2 Comments

Dexpras Over a year ago

Of cause that was the problem and this works fine. Thank you!

Antoine Subit Over a year ago

You're welcome, for more informations on strtotime() : php.net/manual/en/function.strtotime.php

Community · Accepted Answer · 2017-05-23 11:44:17Z

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, 2017 at 11:44

CommunityBot

11 silver badge

answered Feb 17, 2014 at 11:11

Krish R

22.7k7 gold badges54 silver badges60 bronze badges

2 Comments

Dexpras Over a year ago

Thank you but here it works both the way. So this wasn't the problem.

Krish R Over a year ago

@user3206125, Thanks to pointing. For the better practice you need to use "

Collectives™ on Stack Overflow

Generate and insert date into MySQL database using php

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related