Accessing data from JSON in PHP

Question

I am having difficulty getting data from JSON.

I am after doing a foreach() for json formatted data that I get from a API, but I cant get it to work.

Here is my code:

The $player_runes is the database variable, it works totally fine, my problem is getting the data of runeID for each Array (pages)

foreach($player_runes->pages as $statplayerrunesfor){

$statplayerrunesforune0 = $statplayerrunesfor->slots->runeId;

echo $statplayerrunesforune0;

}

Here is the JSON Data:

{
"29161162": {
"summonerId": 29161162,
"pages": [
  {
    "id": 24193964,
    "name": "nida",
    "current": false,
    "slots": [
      {
        "runeSlotId": 1,
        "runeId": 5273
      },
      {
        "runeSlotId": 2,
        "runeId": 5273
      },
      {
        "runeSlotId": 3,
        "runeId": 5273
      },
      {
        "runeSlotId": 4,
        "runeId": 5273
      },
      {
        "runeSlotId": 5,
        "runeId": 5273
      },
      {
        "runeSlotId": 6,
        "runeId": 5273
      },
      {
        "runeSlotId": 7,
        "runeId": 5273
      },
      {
        "runeSlotId": 8,
        "runeId": 5273
      },
      {
        "runeSlotId": 9,
        "runeId": 5273
      },
      {
        "runeSlotId": 10,
        "runeId": 5317
      },
      {
        "runeSlotId": 11,
        "runeId": 5317
      },
      {
        "runeSlotId": 12,
        "runeId": 5317
      },
      {
        "runeSlotId": 13,
        "runeId": 5317
      },
      {
        "runeSlotId": 14,
        "runeId": 5317
      },
      {
        "runeSlotId": 15,
        "runeId": 5317
      },
      {
        "runeSlotId": 16,
        "runeId": 5317
      },
      {
        "runeSlotId": 17,
        "runeId": 5317
      },
      {
        "runeSlotId": 18,
        "runeId": 5317
      },
      {
        "runeSlotId": 19,
        "runeId": 5297
      },
      {
        "runeSlotId": 20,
        "runeId": 5297
      },
      {
        "runeSlotId": 21,
        "runeId": 5297
      },
      {
        "runeSlotId": 22,
        "runeId": 5289
      },
      {
        "runeSlotId": 23,
        "runeId": 5289
      },
      {
        "runeSlotId": 24,
        "runeId": 5289
      },
      {
        "runeSlotId": 25,
        "runeId": 5289
      },
      {
        "runeSlotId": 26,
        "runeId": 5289
      },
      {
        "runeSlotId": 27,
        "runeId": 5289
      },
      {
        "runeSlotId": 28,
        "runeId": 5357
      },
      {
        "runeSlotId": 29,
        "runeId": 5357
      },
      {
        "runeSlotId": 30,
        "runeId": 5357
      }
    ]
  },
  {
    "id": 24193965,
    "name": "adc",
    "current": false,
    "slots": [
      {
        "runeSlotId": 1,
        "runeId": 5245
      },
      {
        "runeSlotId": 2,
        "runeId": 5245
      },
      {
        "runeSlotId": 3,
        "runeId": 5245
      },
      {
        "runeSlotId": 4,
        "runeId": 5245
      },
      {
        "runeSlotId": 5,
        "runeId": 5245
      },
      {
        "runeSlotId": 6,
        "runeId": 5245
      },
      {
        "runeSlotId": 7,
        "runeId": 5245
      },
      {
        "runeSlotId": 8,
        "runeId": 5245
      },
      {
        "runeSlotId": 9,
        "runeId": 5245
      },
      {
        "runeSlotId": 10,
        "runeId": 5317
      },
      {
        "runeSlotId": 11,
        "runeId": 5317
      },
      {
        "runeSlotId": 12,
        "runeId": 5317
      },
      {
        "runeSlotId": 13,
        "runeId": 5317
      },
      {
        "runeSlotId": 14,
        "runeId": 5317
      },
      {
        "runeSlotId": 15,
        "runeId": 5317
      },
      {
        "runeSlotId": 16,
        "runeId": 5317
      },
      {
        "runeSlotId": 17,
        "runeId": 5317
      },
      {
        "runeSlotId": 18,
        "runeId": 5317
      },
      {
        "runeSlotId": 19,
        "runeId": 5289
      },
      {
        "runeSlotId": 20,
        "runeId": 5289
      },
      {
        "runeSlotId": 21,
        "runeId": 5289
      },
      {
        "runeSlotId": 22,
        "runeId": 5289
      },
      {
        "runeSlotId": 23,
        "runeId": 5289
      },
      {
        "runeSlotId": 24,
        "runeId": 5289
      },
      {
        "runeSlotId": 25,
        "runeId": 5289
      },
      {
        "runeSlotId": 26,
        "runeId": 5289
      },
      {
        "runeSlotId": 27,
        "runeId": 5289
      },
      {
        "runeSlotId": 28,
        "runeId": 5337
      },
      {
        "runeSlotId": 29,
        "runeId": 5337
      },
      {
        "runeSlotId": 30,
        "runeId": 5337
      }
    ]
  },
  {
    "id": 60148113,
    "name": "zed",
    "current": false,
    "slots": [
      {
        "runeSlotId": 1,
        "runeId": 5253
      },
      {
        "runeSlotId": 2,
        "runeId": 5253
      },
      {
        "runeSlotId": 3,
        "runeId": 5253
      },
      {
        "runeSlotId": 4,
        "runeId": 5253
      },
      {
        "runeSlotId": 5,
        "runeId": 5253
      },
      {
        "runeSlotId": 6,
        "runeId": 5253
      },
      {
        "runeSlotId": 7,
        "runeId": 5253
      },
      {
        "runeSlotId": 8,
        "runeId": 5245
      },
      {
        "runeSlotId": 9,
        "runeId": 5245
      },
      {
        "runeSlotId": 10,
        "runeId": 5317
      },
      {
        "runeSlotId": 11,
        "runeId": 5317
      },
      {
        "runeSlotId": 12,
        "runeId": 5317
      },
      {
        "runeSlotId": 13,
        "runeId": 5317
      },
      {
        "runeSlotId": 14,
        "runeId": 5317
      },
      {
        "runeSlotId": 15,
        "runeId": 5317
      },
      {
        "runeSlotId": 16,
        "runeId": 5317
      },
      {
        "runeSlotId": 17,
        "runeId": 5317
      },
      {
        "runeSlotId": 18,
        "runeId": 5317
      },
      {
        "runeSlotId": 19,
        "runeId": 5289
      },
      {
        "runeSlotId": 20,
        "runeId": 5289
      },
      {
        "runeSlotId": 21,
        "runeId": 5289
      },
      {
        "runeSlotId": 22,
        "runeId": 5289
      },
      {
        "runeSlotId": 23,
        "runeId": 5289
      },
      {
        "runeSlotId": 24,
        "runeId": 5289
      },
      {
        "runeSlotId": 25,
        "runeId": 5289
      },
      {
        "runeSlotId": 26,
        "runeId": 5289
      },
      {
        "runeSlotId": 27,
        "runeId": 5289
      },
      {
        "runeSlotId": 28,
        "runeId": 5345
      },
      {
        "runeSlotId": 29,
        "runeId": 5345
      },
      {
        "runeSlotId": 30,
        "runeId": 5335
      }
    ]
  },
  {
    "id": 60148114,
    "name": "one",
    "current": true,
    "slots": [
      {
        "runeSlotId": 1,
        "runeId": 5253
      },
      {
        "runeSlotId": 2,
        "runeId": 5253
      },
      {
        "runeSlotId": 3,
        "runeId": 5253
      },
      {
        "runeSlotId": 4,
        "runeId": 5253
      },
      {
        "runeSlotId": 5,
        "runeId": 5253
      },
      {
        "runeSlotId": 6,
        "runeId": 5253
      },
      {
        "runeSlotId": 7,
        "runeId": 5253
      },
      {
        "runeSlotId": 8,
        "runeId": 5253
      },
      {
        "runeSlotId": 9,
        "runeId": 5253
      },
      {
        "runeSlotId": 10,
        "runeId": 5317
      },
      {
        "runeSlotId": 11,
        "runeId": 5317
      },
      {
        "runeSlotId": 12,
        "runeId": 5317
      },
      {
        "runeSlotId": 13,
        "runeId": 5317
      },
      {
        "runeSlotId": 14,
        "runeId": 5317
      },
      {
        "runeSlotId": 15,
        "runeId": 5317
      },
      {
        "runeSlotId": 16,
        "runeId": 5317
      },
      {
        "runeSlotId": 17,
        "runeId": 5317
      },
      {
        "runeSlotId": 18,
        "runeId": 5317
      },
      {
        "runeSlotId": 19,
        "runeId": 5289
      },
      {
        "runeSlotId": 20,
        "runeId": 5289
      },
      {
        "runeSlotId": 21,
        "runeId": 5289
      },
      {
        "runeSlotId": 22,
        "runeId": 5289
      },
      {
        "runeSlotId": 23,
        "runeId": 5289
      },
      {
        "runeSlotId": 24,
        "runeId": 5289
      },
      {
        "runeSlotId": 25,
        "runeId": 5289
      },
      {
        "runeSlotId": 26,
        "runeId": 5289
      },
      {
        "runeSlotId": 27,
        "runeId": 5289
      },
      {
        "runeSlotId": 28,
        "runeId": 5335
      },
      {
        "runeSlotId": 29,
        "runeId": 5335
      },
      {
        "runeSlotId": 30,
        "runeId": 5335
      }
    ]
  }
]
}
}

