PHP - sort array by 2 values

Question

Consider this multidimensional array:

array(4) {
  [0]=>
  array(2) {
    ["number1"]=>
    int(100)
    ["number2"]=>
    int(24)
  }
  [1]=>
  array(2) {
    ["number1"]=>
    int(100)
    ["number2"]=>
    int(22)
  }
  [2]=>
  array(2) {
    ["number1"]=>
    int(300)
    ["number2"]=>
    int(30)
  }
  [3]=>
  array(2) {
    ["number1"]=>
    int(200)
    ["number2"]=>
    int(23)
  }
}

I need this array to be sorted ascending by the key 'number1'. If the number1 values of multiple arrays are the same, the array needs to be sorted ascending by the key 'number2'. Eventually, this needs to be the outcome:

array(4) {
  [0]=>
  array(2) {
    ["number1"]=>
    int(100)
    ["number2"]=>
    int(22)
  }
  [1]=>
  array(2) {
    ["number1"]=>
    int(100)
    ["number2"]=>
    int(24)
  }
  [2]=>
  array(2) {
    ["number1"]=>
    int(200)
    ["number2"]=>
    int(23)
  }
  [3]=>
  array(2) {
    ["number1"]=>
    int(300)
    ["number2"]=>
    int(30)
  }
}

I have read the PHP manual about the array_multisort() function and read some stackoverflow posts about this, but i cannot make anything of it.

Hardik Solanki · Accepted Answer · 2015-12-28 10:34:23Z

3

You can do it using array_multisort(). Your code should be :

    $arr = array(
      array(
        "number1"=>100,
        "number2"=>24
      ),
      array(
        "number1"=>100,
        "number2"=>22
      ),
      array(
        "number1"=>300,
        "number2"=>30
      ),
      array(
        "number1"=>200,
        "number2"=>23
      ));
// Make a $tempArr for list of sort columns and their data to pass to array_multisort function  
    $tempArr = array();

    foreach($arr as $key=>$val) {
        $tempArr['number1'][$key] = $val['number1'];
        $tempArr['number2'][$key] = $val['number2'];
    }
// sort by number1 asc and then number2 asc
    array_multisort($tempArr['number1'], SORT_ASC, $tempArr['number2'], SORT_ASC,$arr);

    print_r($arr);

edited Dec 28, 2015 at 10:34

answered Dec 28, 2015 at 10:28

Hardik Solanki

3,2151 gold badge21 silver badges30 bronze badges

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

2 Comments

Beeelze Over a year ago

Thanks, this should work. I have tested it with my sample array and I got the desired output. I'm not sure how array_multisort() actually works though.

Hardik Solanki Over a year ago

Glad to help you.. :)

Basheer Kharoti · Accepted Answer · 2015-12-28 10:33:55Z

0

What about sorting it through usort

$array = array( array('number' => 100, 'test' => 30),array('number' => 100, 'test' => 20),  array('number' => 40), array('number' => 60));
usort($array, "custom_sort");
// Define the custom sort function
function custom_sort($a,$b) {
  return $a['number'] > $b['number'];
}

Output

echo '<pre>';print_r($array );
Array
(
    [0] => Array
        (
            [number] => 40
        )

    [1] => Array
        (
            [number] => 60
        )

    [2] => Array
        (
            [number] => 100
            [test] => 20
        )

    [3] => Array
        (
            [number] => 100
            [test] => 30
        )

)

edited Dec 28, 2015 at 10:33

answered Dec 28, 2015 at 10:27

Basheer Kharoti

4,3025 gold badges27 silver badges51 bronze badges

Collectives™ on Stack Overflow

PHP - sort array by 2 values

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related