How to sort JSON objects by a certain key's value

Question

My goal:

To sort a json list of users by credits.

My issue:

Credits are sorted, but in reverse order that they should be.

My results:

Position: 1
Username: abc
Credits: 12

Position: 2
Username: bcd
Credits: 123

Position: 3
Username: cde
Credits: 1245

What I need:

Position: 1
Username: abc
Credits: 1234

Position: 2
Username: bcd
Credits: 123

Position: 3
Username: cde
Credits: 12

My question:

How can I resort the names to be in the proper order sorted by credits?

My php code:

<?php
$json = '{"id":1,"jsonrpc":"2.0","total":50,"result":[{"id":1,"username":"Ashley","credits":684921},{"id":2,"username":"Caroline","credits":113045},{"id":3,"username":"Alexandra","credits":669133},{"id":4,"username":"Katelyn","credits":735955},{"id":5,"username":"Ashley","credits":202478},{"id":6,"username":"Anna","credits":854266},{"id":7,"username":"Lily","credits":406425},{"id":8,"username":"Samantha","credits":430603},{"id":9,"username":"Caroline","credits":380785},{"id":10,"username":"Paige","credits":961596},{"id":11,"username":"Bailey","credits":67660},{"id":12,"username":"Kimberly","credits":610751},{"id":13,"username":"Maya","credits":446787},{"id":14,"username":"Maria","credits":818538},{"id":15,"username":"Ella","credits":789682},{"id":16,"username":"Olivia","credits":906604},{"id":17,"username":"Arianna","credits":177500},{"id":18,"username":"Maya","credits":592490},{"id":19,"username":"Aubrey","credits":58834},{"id":20,"username":"Sophie","credits":324357},{"id":21,"username":"Julia","credits":288688},{"id":22,"username":"Rachel","credits":932145},{"id":23,"username":"Arianna","credits":848696},{"id":24,"username":"Valeria","credits":272258},{"id":25,"username":"Autumn","credits":301136},{"id":26,"username":"Audrey","credits":317305},{"id":27,"username":"Chloe","credits":975642},{"id":28,"username":"Payton","credits":510533},{"id":29,"username":"Morgan","credits":927493},{"id":30,"username":"Mya","credits":166566},{"id":31,"username":"Lauren","credits":840207},{"id":32,"username":"Trinity","credits":255691},{"id":33,"username":"Jocelyn","credits":272653},{"id":34,"username":"Madeline","credits":58344},{"id":35,"username":"Valeria","credits":972228},{"id":36,"username":"Chloe","credits":919646},{"id":37,"username":"Jessica","credits":390647},{"id":38,"username":"Claire","credits":670709},{"id":39,"username":"Savannah","credits":47721},{"id":40,"username":"Zoe","credits":214133},{"id":41,"username":"Taylor","credits":991001},{"id":42,"username":"Gabrielle","credits":295506},{"id":43,"username":"Katherine","credits":295472},{"id":44,"username":"Vanessa","credits":600895},{"id":45,"username":"Olivia","credits":337541},{"id":46,"username":"Mackenzie","credits":32221},{"id":47,"username":"Bella","credits":461298},{"id":48,"username":"Maria","credits":318094},{"id":49,"username":"Lillian","credits":632622},{"id":50,"username":"Kayla","credits":17062}]}';
$decoded = json_decode($json);
$users = $decoded->result;

function my_sort($a, $b)
{
    if ($a-credits > $b->credits) {
        return -1;
    } else if ($a->credits < $b->credits) {
        return 1;
    } else {
        return 0; 
    }
}
rsort($users, 'my_sort');
   $position = 0;
foreach($users as $user){
   $position = $position + 1;
   $username = $user->username;
   $credits = $user->credits;
   //do something with it:
   echo "Postion: $position<br/>\n Username: $username<br/>\n  Credits:$credits <br/>\n <br/>\n";
   if ($position == 3) {
        break;
    }
}
?>

realization · Accepted Answer · 2013-02-14 05:02:17Z

5

+50

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

usort($users, 'my_sort');

edited Feb 14, 2013 at 5:02

answered Feb 14, 2013 at 4:56

realization

5971 gold badge4 silver badges5 bronze badges

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

1 Comment

grepsedawk Over a year ago

Wow, can't believe I missed that. Thank you so much.

grepsedawk · Accepted Answer · 2016-06-17 21:49:35Z

1

You need to use usort instead of rsort.
Note that with php7, you could do the spaceship operator:

function mySort($a, $b) {
    return $b->credits <=> $a->credits;
}

usort($users, 'mySort');

answered Jun 17, 2016 at 21:49

grepsedawk

3,4142 gold badges28 silver badges49 bronze badges

Collectives™ on Stack Overflow

How to sort JSON objects by a certain key's value

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related