How to read JSON file using php

Question

I have a following JSON File. I have tried accessing it; but, I am getting undefined error. Please suggest how to read it using PHP:

"feed": {
   "entry": [
   {
    "id": "679244143963",
    "title": "Nashware Black Travel Kit",
    "description": "Color : Black Material : Others Type : Travel kits Closure : Magnit Button Combo : No Compartment : 4 Dimension (LxHxW) cm : 25X51X7 Disclaimer : Product colour may slightly vary due to photographic lighting sources or your monitor settings Gender : Women ",
    "link": "http://www.sl.com/product/travel-kit/679244143963",
    "image_link": "http://n1.sdlcdn.com/imgs/b/e/t/MU_COS_BAG_M_1_3x-0b20f.jpg",
    "sub_category_id": "435",
    "sub_category_name": "Travel Accessories",
    "mrp": "700",
    "availability": "in stock",
    "effective_price": "310"
  },
   {
    "id": "679244143963",
    "title": "Nashware Black Travel Kit",
    "description": "Color : Black Material : Others Type : Travel kits Closure : Magnit Button Combo : No Compartment : 4 Dimension (LxHxW) cm : 25X51X7 Disclaimer : Product colour may slightly vary due to photographic lighting sources or your monitor settings Gender : Women ",
    "link": "http://www.sl.com/product/travel-kit/679244143963",
    "image_link": "http://n1.sdlcdn.com/imgs/b/e/t/MU_COS_BAG_M_1_3x-0b20f.jpg",
    "sub_category_id": "435",
    "sub_category_name": "Travel Accessories",
    "mrp": "700",
    "availability": "in stock",
    "effective_price": "310"
  }
   ]
  }

After Entry same as JSON notation Id, title, desc and etc are displayed in array. Any suggestions.

It's not my code , I am fetching it using API. It's by snapdeal's top selling products json file. — Dhruvi Mistry, Apr 06 '17 at 08:30
@DhruviMistry How do you expect us to help with your code if you do not post it here? — arkascha, Apr 06 '17 at 08:32
This is the xml file : 679244143963Nashware Black Travel Kit 645222300642Cheston Chb-20 Plastic Air Blower - Red — Dhruvi Mistry, Apr 06 '17 at 08:33
@arkascha it's missing opening and closing `{ }`. While I could just say that, getting a malformed JSON is usually a symptom of something else going wrong. — apokryfos, Apr 06 '17 at 08:46
No, the brackets are _not_ missing. As said above the `"feed":` has to be removed, it is a left over from the XML enclosing as the OP clearly stated. — arkascha, Apr 06 '17 at 08:49

score 0 · Answer 1 · answered Apr 06 '17 at 08:33

You have missed start and end brackets. Your json should look like:

    {
    "feed": {
        "entry": [{
            "id": "679244143963",
            "title": "Nashware Black Travel Kit",
            "description": "Color : Black Material : Others Type : Travel kits Closure : Magnit Button Combo : No Compartment : 4 Dimension (LxHxW) cm : 25X51X7 Disclaimer : Product colour may slightly vary due to photographic lighting sources or your monitor settings Gender : Women ",
            "link": "http://www.sl.com/product/travel-kit/679244143963",
            "image_link": "http://n1.sdlcdn.com/imgs/b/e/t/MU_COS_BAG_M_1_3x-0b20f.jpg",
            "sub_category_id": "435",
            "sub_category_name": "Travel Accessories",
            "mrp": "700",
            "availability": "in stock",
            "effective_price": "310"
        },
        {
            "id": "679244143963",
            "title": "Nashware Black Travel Kit",
            "description": "Color : Black Material : Others Type : Travel kits Closure : Magnit Button Combo : No Compartment : 4 Dimension (LxHxW) cm : 25X51X7 Disclaimer : Product colour may slightly vary due to photographic lighting sources or your monitor settings Gender : Women ",
            "link": "http://www.sl.com/product/travel-kit/679244143963",
            "image_link": "http://n1.sdlcdn.com/imgs/b/e/t/MU_COS_BAG_M_1_3x-0b20f.jpg",
            "sub_category_id": "435",
            "sub_category_name": "Travel Accessories",
            "mrp": "700",
            "availability": "in stock",
            "effective_price": "310"
        }]
    }
}

