Sorting JSON Output in PHP

Question

I've got the following JSON:

{
"row":  [
    {
    "sort":3,
    "type":"fat",
    "widgets":
        [
            {"values": [3,9] },
            {"values": [8,4] }                  
        ]
    },
{
    "sort":2,
    "type":"three",
    "widgets":
    [
        {"values": [3,4] },
        {"values": [12,7] },
        {"values": [12,7] }                         
    ]
}                       
]
}

And this PHP to output it:

foreach ( $value->row as $therow )
{
    echo "<div class='row ".$therow->type."'>";

    foreach ( $therow->widgets as $thewidgets )
    {
        echo "<div class='widget'>";
        echo $thewidgets->values[0];
        echo "</div>";

    }

    echo "</div>";

}

What I would like to do is sort the ouput based on the sort value in the JSON, any ideas?

And what kind of sort would be “2” or “3”? – Gumbo May 20 '09 at 12:46 — Gumbo, May 20 '09 at 12:46
The order of the row as it was created in the backend – Tom May 20 '09 at 12:53 — Tom, May 20 '09 at 12:53

score 4 · Accepted Answer · answered May 20 '09 at 12:46

4

Use usort:

function my_sort($a, $b)
{
    if ($a->sort < $b->sort) {
        return -1;
    } else if ($a->sort > $b->sort) {
        return 1;
    } else {
        return 0;
    }
}

usort($value->row, 'my_sort');

answered May 20 '09 at 12:46

Tobias Cohen

19,480
7
51
51

score 2 · Answer 2 · edited May 23 '17 at 12:19

2

See here:

Sorting an associative array in PHP

for user-defined sorting.

edited May 23 '17 at 12:19

Community

1
1

answered May 20 '09 at 12:47

Stefan Gehrig

78,962
24
149
181

score 0 · Answer 3 · edited May 23 '17 at 12:13

0

See following if you want to do it on client side.

Sorting JSON by values

edited May 23 '17 at 12:13

Community

1
1

answered May 20 '09 at 12:45

Tahir Akhtar

10,902
7
40
67

score 0 · Answer 4 · answered May 20 '09 at 12:48

Just sort the data before printing it in the second foreach loop:

foreach ($value->row as $therow) {
    if ($therow->sort == 2) {
        // sort $therow->widgets according to whatever sort 2 means
    } elseif ($therow->sort == 3) {
        // sort $therow->widgets according to whatever sort 3 means
    }
    echo "<div class='row ".$therow->type."'>";
    foreach ($therow->widgets as $thewidgets) {
        echo "<div class='widget'>";
        echo $thewidgets->values[0];
        echo "</div>";
    }
    echo "</div>";
}

Sorting JSON Output in PHP

4 Answers4

Linked