ordering array in specific order [duplicate]

Question

I have following array

Array
(
[0] => Array
    (
        [label] => Germany
        [conversions] => 1
    )

[1] => Array
    (
        [label] => United States
        [conversions] => 8
    )

[2] => Array
    (
        [label] => France
        [conversions] => 1
    )

[3] => Array
    (
        [label] => China
        [conversions] => 1
    )

[4] => Array
    (
        [label] => Philippines
        [conversions] => 1
    )

[5] => Array
    (
        [label] => Turkey
        [conversions] => 1
    )

)

I want to order following array, first by conversions (desc), then by label (asc)

output will have following sequence:

United States
China
France
Germany
Philippines
Turkey

look on usort php.net/manual/en/function.usort.php

Haim Evgi
– Haim Evgi

2011-07-18 11:53:39 +00:00
Commented Jul 18, 2011 at 11:53 — Haim Evgi
– Haim Evgi, Commented Jul 18, 2011 at 11:53

hakre · Accepted Answer · 2011-07-18 12:17:13Z

4

If using >= PHP 5.3...

usort($arr, function($a, $b) {

   $diff = $b['conversions'] - $a['conversions'];

   if ( ! $diff) {
      return strcmp($a['label'], $b['label']);
   } 

   return $diff; 

});

It is relatively simple to make it work with < PHP 5.3.

edited Jul 18, 2011 at 12:17

hakre

200k55 gold badges454 silver badges866 bronze badges

answered Jul 18, 2011 at 11:54

alex

492k205 gold badges891 silver badges992 bronze badges

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

6 Comments

Core Xii Over a year ago

Typo in the second conversions index.

Spudley Over a year ago

note that functions can only be defined this way in PHP 5.3 and above. If you're using an older version of PHP, you'll need to define your function in the traditional way, and the second param of usort() would be the function name. (you may want to do this anyway, if you plan to use the same sorting function in more than one place)

hakre Over a year ago

@alex: Edited: The code did not work at all even in PHP 5.3 (it's not complete so gives syntax errors) and well, the sort order was wrong.

alex Over a year ago

@hakre: Thanks, I didn't test it. I would have if the OP gave the array in an easy copy + paste format. :)

hakre Over a year ago

@alex: little hint: visit my profile page and look into the grey box on the right. there is one link. I know perfectly how you feel ;)

|

Spudley · Accepted Answer · 2011-07-18 11:54:55Z

1

You need to use PHP's usort() function. This allows you to write a function which determines the sort order, so you can sort things into any order you like.

The function will be called repeatedly by the usort() algorithm, and will give you two parameters, being the two elements of the array that it wants to sort at any given moment. Your function should return -1 if the first of those two elements is bigger, +1 if it the second is bigger, and zero if they are to be considered the same for the purposes of the sort.

See the PHP manual page for more info and examples: http://php.net/manual/en/function.usort.php

answered Jul 18, 2011 at 11:54

Spudley

169k39 gold badges240 silver badges309 bronze badges

Comments

hakre · Accepted Answer · 2011-07-18 12:56:53Z

I preferred array_multisort ^{PHP Manual} in my answer below as you can specify the sort order with parameters.

Next to flexibility it should be faster than using usort which has the problem that it's not really parametrized for the sort order, so not re-inventing the wheel as well.

For more comfort, wrap it up into a function to specify the keys as strings (Demo):

$sorted = $multisortByKey($array, 'conversions', SORT_DESC, 'label', SORT_ASC);

as in:

$array = array(
  0 => array(
    'label' => 'Germany',
    'conversions' => 1,
  ),
  1 => array(
    'label' => 'United States',
    'conversions' => 8,
  ),
  2 => array(
    'label' => 'France',
    'conversions' => 1,
  ),
  3 => array(
    'label' => 'China',
    'conversions' => 1,
  ),
  4 => array(
    'label' => 'Philippines',
    'conversions' => 1,
  ),
  5 => array(
    'label' => 'Turkey',
    'conversions' => 1,
  ),
);

$multisortByKey = function(array $a) {
    $args = func_get_args();
    $a = array_shift($args);
    $extract = function($k) use($a) {return array_map(function($v) use($k) { return $v[$k]; }, $a); };
    # NOTE: The following check/for-loop is not entirely correct 
    # as multiple sort parameters per entry are allowed. I leave this
    # for practice.
    $c = count($args);
    if(!$c%2) throw new InvalidArgumentException('Parameter count mismatch');
    for($i=0;$i<$c;$i+=2)
        $args[$i] = $extract($args[$i]);
    $args[] = &$a;
    call_user_func_array('array_multisort', $args);
    return $a;
};

$sorted = $multisortByKey($array, 'conversions', SORT_DESC, 'label', SORT_ASC);

var_dump($sorted);

jeni · Accepted Answer · 2011-07-18 12:54:57Z

0

try this

$myArray="your array";

<?php

foreach($myArray as $c=>$key) {
    $sort_conv[$c] = $key['conversions'];
    $sort_lable[$c] = $key['label'];
   }

array_multisort($sort_conv, SORT_ASC, $sort_lable, SORT_STRING, $myArray);
print_r($myArray);
?>

edited Jul 18, 2011 at 12:54

answered Jul 18, 2011 at 12:01

jeni

4401 gold badge4 silver badges12 bronze badges

1 Comment

Faye D. Over a year ago

Actually this isn't correct. Indeed your proposed code sorts at first by conversions in ascending order, but as a second sorting criteria OP didn't ask for an alphabetical sorting, but rather using a specific sorting country criterion...

Kerrek SB · Accepted Answer · 2011-07-18 11:55:24Z

0

You can use usort to provide your own sorting function

usort($a, function($x, $y) {
  return $y["conversions"] < $x["conversions"] ? 1 :
    ($x["conversions"] < $y["conversions"] ? -1 :
      strcmp($x["label"], $y["label"]))
    );
});

answered Jul 18, 2011 at 11:55

Kerrek SB

481k96 gold badges904 silver badges1.1k bronze badges

Comments

hakre · Accepted Answer · 2011-07-18 12:11:44Z

0

Try the following: (didn't test it, source: PHP Example #3)

foreach ($data as $key => $row) {
    $label[$key]   = $row['label'];
    $conversion[$key] = $row['conversion'];
}

array_multisort($conversion, SORT_DESC, $label, SORT_ASC, $data);

edited Jul 18, 2011 at 12:11

hakre

200k55 gold badges454 silver badges866 bronze badges

answered Jul 18, 2011 at 11:53

Sascha Galley

16.2k5 gold badges39 silver badges52 bronze badges

Collectives™ on Stack Overflow

ordering array in specific order [duplicate]

6 Answers 6

6 Comments

Comments

Comments

1 Comment

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

6 Comments

Comments

Comments

1 Comment

Comments

Comments

Linked

Related