Ordering json api with php

Question

I have been curious about PHP lately and I am working on a test subject. I want to get the number of citizens from an online game and order it by Military rank.

Here is the link of the API: https://www.erevollution.com/en/api/citizenship/1

Here is the code I have so far.

<form action="index.php" method="post">
    <input type="text" name="id"><br>
    <input type="submit">
</form>
<?php   
$okey= $_POST["id"];;
$jsonurl="https://www.erevollution.com/en/api/citizenship/".$okey;
$json = file_get_contents($jsonurl,0,null,null);  
$json_output = json_decode($json); 
echo "Players of albania are: <br>";  

foreach ($json_output as $trend)  
{   
    $id = $trend->ID;
    echo " Name : {$trend->Name}\n";    
    echo '<br>';
}

@StackB00m i would like to order the citizens from military rank — Nikoljan Behari
– Nikoljan Behari, Commented Aug 11, 2016 at 15:20
@StackB00m can you give me a code snippet ? i am kinda noob ! — Nikoljan Behari
– Nikoljan Behari, Commented Aug 11, 2016 at 15:25
hey I cant now code a snippet for you but i can give you the best reference to the subject : webtutsdepot.com/2009/08/31/how-to-read-json-data-with-php — StackB00m
– StackB00m, Commented Aug 11, 2016 at 15:29

Don't Panic · Accepted Answer · 2016-08-11 15:28:07Z

1

When you json_decode the API response, use true for the second parameter to get an associative array rather than a stdClass object.

$json_output = json_decode($json, true);

Then you can use usort to sort by MilitaryRank:

usort($json_output, function($a, $b) {
    if ($a['MilitaryRank'] < $b['MilitaryRank']) return -1;
    if ($a['MilitaryRank'] > $b['MilitaryRank']) return 1;
    return 0;
});

If you want to sort descending rather than ascending, just reverse the two if conditions.

answered Aug 11, 2016 at 15:28

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

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

Comments

Jeff Puckett · Accepted Answer · 2016-08-11 15:38:51Z

0

There's an example on the usort docs for sorting a multidimensional array. Basically just substitute your desired array index 'MilitaryRank'

I also zazzed up the HTML a little more to make it more readable.

<form method="post">
    <input type="text" name="id"><br>
    <input type="submit">
</form>
<?php   
$okey= $_POST["id"];;
$jsonurl="https://www.erevollution.com/en/api/citizenship/".$okey;
$json = file_get_contents($jsonurl,0,null,null);  
$json_output = json_decode($json, true); 

// print_r($json_output);

function cmp($a, $b)
{
    if ($a['MilitaryRank'] == $b['MilitaryRank']) {
        return 0;
    }
    return ($a['MilitaryRank'] < $b['MilitaryRank']) ? -1 : 1;
}

usort($json_output, "cmp");

echo "<h1>Players of albania are: </h1>";  

foreach ($json_output as $trend)  
{
    $id = $trend['ID'];
    echo " Name : $trend[Name]\n<br>";
    echo " MRank : $trend[MilitaryRank]\n<br><hr/>";
}

answered Aug 11, 2016 at 15:38

Jeff Puckett

41.6k19 gold badges125 silver badges177 bronze badges

1 Comment

Nikoljan Behari Over a year ago

Thank You ! This was the one i was looking for

MaximeK · Accepted Answer · 2016-08-11 15:30:08Z

0

$json_decoded = json_decode($json,true);

$allDatas = array();
foreach ($json_decoded as $user) {
    $allDatas[$user['MilitaryRank']][] = $user;
}
sort($allDatas);
print_r($allDatas);

so you can do a foreach like that :

foreach ($allDatas as $MilitaryRank => $users) {
    # code...
}

answered Aug 11, 2016 at 15:30

MaximeK

2,0811 gold badge13 silver badges17 bronze badges

Comments

rosengrenen · Accepted Answer · 2016-08-11 15:30:40Z

0

Here's my solution if I got it right, otherwise, correct me!

<?php
$jsonurl="https://www.erevollution.com/en/api/citizenship/1";
$json = file_get_contents($jsonurl,0,null,null);  
$json_output = json_decode($json, true);
echo '<pre>';
echo "Players of albania are: <br>";
$military_rank = [];  
foreach ($json_output as $trend)  
{   
    $military_rank[$trend['MilitaryRank']][] = $trend;
}
ksort($military_rank);
foreach ($military_rank as $key => $rank)
{
    echo '<br><br>Rank ' . $key . '<br>';
    foreach ($rank as $player)
    {
        echo 'Name: ' . $player['Name'] . '<br>';
    }
}

answered Aug 11, 2016 at 15:30

rosengrenen

7911 gold badge6 silver badges22 bronze badges

Collectives™ on Stack Overflow

Ordering json api with php

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related