JSON Parse empty results

Question

I have the following example JSON:

{
productAPI: {
  status: 200,
  message: "OK",
  version: 3,
  products: {
    grouped: {
      matches: 773949,
      groups: [
        {
          doclist: {
            start: 0,
            numFound: 385957,
            docs: [
              {
                merchant: "Amazon",
                currency: "GBP"
               }
            ]
         },
         doclist: {
            start: 0,
            numFound: 885957,
            docs: [
              {
                merchant: "Ebay",
                currency: "GBP"
               }
            ]
         }

There will be multiple Merchant names I want to print but getting blank result (I am quite new to JSON parsing)

Here's what I'm trying:

$prodList=$prodList['productAPI']['products']['grouped']['groups']['doclist']['docs'];

foreach ($prodList as $element){
    echo $element['merchant'];
}

Is this the correct method?

UPDATE

As has been correctly pointed out (I didn't add enough example) 'groups' is an array, so, I've changed to the following but still no joy:

$prodList=$prodList['productAPI']['products']['grouped']['groups'];

$i=0;
foreach ($prodList as $element){
    echo $element[$i]['doclist']['docs']['merchant'];
    $i++;
}

@RahilWazir Yes, its defined to bring in the data: $prodList = json_decode(file_get_contents('URL_HERE'),true); — StudioTime
– StudioTime, Commented Apr 1, 2014 at 12:16

Mifeet · Accepted Answer · 2014-04-01 12:36:35Z

1

Value under groups index is an array and you miss the index to this array. Maybe something like this would help:

$prodList=$prodList['productAPI']['products']['grouped']['groups'][0]['doclist']['docs'];

(depending on what can be in the groups array and what you want to do about it).

Update Now there is conversely too much indirection to the groups array :). Try this:

$prodList=$prodList['productAPI']['products']['grouped']['groups'];
foreach ($prodList as $element){
    $docs = $element['doclist']['docs'];
    foreach ($docs as $doc) {
        echo $doc['merchant'];
    }
}

edited Apr 1, 2014 at 12:36

answered Apr 1, 2014 at 11:53

Mifeet

13.8k6 gold badges62 silver badges110 bronze badges

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

Collectives™ on Stack Overflow

JSON Parse empty results

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related