Sorting an associative array in PHP [duplicate]

Question

I have an array in this format:

Array
(
    [0] => Array
        (
            [text] => tests
            [language] => 
            [advertiserCompetitionScale] => 5
            [avgSearchVolume] => 7480000
            [lastMonthSearchVolume] => 9140000
        )

    [1] => Array
        (
            [text] => personality tests
            [language] => 
            [advertiserCompetitionScale] => 5
            [avgSearchVolume] => 165000
            [lastMonthSearchVolume] => 201000
        )

    [2] => Array
        (
            [text] => online tests
            [language] => 
            [advertiserCompetitionScale] => 5
            [avgSearchVolume] => 246000
            [lastMonthSearchVolume] => 301000
        )

)

How can I sort an array in that format, in the descending order of the avgSearchVolume field? Is there a built in function for this?

This is not an associative array ... but an array of associative arrays ;-) — Thomas Decaux
– Thomas Decaux, Commented Jul 10, 2012 at 10:56

hakre · Accepted Answer · 2011-10-06 11:54:56Z

111

Use usort and supply your own function to do the ordering, e.g.

function cmp($a, $b)
{
    return $b['avgSearchVolume'] - $a['avgSearchVolume'];
}

usort($array, "cmp");

edited Oct 6, 2011 at 11:54

hakre

200k55 gold badges453 silver badges865 bronze badges

answered Apr 22, 2009 at 14:55

Paul Dixon

302k54 gold badges315 silver badges349 bronze badges

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

3 Comments

vinrav Over a year ago

And also reading stackoverflow.com/questions/8456029/… also recomended

Jon Weers Over a year ago

Substitute return strcmp($a['key'],$b['key']); to compare strings

luukvhoudt Over a year ago

usort() doesn't maintain the key association, use uasort() to maintain the key association.

OIS · Accepted Answer · 2009-04-22 19:13:10Z

Until PHP 5.3 this is the best function for sorting based on subkeys without making a new function for each key.

function sortBySubkey(&$array, $subkey, $sortType = SORT_ASC) {
    foreach ($array as $subarray) {
        $keys[] = $subarray[$subkey];
    }
    array_multisort($keys, $sortType, $array);
}
sortBySubkey($arr, 'avgSearchVolume');

With PHP 5.3 you can make something like this, same function call as now.

function getSortVariable($sortType = SORT_ASC) {
    switch($sortType) {
        case SORT_ASC:
            return function ($a, $b) use ($subkey) { return strcmp($a[$subkey], $b[$subkey]); };
    }
}

function sortBySubkey(&$array, $subkey, $sortType = SORT_ASC) {
    $sortFunction = getSortVariable($sortType);
    usort($array, $sortFunction($subkey));
}

Community · Accepted Answer · 2023-11-17 19:32:19Z

8

You'll have to use a custom callback function together with usort().

function cmp($a, $b)
{
    if ($a['avgSearchVolume'] == $b['avgSearchVolume']) {
        return 0;
    }
    return ($a['avgSearchVolume'] > $b['avgSearchVolume']) ? -1 : 1;
}
usort($array, 'cmp');

edited Nov 17, 2023 at 19:32

CommunityBot

11 silver badge

answered Apr 22, 2009 at 14:54

Stefan Gehrig

83.9k24 gold badges162 silver badges193 bronze badges

2 Comments

Paul Dixon Over a year ago

While that will work, a comparison function should really return 0 if two elements being compared are equal.

Stefan Gehrig Over a year ago

You're right Paul - but as the sort-order is undefined in case of equality, a better solution would be to introduce another comparison to remove this uncertainty. Edited the answer accordingly.

Louis B. · Accepted Answer · 2016-12-19 15:58:42Z

2

function querySort ($first_Array,$second_Array) {
    return strcasecmp($first_Array['name'],$second_Array['name']);
}
echo '<pre>';
usort($main, 'querySort');

print_r($main);
die;

edited Dec 19, 2016 at 15:58

Louis B.

2,3681 gold badge31 silver badges52 bronze badges

answered Feb 5, 2014 at 9:36

dev4092

2,9111 gold badge18 silver badges15 bronze badges

1 Comment

Thom Over a year ago

A few words of explanation would make this code example even better.

Prasanth Bendra · Accepted Answer · 2013-02-20 05:07:17Z

Here is another solution, You can add multiple options for sorting(See the commented section of the code)

<?php

$arr=Array(
     Array("text" => "tests","language" =>"","advertiserCompetitionScale" => 5,"avgSearchVolume" => 7480000,"lastMonthSearchVolume" => 9140000),
     Array("text" => "personality tests","language" =>"","advertiserCompetitionScale" => 5,"avgSearchVolume" => 165000,"lastMonthSearchVolume"=>201000),
     Array("text" => "online tests","language" =>"","advertiserCompetitionScale" => 5,"avgSearchVolume" => 246000,"lastMonthSearchVolume" =>301000)
     );


$sort = array();
foreach($arr as $k=>$v) {
    $sort['avgSearchVolume'][$k] = $v['avgSearchVolume'];
    //$sort['text'][$k] = $v['text'];
}

array_multisort($sort['avgSearchVolume'], SORT_DESC, $arr);
//array_multisort($sort['avgSearchVolume'], SORT_DESC, $sort['text'], SORT_ASC,$arr);

echo "<pre>";
print_r($arr);

?>

REF: http://php.net/manual/en/function.array-multisort.php

Collectives™ on Stack Overflow

Sorting an associative array in PHP [duplicate]

5 Answers 5

3 Comments

Comments

2 Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

2 Comments

1 Comment

Comments

Linked

Related