PHP array sorting by category + array data

Question

$data = [
           [
             'cat'=>'A',
             'catOrder'=>2,
              'data'=>[
                        ['name'=>'user', 'order'=>2],
                        ['name'=>'user', 'order'=>1],
                        ['name'=>'user', 'order'=>3]
                      ]
           ],
           [
             'cat'=>'B',
             'catOrder'=>1,
              'data'=>[
                        ['name'=>'user', 'order'=>2],
                        ['name'=>'user', 'order'=>1]
                      ]
           ]
        ]

what is the best way to sort the above array in php by first "catOrder" and then also by "order" field in data array

I tried using first

foreach($data as &$row){ 
 usort($row['data'], function($a, $b){ return strcmp($a['order'], 
     $b['order']);});
}

and then

uasort($data, function($a, $b){ return strcmp($a['catOrder'], $b['catOrder'])});

It seems to be working but I just wanted to know if there is any better and more efficient way?

Possible duplicate of How to sort an array of associative arrays by value of a given key in PHP? — miken32
– miken32, Commented Dec 3, 2018 at 23:47
array_multisort() would be your best bet. Use array_column() to get the sort values. — miken32
– miken32, Commented Dec 3, 2018 at 23:48

ebcode · Accepted Answer · 2018-12-04 07:37:01Z

ksort will be faster than than usort (I'm fairly certain), so I think you can shave off a few ms by converting

foreach($data as &$row){ 
    usort($row['data'], function($a, $b){ return strcmp($a['order'], 
 $b['order']);});
}
uasort($data, function($a, $b){ return strcmp($a['catOrder'], $b['catOrder'])});

To:

foreach($data as $row){
    foreach($row['data'] as $v){
        $row['data'][$v['order']-1] = $v; //assuming 'order' starts at 1
    }
    ksort($row['data']);
    $data[$row['catOrder']-1] = $row; //assuming 'catOrder' starts at 1
}
ksort($data);

You add a few operations with the assignment, but you make up for it in the sort. I did some very basic benchmarks, and the speed increase appears to be somewhere around 50%. This is at the cost of additional ram, though, since I've removed the & from the arrays, resulting in a copy.

Collectives™ on Stack Overflow

PHP array sorting by category + array data

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related