Incrementing an entered date

[newburcj]

I have a form with two text fields:

Date the show will open: $_POST['vdate'] (not the current date)

and

Number of performances: $_POST['shows']

 

vdate is entered in the format 'yyyy-mm-dd'.

 

I would like to take the original vdate, enter its value into a MySQL field, and increment the date by one day in a loop until the value of shows is reached. The loop isn't my problem. I can't seem to increment the date within the loop. There's a lot of date functions within php but none of them seem to be able to do this simple addition: newdate = date + 1 day. Help would be appreciated as I'm totally stuck.

 

Thanks!

[Deoctor]

so by all means u want to increase the date by one day. haven't u read the mysql documentation about date

 

SELECT DATE_ADD(CURDATE(), INTERVAL 1 DAY);

[newburcj]

Thank you, but I wish to increment the date using PHP.

[newburcj]

I finally figured out the code needed:

 

<?php

$TZ = date_default_timezone_set("America/New_York"); \\ if not already set.

$oldate = '2010-05-10';

$dd = strtotime($oldate) + 86400;

$newdate =  date("Y-m-d",$dd);  \\ newdate becomes '2010-05-11'

?

 

Thanks!

[oni-kun]

I finally figured out the code needed:

 

<?php

$TZ = date_default_timezone_set("America/New_York"); \\ if not already set.

$oldate = '2010-05-10';

$dd = strtotime($oldate) + 86400;

$newdate =  date("Y-m-d",$dd);  \\ newdate becomes '2010-05-11'

?

 

Thanks!

 

$newdate = strtotime('2010-05-10' . " +1 days");