Sort JSON values by their value

Question

Here is my JSON file:

    {
"example": "1",
"example2": 2,
"text": "3",
"info": {
    "agent": 4,
    "sum": 5,
    "collection": [{
        "Name": "6",
        "Pic": "7"
    }, {
        "Name": "8",
        "Pic": "9"
    }, {
        "Name": "10",
        "Pic": "11"
    }]
     }

      }

I display the results of the JSON file in a foreach loop:

$data = json_decode(file_get_contents('http://linktojson.com'));
foreach($data->info->collection as $key){

    echo $key->Pic;
    echo $key->Name;

  }

As you can see, 'Pic' has different numbers. How would I use sort() to make the largest number display at the top of the foreach loop and the lowest display at the bottom?

array_multisort did this work for you – Murad Hasan May 24 '16 at 06:27 — Murad Hasan, May 24 '16 at 06:27

Murad Hasan · Answer 1 · 2016-05-24T06:55:37.823

-1

You need to use array_multisort here. Check Online

$json = '{
"example": "1",
"example2": 2,
"text": "3",
"info": {
    "agent": 4,
    "sum": 5,
    "collection": [{
        "Name": "6",
        "Pic": "7"
        }, {
            "Name": "8",
            "Pic": "9"
        }, {
            "Name": "10",
            "Pic": "11"
        }]
     }
}';

$result = json_decode ($json, true);
foreach($result  as $key => $value){
    if($key == 'info'){
        $keys = array_keys($value['collection']);
        array_multisort(
            array_column($value['collection'], 'Pic'), SORT_DESC, SORT_NUMERIC, $value['collection'], $keys
        );
        $value = array_combine($keys, $value['collection']);
        foreach($value as $val){
            echo $val['Pic']." - ".$val['Name']."<br/>";
        }
    }   
}

Result:

11 - 10
9 - 8
7 - 6

edited May 24 '16 at 06:55

answered May 24 '16 at 06:37

Murad Hasan

9,233
2
16
39

No, you don't: `usort($data->info->collection, function ($a, $b) { return $a->Pic - $b->Pic; })`. (Or perhaps with `$a` and `$b` reversed, I tend to forget.) – deceze May 24 '16 at 06:41
is this answer correct? – bob jomes May 24 '16 at 06:47
Why not???? Where is the problem? – Murad Hasan May 24 '16 at 06:48
OP use `Pic - name` and i use `Name - pic`, I need to update. – Murad Hasan May 24 '16 at 06:49
This answer may not be incorrect, but it's overly complicated when `usort` would be *much* simpler. – deceze May 24 '16 at 06:50
I don't know why but this answer doesn't display any JSON results. is there a way to debug it? – bob jomes May 24 '16 at 06:54
@deceze, The answer is correct, And there is a lots of way to do this, I use `arraymulti_sort` here. – Murad Hasan May 24 '16 at 06:54
Check the online example: [https://3v4l.org/1jh0u](https://3v4l.org/1jh0u) – Murad Hasan May 24 '16 at 06:55
@bobjomes, You need to check the online example... – Murad Hasan May 24 '16 at 07:01

Sort JSON values by their value

1 Answers1