How to sort JSON Array at second level using PHP

Question

I like to sort following JSON data by it's value salary using PHP in ascending order.

{
    "allresults": [
        {
            "results": [
                {
                    "Name": "Peter",
                    "salary": 1000
                }
            ]
        },
        {
            "results": [
                {
                    "Name": "Riya",
                    "salary": 999
                }
            ]
        }
    ]
}

Required Result:

Riya : 999
Peter : 1000

alexn · Accepted Answer · 2014-08-07T10:42:42.567

3

You can write a custom sort function using uasort. Something like this should work for you:

$data = json_decode($json, true);

uasort($data['allresults'], function($a, $b) {
    $aSalary = $a['results'][0]['salary'];
    $bSalary = $b['results'][0]['salary'];

    return $aSalary - $bSalary;
});

foreach($data['allresults'] as $item) {
    printf("%s: %d<br />", $item['results'][0]['Name'], $item['results'][0]['salary']);
}

edited Aug 07 '14 at 10:42

answered Aug 07 '14 at 06:54

alexn

57,867
14
111
145

+1 In `uasort` you could even remove those 2 extra variables – Marcin Nabiałek Aug 07 '14 at 06:55
The function should return `$bSalary - $aSalary`. It's supposed to return `-1`, `0`, or `1`, not `true/false`. – Barmar Aug 07 '14 at 07:04
@Barmar you are absolutely right, I got a bit lazy there. – alexn Aug 07 '14 at 10:39

score 0 · Answer 2 · answered Aug 07 '14 at 06:48

0

play with this :

$jsonIterator = new RecursiveIteratorIterator(
        new RecursiveArrayIterator(your_json($file, TRUE)),
        RecursiveIteratorIterator::SELF_FIRST
    );

foreach ($jsonIterator as $key => $val) {
     //your control
}

answered Aug 07 '14 at 06:48

WhiteLine

1,919
2
25
53

I am bigner. If you will give an live example for above that will be great. – Alok Aug 07 '14 at 07:11

score 0 · Answer 3 · answered Aug 07 '14 at 06:56

0

1st json to php array -> $json_arr = json_decode($json, true);

after that -> you can use array_multisort http://php.net//manual/en/function.array-multisort.php

answered Aug 07 '14 at 06:56

rumaviio

1
1

How to sort JSON Array at second level using PHP

3 Answers3