PHP strtotime and MySQL date format

Question

I'm trying to get my function to add 1 day to the date I send it ,but I can;t figure out how to match the MySQL formatting. I've currently got:

$result = mysql_query($query);
$lastdate = mysql_result($result, 0, 'date');
$date = strtotime(date("Y-m-d", strtotime($lastdate)) . " +1 day");

I know the $date = line is incorrect somewhere, but I don't understand the function too well. It's being given the date in the format YYYY-mm-dd ($query is just getting the last date in the database), due to how MySQL stores dates.
I'm guessing that using the strtotime function isn't the right thing to do, or I've got the format/idea all wrong.
Thanks for any help, this is annoying me now :(

What type of data is in your 'date' column? Integer? Date? Datetime? — Jeff Lambert
– Jeff Lambert, Commented Oct 11, 2011 at 20:50

Levi Morrison · Accepted Answer · 2013-02-06 15:30:37Z

5

I think you want $date = date("Y-m-d", strtotime("+1 day", $lastdate)).

You may need to convert $lastdate using strtotime.

edited Feb 6, 2013 at 15:30

answered Oct 11, 2011 at 20:49

Levi Morrison

19.6k8 gold badges69 silver badges87 bronze badges

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

Comments

Daren Chandisingh · Accepted Answer · 2011-10-11 21:09:35Z

0

You could just add 86400 seconds to the result from strtotime(), since that returns an integer number of seconds since 1/1/1970, and there are 86400 seconds in a day.

$lastdate = '2011-10-11 22:07:11';
$date = date("Y-m-d", strtotime($lastdate) + 86400);
echo $date;

Outputs:

2011-10-12

answered Oct 11, 2011 at 21:09

Daren Chandisingh

2,1631 gold badge13 silver badges17 bronze badges

2 Comments

Levi Morrison Over a year ago

You could do that. . . but it isn't as clear what you are doing.

Daren Chandisingh Over a year ago

Personally, I think it's clear; but I recognise it as the number of seconds in a day. It could be written as (60*60*24), or commented to make it clearer.

Collectives™ on Stack Overflow

PHP strtotime and MySQL date format

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related