Calculating the date 30 days from now?

webnewone

Hi,

I have a date value that I pull out of a mysql database and echo to the page. For example November 24 would display

2004-11-24

How do I use php to calculate and display 30 days from the above date (i.e. the date value pulled out of the database)?

Thanks for any input!

🙂

mattvenables

This really depends on how your date is formatted from the mySQL database.

However, let's just say that you can get the month, the day, and the year from the dB.

The following code will add 30 days to whatever date you have:

$thirtydays= mktime(0, 0, 0, $month, $day+30,  $year);

if you want to just add one month, this will do it:

$onemonth= mktime(0, 0, 0, $month+1, $day,  $year);

-Matt

webnewone

Thanks Matt - that worked perfectly!

😃

jannoy

this compute date works for me

ScubaDvr2

Well, if we were to assume all dates in your database were set up like this: YYYY-MM-DD there are a number of ways to do it. Similar to what matt said,

$string = '2004-11-24';

$break = explode('-', $string);
$year = $break[0];
$month = $break[1];
$day = $break[2];

$in_30_days = mktime(0, 0, 0, $month, ($day + 30), $year); //This will return UNIX timestamp
echo date('Y-m-d', $in_30_days); //echos the new date

//there's plenty of other ways but i figured i might as well go with matt's example