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
– Gumbo

2009-05-20 12:46:00 +00:00
Commented May 20, 2009 at 12:46 — Gumbo
– Gumbo, Commented May 20, 2009 at 12:46
The order of the row as it was created in the backend

Tom
– Tom

2009-05-20 12:53:56 +00:00
Commented May 20, 2009 at 12:53 — Tom
– Tom, Commented May 20, 2009 at 12:53

Tobias Cohen · Accepted Answer · 2009-05-20 12:46:18Z

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, 2009 at 12:46

Tobias Cohen

20k8 gold badges56 silver badges52 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:19:35Z

2

See here:

Sorting an associative array in PHP

for user-defined sorting.

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered May 20, 2009 at 12:47

Stefan Gehrig

83.9k24 gold badges162 silver badges193 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:13:35Z

0

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

Sorting JSON by values

edited May 23, 2017 at 12:13

CommunityBot

11 silver badge

answered May 20, 2009 at 12:45

Tahir Akhtar

11.7k7 gold badges46 silver badges69 bronze badges

Comments

Gumbo · Accepted Answer · 2009-05-20 12:48:47Z

0

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>";
}

answered May 20, 2009 at 12:48

Gumbo

657k112 gold badges792 silver badges852 bronze badges

Collectives™ on Stack Overflow

Sorting JSON Output in PHP

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related