JSON nested array parse via PHP

Question

I need to loop through and print all nested data within the "players" array and sort by "wonAmount." I can get my PHP to print out a single value, which I target, but I can't get it to work when I try the foreach loop. So instead, it prints out "array."

JSON

{
  "tournamentID": 65,
  "gameType": "Holdem",
  "name": "TRI KRALJA ZA EVROPU",
  "start": "2022-04-07 13:30:00",
  "status": "Finished",
  "buyIn": 100000,
  "entryFee": 10000,
  "guaranteedPrize": 12500000,
  "rebuyFee": 100000,
  "rebuyRake": 10000,
  "addonFee": 0,
  "addonRake": 0,
  "tableSize": 9,
  "speed": "Turbo",
  "players": [
    {
      "id": 1000000,
      "alias": "demo1",
      "rank": 1,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 6250000
    },
    {
      "id": 1000005,
      "alias": "demo6",
      "rank": 2,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 3750000
    },
    {
      "id": 1000087,
      "alias": "demo10",
      "rank": 3,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 2500000
    },
    {
      "id": 1000008,
      "alias": "demo9",
      "rank": 4,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000078,
      "alias": "demo15",
      "rank": 5,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000002,
      "alias": "demo3",
      "rank": 6,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000006,
      "alias": "demo7",
      "rank": 7,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000090,
      "alias": "demo13",
      "rank": 8,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000171,
      "alias": "demo14",
      "rank": 9,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000088,
      "alias": "okokoke",
      "rank": 10,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000007,
      "alias": "demo8",
      "rank": 11,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000086,
      "alias": "demo11",
      "rank": 12,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000004,
      "alias": "demo5",
      "rank": 13,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000001,
      "alias": "demo2",
      "rank": 14,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000003,
      "alias": "demo4",
      "rank": 15,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    },
    {
      "id": 1000077,
      "alias": "helloworld",
      "rank": 16,
      "rebuyCount": 0,
      "addonCount": 0,
      "wonAmount": 0
    }
  ]
}

The array elements are also arrays. You need to print the elements like echo $player['id'], or use print_r($player) instead of echo $player. — Barmar
– Barmar, Commented Apr 7, 2022 at 21:14

Omar Tammam · Accepted Answer · 2022-04-07 23:01:30Z

1

first, you need to decode the json using json_decode then you need to sort & print the player's array

$data = json_decode($json_data,true);

//extract the players from json 
$players = $data["players"];

//sort players array
$wonAmount = array();
foreach ($players as $key => $row)
{
    $wonAmount[$key] = $row['wonAmount'];
}
array_multisort($wonAmount, SORT_DESC, $players);


//print players data 

foreach ($players as $player)
{
    //add here any keys you want to print from player array 
    echo $player["id"]; 
}

answered Apr 7, 2022 at 23:01

Omar Tammam

1,3041 gold badge11 silver badges17 bronze badges

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

1 Comment

user3425506 Over a year ago

I came up with something similar but you beat me to it. I find array_multisort very confusing so I used usort: usort($players, function($a, $b) { return $a['wonAmount'] - $b['wonAmount']. Also confusing but slightly less so to me.

Collectives™ on Stack Overflow

JSON nested array parse via PHP

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related