Add one month to existing time

[spinner0205]

Okay so I have a time in the format yyyy-mm-dd that is pulled from a MySQL array row and I need to add one month to it then echo that out. I assume it has something to do with the strtotime() and date() functions but I have tried every combination and cannot figure it out. Can I get some assistance please and thank you? Very very very new to php.

 

Here is what I have lol;

$row=mysql_fetch_array($result);
$ddaterow=$row['donation_date'];

 

Like I said the date will always be in the format yyyy-mm-dd

[codefossa]

function getTime($now, $length)
{
    $date = explode('-', $now);
    
    $then = strtotime($length, mktime(0, 0, 0, $date[1], $date[2], $date[0]));
    
    return date('Y-m-d', $then);
}

echo getTime('1992-04-19', '1 month');

 

Outputs

 

1992-05-19

[PFMaBiSmAd]

$new_date = date('Y-m-d',strtotime($row['donation_date'] . '+ 1 month'));

 

Or you can do this simply (and much faster) directly in your query -

 

SELECT donation_date + INTERVAL 1 MONTH as new_date .....

 

You would reference the value as $row['new_date']