Sorting PHP array using subkey-values

Question

I have an array that looks something like this:

Array
(
    [Erik] => Array
    ( 
        [count] => 10
        [changes] => 1
    )
    [Morten] => Array
    (
        [count] => 8
        [changes] => 1
    )
)

Now, the keys in the array are names of technicians in our Helpdesk-system. I'm trying to sort this based on number of [count] plus [changes] and then show them. I've tried to use usort, but then the array keys are replaced by index numbers. How can I sort this and keep the array keys?

uasort: php.net/manual/en/function.uasort.php

Felix Kling
– Felix Kling

2011-07-04 10:23:33 +00:00
Commented Jul 4, 2011 at 10:23 — Felix Kling
– Felix Kling, Commented Jul 4, 2011 at 10:23
possible duplicate of Sorting multidimensional array in PHP

hakre
– hakre

2011-07-04 10:26:27 +00:00
Commented Jul 4, 2011 at 10:26 — hakre
– hakre, Commented Jul 4, 2011 at 10:26

johnhaggkvist · Accepted Answer · 2011-07-04 10:33:42Z

10

Try using uasort():

<?
function cmp($a, $b)
{
   return ($b['count'] + $b['changes']) - ($a['count'] + $a['changes']);
}

$arr = array(
   'John' => array('count' => 10, 'changes' => 1),
   'Martin' => array('count' => 5, 'changes' => 5),
   'Bob' => array('count' => 15, 'changes' => 5),
);

uasort($arr, "cmp");

print_r($arr);
?>

prints:

Array
(
   [Bob] => Array
   (
      [count] => 15
      [changes] => 5
   )
   [John] => Array
   (
      [count] => 10
      [changes] => 1
   )
   [Martin] => Array
   (
      [count] => 5
      [changes] => 5
   )
)

answered Jul 4, 2011 at 10:33

johnhaggkvist

3441 silver badge4 bronze badges

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

Comments

Dogbert · Accepted Answer · 2011-07-04 10:23:20Z

8

You should use uasort for this.

bool uasort ( array &$array , callback $cmp_function )

This function sorts an array such that array indices maintain their correlation with the array elements they are associated with, using a user-defined comparison function. This is used mainly when sorting associative arrays where the actual element order is significant.

answered Jul 4, 2011 at 10:23

Dogbert

224k43 gold badges419 silver badges416 bronze badges

Comments

Edoardo Pirovano · Accepted Answer · 2011-07-04 10:38:57Z

2

This should do what you need:

uasort($array, create_function('$a, $b', 'return (array_sum($a) - array_sum($b));'));

That sorts an array using the array_sum() function, and maintaining keys.

edited Jul 4, 2011 at 10:38

answered Jul 4, 2011 at 10:26

Edoardo Pirovano

8,3543 gold badges28 silver badges32 bronze badges

Comments

Hamid · Accepted Answer · 2011-07-04 10:31:16Z

1

Use this.i thin it works

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

usort ( $array, 'cmp' );

answered Jul 4, 2011 at 10:31

Hamid

1,7603 gold badges13 silver badges19 bronze badges

Comments

Community · Accepted Answer · 2023-11-17 20:11:10Z

0

I think you should use uasort which does exactly what you want (sort associative arrays mantaining the keys)

edited Nov 17, 2023 at 20:11

CommunityBot

11 silver badge

answered Jul 4, 2011 at 10:23

Nicola Peluchetti

76.9k32 gold badges150 silver badges197 bronze badges

Collectives™ on Stack Overflow

Sorting PHP array using subkey-values

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related