How to parse this multi dimensional JSON with PHP to fetch correct array?

Question

I have JSON which is formatted like example below which is correct way to loop whole file to catch "IWANTTHIS" values? All arrays are on same level in JSON ("some:products"). Just too complicated JSON for me in this afternoon...

{
  "type": "page",
  "pageType": "section",
  "_links": {},
  "_embedded": {
  "somkindof:blocks": [
    {
     "somevalue": 25,
     "_embedded": {
     "some:products": [
     {
      "system": {
      "availability": {},
      "IWANTTHIS": "20284",
      "hhhh": []
      },
....

I tried something like this but I cant catch values formatted like in my example.

$jfo = json_decode($vcurl);
$channel = $jfo->_embedded->[somkindof:blocks];

var_dump $channel;

Try $channel = $jfo->_embedded->{'somkindof:blocks'} (You may find using it as an array easier, look at json_decode parameter 2 in the PHP docs) — viion
– viion, Commented Feb 14, 2017 at 15:37

Paolo · Accepted Answer · 2017-02-14 15:53:38Z

2

Things get easier if you decode the JSON into an associative array.

(Even objects will become associative arrays and you can parse the whole object tree with the same syntax).

Then you parse the array with the square bracket syntax.

Note that both "somkindof:blocks" and "some:products" are regular arrays (ordered list of items) so you have to parse each item of them (with a simple foreach)

Said that you may have many "I want this".

<?php

$jfo = json_decode($vcurl, true ); // <-- decode into associative array

foreach( $jfo[ "embedded" ][ "somkindof:blocks" ] as $level_1_item )
{
    foreach( $level_1_item[ "_embedded" ][ "some:products" ] as $level_2_item )
    {
        $iWantThis = $level_2_item[ "IWANTTHIS" ];
    }
}

edited Feb 14, 2017 at 15:53

answered Feb 14, 2017 at 15:39

Paolo

15.9k28 gold badges73 silver badges95 bronze badges

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

Comments

Vizz85 · Accepted Answer · 2017-02-14 15:39:52Z

1

Thx this tool: http://jsonselector.com

$channel = ['_embedded']['somkindof:blocks'][0]['_embedded']['some:products'][0]['system']['IWANTTHIS']

answered Feb 14, 2017 at 15:39

Vizz85

1971 silver badge13 bronze badges

Comments

Theraloss · Accepted Answer · 2017-02-14 15:40:16Z

0

Add true as second parameter to json_decode to decode it into an array and not object.

<?php
$json = '{
  "type": "page",
  "pageType": "section",
  "_links": {},
  "_embedded": {
    "somkindof:blocks": [
      {
        "somevalue": 25,
        "_embedded": {
          "some:products": [
            {
              "system": {
                "availability": {},
                "IWANTTHIS": "20284",
                "hhhh": []
              }
            }
          ]
        }
      }
    ]
  }
}';

$jfo = json_decode($json, true);

$channel = $jfo['_embedded']['somkindof:blocks'];
print_r($channel);

answered Feb 14, 2017 at 15:40

Theraloss

7002 gold badges8 silver badges30 bronze badges

Comments

viion · Accepted Answer · 2017-02-14 15:42:50Z

0

All comments have suggested the Array option by providing true to json_decode() function.

However, if you wish to maintain stdClass use curly brackets.

Eg:

$jfo = json_decode($json);

foreach($jfo->_embedded->{'somkindof:blocks'} as $block) {
    echo $block->{'somSomething is wrongue'};
}

answered Feb 14, 2017 at 15:42

viion

3582 silver badges10 bronze badges

Collectives™ on Stack Overflow

How to parse this multi dimensional JSON with PHP to fetch correct array?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related