Range with dates?

[andrin]

I have a form with two input fields where the user puts in two dates in the format YYYY-MM-DD. They post the form and when they do this I want to create a array with dates stretching from one date to the other.

Example.
The user puts in 2002-02-04 and 2002-02-10 and posts it. How (the best way) do I create an array looking like this:

arrDates = array("2002-02-04", "2002-02-05", "2002-02-06", "2002-02-07", "2002-02-08", "2002-02-09", "2002-02-10");

Should I use range() or will I be forced to make a loop?

Would be grateful over an example :-)

Tnx in advance
/Andrin

[Anon]

Convert it into a timestamp, keep adding a day, and then convert back to your yyyy-mm-dd format.

Diego

[andrin]

Tnx Diego :-)

[andrin]

Tnxs do Diego I got the following solution (for the one whos interested):

$timeFrom = strtotime($POST["inputPeriodFrom"]);
$timeTo = strtotime($POST["inputPeriodTo"]);

$arrDateSpan = array();
for ($n = $timeFrom; $n <= $timeTo; $n += 86400)
{
$strDate = date("Y-m-d", $n);
array_push($arrDateSpan, $strDate);
}

I think it´s a pretty neet solution. If someone have anything "better". Please mail me or do a post on this thread :-)

Cheers
/Andrin

[[deleted]]

Q: what do you want to use this array of dates for?

[andrin]

Well... I´m working with a system integration (Navision XAL). The system has different "resources" that have a "capacity". This capacity can be either free or reserved. Each resource will be displyed on one line and each day will be a table cell. Now I know I can solve this by getting a bigger RecordSet with one call to the DB by selecting all activities between these two dates but that´s a later isue :-)
This is working fine for the time being.