Or you have to use below code:

$obj = json_decode("{" . $json . "}");

More likely the `feed` key is part of the APIs response structure and should be removed. — arkascha, Apr 06 '17 at 08:37
Hi, Vircom , I converted xml file into Json , and the code I have written is the one I got from the online converter , I don't know much. Can you please share how to access it. — Dhruvi Mistry, Apr 06 '17 at 08:38
@arkascha , sure will do that , As I don't know where to start I simply paste that here. Do help if you can in accessing it. — Dhruvi Mistry, Apr 06 '17 at 08:40
JSON content, that you pasted is valid. But php require additional brackets. Could you paste part of your code that not working correct ? — VirCom, Apr 06 '17 at 08:41
I have tried this 2 options : foreach($result as $re){ echo $re.feed.entry["title"]; // echo $re[feed]->[entry]{title}; } — Dhruvi Mistry, Apr 06 '17 at 08:43
So how about: foreach($obj->feed->entry as $entry) { echo $entry->title; } — VirCom, Apr 06 '17 at 08:48

score 0 · Accepted Answer · edited May 23 '17 at 10:30

It seems your JSON is structured as follows :

{"feed" : {
   "entry" : [array of JSON objects]
 }
}

So after doing some research, it seems the best way to do it would be to use RecursiveArrayIterator. I found the answer on another post, here.

 <?php

$json = <<< JSON
{
 "feed": {
        "entry": [{
            "id": "679244143963",
            "title": "Nashware Black Travel Kit",
            "description": "Color : Black Material : Others Type : Travel kits Closure : Magnit Button Combo : No Compartment : 4 Dimension (LxHxW) cm : 25X51X7 Disclaimer : Product colour may slightly vary due to photographic lighting sources or your monitor settings Gender : Women ",
            "link": "http://www.sl.com/product/travel-kit/679244143963",
            "image_link": "http://n1.sdlcdn.com/imgs/b/e/t/MU_COS_BAG_M_1_3x-0b20f.jpg",
            "sub_category_id": "435",
            "sub_category_name": "Travel Accessories",
            "mrp": "700",
            "availability": "in stock",
            "effective_price": "310"
        },
        {
            "id": "679244143963",
            "title": "Nashware Black Travel Kit",
            "description": "Color : Black Material : Others Type : Travel kits Closure : Magnit Button Combo : No Compartment : 4 Dimension (LxHxW) cm : 25X51X7 Disclaimer : Product colour may slightly vary due to photographic lighting sources or your monitor settings Gender : Women ",
            "link": "http://www.sl.com/product/travel-kit/679244143963",
            "image_link": "http://n1.sdlcdn.com/imgs/b/e/t/MU_COS_BAG_M_1_3x-0b20f.jpg",
            "sub_category_id": "435",
            "sub_category_name": "Travel Accessories",
            "mrp": "700",
            "availability": "in stock",
            "effective_price": "310"
        }]
    }
}
JSON;

$jsonIterator = new RecursiveIteratorIterator(
    new RecursiveArrayIterator(json_decode($json, TRUE)),
    RecursiveIteratorIterator::SELF_FIRST);

foreach ($jsonIterator as $key => $val) {
    if(is_array($val)) {
        echo "$key:\n";
    } else {
        echo "$key => $val\n";
    }
}

Here you can run the code one codepad

@DhruviMistry Glad I could help ! (be sure to do some research next time!) — Xogno, Apr 06 '17 at 09:00

How to read JSON file using php

2 Answers2