multi dimensional array sorting by string

Question

I'm breaking my head trying to figure out how to do this right, I have this multi dimensional array:

Array
(
    [0] => Array
        (
            [time] => November 1st 10:10
            [query] => movies
            [set] => 1
            [matches] => No matching results
            [results] => 5
        )

    [1] => Array
        (
            [time] => November 1st 10:10
            [query] => cinemas
            [set] => 1
            [matches] => No matching results
            [results] => 2
        )

)

In real life, there could be alot more sub-arrays, but et's say I want to sort it by "query" alphabetically, how can I achieve this?

I saw only solutions for integer type or key index, the end result, in this case, would be:

Array
    (
        [0] => Array
            (
                [time] => November 1st 10:10
                [query] => cinemas
                [set] => 1
                [matches] => No matching results
                [results] => 2
            )
        [1] => Array
            (
                [time] => November 1st 10:10
                [query] => movies
                [set] => 1
                [matches] => No matching results
                [results] => 5
            )

    )

Much appreciated, thanks.

Hammerite · Accepted Answer · 2011-11-01 08:35:27Z

23

function querySort ($x, $y) {
    return strcasecmp($x['query'], $y['query']);
}

usort($myArray, 'querySort');

edited Nov 1, 2011 at 8:35

answered Nov 1, 2011 at 8:26

Hammerite

22.5k6 gold badges76 silver badges103 bronze badges

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

1 Comment

Jimmy Adaro Over a year ago

Working as a charm for me.

Nick · Accepted Answer · 2011-11-01 09:18:50Z

I often use this function to sort multi dimensional arrays:

function sortmulti ($array, $index, $order, $natsort=FALSE, $case_sensitive=FALSE) {
         if(is_array($array) && count($array)>0) {
             foreach(array_keys($array) as $key) { 
                $temp[$key]=$array[$key][$index];
             }
             if(!$natsort) {
                 if ($order=='asc') {
                     asort($temp);
                 } else {    
                     arsort($temp);
                 }
             }
             else 
             {
                 if ($case_sensitive===true) {
                     natsort($temp);
                 } else {
                     natcasesort($temp);
                 }
                if($order!='asc') { 
                 $temp=array_reverse($temp,TRUE);
                }
             }
             foreach(array_keys($temp) as $key) { 
                 if (is_numeric($key)) {
                     $sorted[]=$array[$key];
                 } else {    
                     $sorted[$key]=$array[$key];
                 }
             }
             return $sorted;
         }
     return $sorted;
 }

Works a charm :)

Pesulap · Accepted Answer · 2018-01-17 13:12:55Z

1

agreed with @Hammerite answer, But here is a shortest way of doing this kind of sorting. You can achieve the same result starting from PHP 5.3, by using an anonymous function:

 usort($myArray, function($x, $y) {
       return strcasecmp($x['query'] , $y['query']);
 });

17.1. - only syntax fix

edited Jan 17, 2018 at 13:12

Pesulap

8948 silver badges19 bronze badges

answered Jan 10, 2016 at 9:56

Ahmed Syed

1,1994 gold badges18 silver badges47 bronze badges

Collectives™ on Stack Overflow

multi dimensional array sorting by string

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related