I already have it decoded, My question is how do I get access to the data runeId is it like how i done in the foreach ? — ForsakenHound, Nov 05 '16 at 18:03
Check my answer, if you use `json_decode()` it becomes an array, not object. — Karol Gasienica, Nov 05 '16 at 18:09
`$statplayerrunesfor->slots` is an array. You need to use a `foreach()` loop over it to get all the `runeId`s. — Barmar, Nov 05 '16 at 18:44
The first player has 30 `runeId`s, which one did you expect `$statplayerrunesfor->slots->runeId` to return? — Barmar, Nov 05 '16 at 18:46
The first one. But the problem is due to this i think "29161162": {} at the start — ForsakenHound, Nov 05 '16 at 19:06
I cant get this to work either $playerIDruneshgg = $player_runes->summonerId; — ForsakenHound, Nov 05 '16 at 19:11

score 0 · Answer 1 · answered Nov 05 '16 at 18:07

0

It should work for you:

$player_runes = json_decode($variable_with_json, true);
foreach($player_runes['pages'] as $statplayerrunesfor){

$statplayerrunesforune0 = $statplayerrunesfor['slots']['runeId'];

echo $statplayerrunesforune0;

}

After decoding it become an array not an object.

answered Nov 05 '16 at 18:07

Karol Gasienica

2,825
24
36

Does not work, but i have already decoded it into a array the problem is the parts where i try to get the data like ->runeId. And some reason wont work makes page black. – ForsakenHound Nov 05 '16 at 18:38
Anyway it is always better to find out a solution on you own :) – Karol Gasienica Nov 05 '16 at 18:39

score 0 · Answer 2 · edited Nov 05 '16 at 18:24

0

Try this:

foreach(json_decode($player_runes->pages) as $statplayerrunesfor){

    $statplayerrunesforune0 = $statplayerrunesfor->{'slots'}->{'runeId'};

    echo $statplayerrunesforune0;

}

hope it works :)

edited Nov 05 '16 at 18:24

rocambille

15,398
12
50
68

answered Nov 05 '16 at 18:08

Sachin Gotal

21
5

Does not work, but i have already decoded it into a array the problem is the parts where i try to get the data like ->runeId. And some reason wont work makes page black. – ForsakenHound Nov 05 '16 at 18:38
@ForsakenHound Are you using the `true` option to `json_decode`? Then it becomes `$player_runes['pages']`. – Barmar Nov 05 '16 at 18:42

Accessing data from JSON in PHP

2 Answers2

Linked