PHP sort multidimensional array by date

Question

I'm having a problem. I have a multidimensional array, that looks like this:

Array ( [0] => 
              Array ( 
                    [0] => Testguy2's post. 
                    [1] => testguy2 
                    [2] => 2013-04-03 
              ) 

        [1] => Array ( 
                    [0] => Testguy's post. 
                    [1] => testguy 
                    [2] => 2013-04-07 
              ) 
);

I want to sort the posts from the newest date to the oldest date, so it looks like this:

Array ( [1] => Array ( 
                     [0] => Testguy's post. 
                     [1] => testguy 
                     [2] => 2013-04-07 
               ) 
        [0] => Array ( 
                     [0] => Testguy2's post. 
                     [1] => testguy2 
                     [2] => 2013-04-03
               ) 
);

How do I sort it?

472084 · Accepted Answer · 2020-06-11 15:44:45Z

6

function cmp($a, $b){

    $a = strtotime($a[2]);
    $b = strtotime($b[2]);

    if ($a == $b) {
        return 0;
    }
    return ($a < $b) ? -1 : 1;
}

usort($array, "cmp");

Or for >= PHP 7

usort($array, function($a, $b){
    return strtotime($a[2]) <=> strtotime($b[2]);
});

edited Jun 11, 2020 at 15:44

answered Apr 7, 2013 at 15:25

472084

17.9k10 gold badges67 silver badges82 bronze badges

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

Comments

Alain · Accepted Answer · 2013-04-07 15:39:46Z

4

You can do it using usort with a Closure :

usort($array, function($a, $b) {
    $a = strtotime($a[2]);
    $b = strtotime($b[2]);
    return (($a == $b) ? (0) : (($a > $b) ? (1) : (-1)));
});

answered Apr 7, 2013 at 15:39

Alain

37.1k18 gold badges128 silver badges160 bronze badges

Comments

Andreas3204 · Accepted Answer · 2013-04-07 15:28:13Z

2

I'm just stepping away from my desk for the day so I can't offer specifics. But here's a good place to get started that includes examples: array_multisort

answered Apr 7, 2013 at 15:28

Andreas3204

1421 silver badge9 bronze badges

Comments

Maneesh Sharma · Accepted Answer · 2016-09-17 08:07:04Z

0

$dates = array();       
foreach($a AS $val){
    $dates[] = strtotime($val[2]);
}
array_multisort($dates, SORT_ASC, $a);

answered Sep 17, 2016 at 8:07

Maneesh Sharma

241 bronze badge

1 Comment

zx485 Over a year ago

It would be considered to be nice to add some explanation around your code.

Collectives™ on Stack Overflow

PHP sort multidimensional array by date

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related