ADDING DAYS TO DATES

[Anon]

Hi!

I need to work out the difference between two dates:

$todate=$toyear.$tomonth.$today;
$fromdate=$fromyear.$frommonth.$fromday;

Fine

Then I need to start with the from date, and then add a day on to it until I reach the to date.

$days=$todate-$fromdate;

Can anyone help me with this so that it will handle the month changing and/or the year too?

Something like:

for ($counter = 0; $counter < $days; $counter++) {

$bookdate=mysql_dateadd($fromdate, INTERVAL $counter+1 DAY);

}

(That code doesn't work, but I think it's a start???)

Thanks

[Anon]

$d1 = mktime(0,0,0,$frommonth,$fromday,$fromyear);
$d2 = mktime(0,0,0,$tomonth,$today,$toyear);
$days_diff = ($d2 - $d1)/(3600*24);

[Anon]

Thanks Shu

I'll need to do that to get the difference, but help! How do I then do:

fromdate + 1
fromdate + 2
fromdate + n

but still take account of months and years?

Thanks

Elizabeth

[cordex]

Look at the date() function.

If you know the current timestamp and the difference, you can find the timestamp of the target day and put it into whatever form you like.

[Anon]

You should always do your calculations in a non-string date format. mktime() will give you an integer timestamp, and you can use date() to convert the timestamp to any string format you want:

$nDaysfromD1 = $d1 + (606024*$n);

Assuming $d1 is a timestamp from mktime(), and 606024 seconds in a day.