Parse JSON Response PHP

Question

I have the following JSON data which I'm trying to parse the categories:

{
"skimlinksProductAPI": {
    "status": 200,
    "message": "OK",
    "version": 3,
    "categories": {
        "1": "Animals",
        "2": "Animals > Live Animals",
        "3": "Animals > Pet Supplies",
        "4": "Animals > Pet Supplies > Bird Supplies",
        "5": "Animals > Pet Supplies > Bird Supplies > Bird Cages & Stands",
        "6": "Animals > Pet Supplies > Bird Supplies > Bird Food",
        "7": "Animals > Pet Supplies > Bird Supplies > Bird Ladders & Perches",
        "8": "Animals > Pet Supplies > Bird Supplies > Bird Toys",
        ...
    }
  }
}

I'm trying the following but not working:

$catList = json_decode(file_get_contents('http://api-product.skimlinks.com/categories?key=MY_KEY&format=json'),true);

$catList=$catList['skimlinksProductAPI']['categories'];

foreach ($catList as $element){

    echo $element[0].' - '.$element[1];

}

did you bother checking json_last_error() and doing var_dump($catList) to see what you're getting back? — Marc B
– Marc B, Commented Mar 31, 2014 at 21:57

Barmar · Accepted Answer · 2014-03-31 22:19:15Z

1

The elements of categories aren't sub-arrays, they're just key-value pairs. The foreach should be:

foreach ($catList as $id => $element){
     echo $id . ' - ' . $element;
}

edited Mar 31, 2014 at 22:19

answered Mar 31, 2014 at 22:01

Barmar

789k57 gold badges555 silver badges669 bronze badges

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

2 Comments

StudioTime Over a year ago

That just gives me a blank page unfortunately.

Zini Over a year ago

The echo was missing.

Collectives™ on Stack Overflow

Parse JSON Response PHP

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related