PHP: Filter array by date range

Question

I have an array of objects. Each object includes a date value.

What's the best of filtering the array according to a specific date range, where the range is specified as startDate & endDate?

Update:

Thanks for your replies, I used this code in the end:

 foreach ($myArray as $key => &$value)
 {
      $d = DateTime::createFromFormat(self::DATE_FORMAT, $value["orderDate"]); 
      if ($d->getTimestamp() < $startDateTime->getTimestamp() || $d->getTimestamp() > $endDateTime->getTimestamp())
      {
           unset($myArray[$key]);
      }
 }

If by chance, these objects originated from a database, you could also alter your SQL query to return the results already sorted by date. You'd use the ORDER BY keywords.. — Lix
– Lix, Commented May 19, 2012 at 19:34

wallyk · Accepted Answer · 2012-05-19 20:34:11Z

4

This is the basic idea; you'll have to tweak it for your particular object type and date type.

foreach ($myarray as $item)
    if ($item->dateitem >= $startDate  &&  
        $item->dateitem <= $endDate)
            $newarray[] = $item;

edited May 19, 2012 at 20:34

answered May 19, 2012 at 19:32

wallyk

58.1k17 gold badges92 silver badges155 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2023-11-17 20:38:18Z

3

Assuming your object contains a string representation of a date, we'll convert it to a numeric timestamp using strtotime().

To filter out everything not in a given range (keeps values matching the start/end values):

 $rangeStart = strtotime('-1 year');
 $rangeEnd = strtotime('yesterday');

 array_filter( $array, function($var) use ($rangeStart, $rangeEnd) {
    $utime = strtotime($var->date);
    return $utime <= $rangeEnd && $utime >= $rangeStart;
 });

To sort the array by date:

 function cmp($a, $b) {
    $aTime = strtotime($a->date);
    $bTime = strtotime($b->date);

    if( $aTime === $bTime ) { return 0; }
    else { return $aTime < $bTime? -1 : 1; }
 }

 usort( $array, 'cmp' );

edited Nov 17, 2023 at 20:38

CommunityBot

11 silver badge

answered May 19, 2012 at 19:34

Kato

40.6k6 gold badges124 silver badges149 bronze badges

2 Comments

Amadan Over a year ago

Answers a different question.

Kato Over a year ago

Ha! I got half way through answering the question and forgot what I was answering. So you get sort too. Guess I'll go make some tea :)

Amadan · Accepted Answer · 2012-05-19 19:32:39Z

2

function inRange($thingy) {
  return $thingy->theDate >= $startDate && $thingy->theDate < $endDate;
}

$filtered = array_filter($unfiltered, "inRange");

answered May 19, 2012 at 19:32

Amadan

200k23 gold badges252 silver badges321 bronze badges

Collectives™ on Stack Overflow

PHP: Filter array by date range

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related