pix.l|ne 's Journal » 2006

June 2006
M	T	W	T	F	S	S
« May		Jul »
	1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30

PHP detect date ranges in a series of dates

I needed to display a list of dates by collating dates that are next to each other into "date ranges".

If the dates are siblings (next to each other, like today, yesterday and the day before yesterday), put the startdate-enddate and then put following dates, if they stand alone, separated with commas, or as other date ranges.

So for example:
The dates are '1973-10-16', '1973-10-17', '1973-10-18', '1973-10-19', '1973-10-22'

And it should be shown as

"1973-10-16 to 1973-10-19, 1973-10-22"

This is how i did it. If you can optimize it, i'm all ears !! Also, i can't seem to make it work with a UK date format... yet.

PLAIN TEXT

PHP:

function detectDateRanges($dates)
{
// $dates is an array
$result = array();
$tempDateRange = '' ;
foreach($dates as $index => $date) {
/*
Example: $dates=array('1973-10-16','1973-10-17','1973-10-18','1973-10-19','1973-10-22');
*/
if ($index != 0) {
$dayBeforeDate = strtotime('-1 day', strtotime($date));
$previousDateInArray = strtotime($dates[$index-1]);
/*
if previously stored date is NOT just before current date, separate them in returned array
*/
if ($previousDateInArray != $dayBeforeDate) {
if ($tempDateRange !== $dates[$index-1]) {
$tempDateRange .= ' to ' . $dates[$index-1];
}
/*
Store the previous tempValue and start a new temptative dateRange
*/
$result[] = $tempDateRange;
$tempDateRange = $date ;
}
} else {
$tempDateRange = $date ;
}
} // end foreach
/*
Finish processing the last date
*/
if ($tempDateRange !== $date) {
$tempDateRange .= ' to ' . $dates[$index];
} else {
$tempDateRange = $date ;
}
$result[] = $tempDateRange;
return $result;
}
$dates=array('1973-10-16','1973-10-17','1973-10-18','1973-10-19','1973-10-22');
echo '
<pre>';
print_r($dates);
$dateRanges = detectDateRanges($dates);
print_r($dateRanges);

Author: pixeline
Date: June 28th, 2006
filed in: Design, Development
Follow the discussion on this entry via RSS 2.0 feed.

| Click to react on this

And now, a word from the president

refresh

Scruffs – Hardcore | JWT

This is the kind of pub i like �-]
Scruffs - Hardcore | JWT

Author: pixeline
Date: June 26th, 2006
filed in: General
Follow the discussion on this entry via RSS 2.0 feed.

| Click to react on this

And now, a word from the president

refresh

Watch the FIFA world cup 2006 live on your PC for free !

Would you like to watch the FIFA Worldcup in Germany for free but you do not have a TV ? here is how:

Download SopCast and install it
Register on their website
Open sopcast, and choose one of the Sport Channels (i usually pick SLT Public, it's in polish but i don't care and the image quality is excellent).