Force sorting json in PHP

Question

How can I sort label in order:

I've tried all Sorting Arrays in PHP documentation and some another "User Defined" sorting functions, but no luck, it shows completely random, not in order.

My original json:

[{"file":"***","label":"360p","default":"true","type":"video\/mp4"},
{"file":"***","label":"720p","type":"video\/mp4"},
{"file":"***","label":"1080p","type":"video\/mp4"},
{"file":"***","label":"480p","type":"video\/mp4"}]

Remove "p" from the element with explode() of each label of the array, then use intval() function to get int value of the string. Then sort by depending index — Roger RV
– Roger RV, Commented Jun 6, 2017 at 7:27

arkascha · Accepted Answer · 2017-06-07 07:40:00Z

2

This looks pretty straight forward to me, you use a custom comparison function for the sorting:

<?php
$data = json_decode(<<<JSON
[{"file":"***","label":"360p","default":"true","type":"video\/mp4"},
{"file":"***","label":"720p","type":"video\/mp4"},
{"file":"***","label":"1080p","type":"video\/mp4"},
{"file":"***","label":"480p","type":"video\/mp4"}]
JSON
);

usort($data, function($a, $b) {
  return intval($a->label) < intval($b->label);
});
print_r($data);

The output obviously is:

Array
(
    [0] => stdClass Object
        (
            [file] => ***
            [label] => 1080p
            [type] => video/mp4
        )

    [1] => stdClass Object
        (
            [file] => ***
            [label] => 720p
            [type] => video/mp4
        )

    [2] => stdClass Object
        (
            [file] => ***
            [label] => 480p
            [type] => video/mp4
        )

    [3] => stdClass Object
        (
            [file] => ***
            [label] => 360p
            [default] => true
            [type] => video/mp4
        )

)

edited Jun 7, 2017 at 7:40

answered Jun 6, 2017 at 7:33

arkascha

43.2k8 gold badges61 silver badges97 bronze badges

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

2 Comments

Scott Willsleans Over a year ago

Really thanks for your help, but Sahil's answer already solved my problem.

mickmackusa Over a year ago

@ScottWillsleans You should use this method in your project. There is no need to declare/overwrite variables on each iteration of usort() This is the more concise solution.

Sahil Gulati · Accepted Answer · 2017-06-06 07:27:35Z

1

Here we are using usort to achieve desired output.

Try this code snippet here

<?php

ini_set('display_errors', 1);
$json='[{"file":"***","label":"360p","default":"true","type":"video\/mp4"},
{"file":"***","label":"720p","type":"video\/mp4"},
{"file":"***","label":"1080p","type":"video\/mp4"},
{"file":"***","label":"480p","type":"video\/mp4"}]';
$array=json_decode($json,true);

usort($array, function($value1,$value2){
    $value1["label"]=rtrim($value1["label"],"p");
    $value2["label"]=rtrim($value2["label"],"p");

    return $value1["label"]<$value2["label"];
});

answered Jun 6, 2017 at 7:27

Sahil Gulati

15.2k4 gold badges28 silver badges43 bronze badges

Comments

Kyoya · Accepted Answer · 2017-06-06 07:38:18Z

-1

First you must decode the JSON string using json_decode.

Second sort the decoded array using usort.

<?php
$array = json_decode($json);
usort($array, function ($a, $b) {
    $valueA = (int) $a->label;
    $valueB = (int) $b->label;
    if ($valueA == $valueB) {
        return 0;
    }
    return ($valueA < $valueB) ? -1 : 1;
});

answered Jun 6, 2017 at 7:38

Kyoya

3432 silver badges5 bronze badges

Collectives™ on Stack Overflow

Force sorting json in PHP

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related