function to return dates between 2 given dates

elacdude

im looking for a function that will return dates between two given dates.

example:
somedatefunction ("03/05/2001", "05/23/2002");

then maybe it would return an array of dates inbetween those dates.

can anyone help?

thanks

trooper

Are you trying to do this from a database or purely from php ?

Sphynx

Ok, I hate dates :p but here's a try at it. Just returns a simple 1D array using split()

<?php
/* FUNCTION TAKES THE STARTING DATE AND END DATE AS STRING
   AND FINDS ALL THE DATES BETWEEN THEM, SPLITS AND RETURNS SIMPLE ARRAY */

function listdates($startdate,$enddate){
$startdate = strtotime($startdate);
$enddate = strtotime($enddate);
$i = $startdate;

  while($i <= $enddate) {
    $dates = $dates."-".date("F d, Y",$i);
    $i = $i + 86400;
  }	 
$ardates = split("-",$dates);
return $ardates;
}
/**************************************/

/* DATES FROM FORM, URL, ETC */
$startdate = "January 15, 2003";
$enddate = "February 10, 2003";


$mydates = listdates($startdate,$enddate);
echo count($mydates)." days between ".$startdate." and ".$enddate."...<br>";

/* LOOP THRU AND LIST THE DATES JUST TO SEE */
for($i = 0; $i <= count($mydates);$i++){
   echo $mydates[$i]."<br>";
}
?>

I'll work on a more elegant approach this, I think. Hope this helps though!

EDIT: Blah, a bug. Starting the loop like I did leaves ardates[0] empty. All the dates are there, but they start at [1]. Hmmm. Suggestions are welcome! 🙂

elacdude

purely php. its for a hotel reservation form. they select their check in date and check out date. but the problem is that the prices are different for weekdays, holidays, and weekends. if i have a date, i can find out if its one of those and generate a price... but the hard part is finding the dates because not all months have the same days and that goes for years too.

thanks

elacdude

holy crap. that helps out tremendously. thanks very much