Check for consecutive dates within a set and return as range

by

Bit of a quick answer so sorry about the lack of implementation but assuming you are using 5.3 and the dates are ordered chronologically, you could convert each date to a DateTime object (if they aren’t already) and then iterate over the array using DateTime::diff() to generate a DateInterval object which you could use to compare the current date in the iteration with the last. You could group your consecutive dates into sub arrays and use shift() and pop() to get the first and last days in that sub array.

EDIT

I had a think about this. Pretty rough and ready implementation follows, but it should work:

// assuming a chronologically
// ordered array of DateTime objects 

$dates = array(
    new DateTime('2010-12-30'), 
    new DateTime('2011-01-01'), 
    new DateTime('2011-01-02'), 
    new DateTime('2011-01-03'), 
    new DateTime('2011-01-06'), 
    new DateTime('2011-01-07'), 
    new DateTime('2011-01-10'),
);

// process the array

$lastDate = null;
$ranges = array();
$currentRange = array();

foreach ($dates as $date) {    

    if (null === $lastDate) {
        $currentRange[] = $date;
    } else {

        // get the DateInterval object
        $interval = $date->diff($lastDate);

        // DateInterval has properties for 
        // days, weeks. months etc. You should 
        // implement some more robust conditions here to 
        // make sure all you're not getting false matches
        // for diffs like a month and a day, a year and 
        // a day and so on...

        if ($interval->days === 1) {
            // add this date to the current range
            $currentRange[] = $date;    
        } else {
            // store the old range and start anew
            $ranges[] = $currentRange;
            $currentRange = array($date);
        }
    }

    // end of iteration... 
    // this date is now the last date     
    $lastDate = $date;
}

// messy... 
$ranges[] = $currentRange;

// print dates

foreach ($ranges as $range) {

    // there'll always be one array element, so 
    // shift that off and create a string from the date object 
    $startDate = array_shift($range);
    $str = sprintf('%s', $startDate->format('D j M'));

    // if there are still elements in $range
    // then this is a range. pop off the last 
    // element, do the same as above and concatenate
    if (count($range)) {
        $endDate = array_pop($range);
        $str .= sprintf(' to %s', $endDate->format('D j M'));
    }

    echo "<p>$str</p>";
}

Outputs:

Thu 30 Dec
Sat 1 Jan to Mon 3 Jan
Thu 6 Jan to Fri 7 Jan
Mon 10 Jan

More Related Contents:

  1. PHP store hours, closed dates [closed]
  2. Adding days to $Date in PHP
  3. Convert seconds into days, hours, minutes and seconds
  4. I have 2 dates in PHP, how can I run a foreach loop to go through all of those days?
  5. Correctly determine if date string is a valid date in that format
  6. How to check if a date is in a given range?
  7. Checking if date is weekend PHP
  8. PHP get number of week for month
  9. Getting date format m-d-Y H:i:s.u from milliseconds
  10. Adding one day to a date
  11. The first day of the current month in php using date_modify as DateTime object
  12. Calculate age based on date of birth
  13. php date validation
  14. How to find the date of a day of the week from a date using PHP?
  15. PHP get start and end date of a week by weeknumber
  16. Get week number in month from date in PHP?
  17. PHP order array by date? [duplicate]
  18. how to convert php date formats to GMT and vice versa?
  19. PHP date format converting
  20. Date function output in a local language [duplicate]
  21. How to display a date as iso 8601 format with PHP
  22. Get most recent date from an array of dates in “Y-m-d H:i:s” format
  23. Format date from database?
  24. PHP strtotime +1 month adding an extra month [duplicate]
  25. PHP: How to check if a date is today, yesterday or tomorrow
  26. Get a PHP DateTime difference in days, considering midnight as a day change
  27. Next business day of given date in PHP
  28. What is the MM/DD/YYYY regular expression and how do I use it in php?
  29. In PHP given a month string such as “November” how can I return 11 without using a 12 part switch statement?
  30. Get date for monday and friday for the current week (PHP)

Leave a Comment