PHP how to loop over nested JSON Object?

Question

1. Extracted from my laravel controller:

        ..
        ..
        $data = json_decode($response, true);
        return $data;
        ..
        ..
        return view('homepage')->with('homeExclusives', $homeExclusives);

Here is a sample of the returned data, just a short version, since the returned feed is very large, but this will give you an idea of the way it's structured.

     array(4) {
       ["success"]=> bool(true) 
       ["status"]=> int(200) 
       ["bundle"]=> array(2) {
           [0]=> array(631) {
               ["StreetDirPrefix"]=> string(2) "SW" 
               ["DistanceToStreetComments"]=> NULL
           }

           [1]=> array(631) { 
               ["StreetDirPrefix"]=> string(2) "NE" 
               ["DistanceToStreetComments"]=> NULL
              }
      }

I need to extract "StreetDirPrefix" value from [0] and [1], but I always get an error. Can someone help?

Show what you've tried, please. What error are you getting?

aynber
– aynber

2019-07-17 20:16:25 +00:00
Commented Jul 17, 2019 at 20:16 — aynber
– aynber, Commented Jul 17, 2019 at 20:16

The fourth bird · Accepted Answer · 2019-07-17 20:22:11Z

1

For the data in your example you might use array_column and specify StreetDirPrefix as the column key.

$res = array_column($array["bundle"], "StreetDirPrefix");
print_r($res);

Php demo

answered Jul 17, 2019 at 20:22

The fourth bird

165k16 gold badges61 silver badges75 bronze badges

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

3 Comments

kangular Over a year ago

Thank you, how can I use a loop to list all of the "StreetDirPrefix"?

kangular Over a year ago

Excellent example, one more question, how can I make it work if I want to extract multiple values and display them, I'm trying to create a featured properties row, example "StreetDirPrefix", "UnparsedAddress", "SalePrice" & "mainImage" and also not show the "0 => ".

The fourth bird Over a year ago

That is a different question and a very broad one as well. That depends how the data is structured in the array. In that case my advice would be to ask a new question adding the code and specifying the data and the desired result.

SeeQue · Accepted Answer · 2019-07-17 21:16:09Z

0

Without knowing what error you are getting my solution would be something like this:

<?php
if (is_array($data) && is_array($data["bundle"]) ) {
    foreach ($data["bundle"] as $tmpKey => $tmpVal) {
        if (isset($tmpVal["StreetDirPrefix"])) {
            echo $tmpKey." => ".$tmpVal["StreetDirPrefix"]."\n";
        }
    }
}
?>

I always like to validate arrays, so if your $data variable or the $data["bundle"] subsection are not arrays then you will not get anything. Not even an error.

I have a working example here: https://www.seeque-secure.dk/demo.php?id=PHP+how+to+loop+over+nested+JSON+Object

EDIT:

(if i understand you correct) When you have validated your array all you have to do is repeat the inner validation like this:

<?php
if (is_array($data) && is_array($data["bundle"]) ) {
    foreach ($data["bundle"] as $tmpKey => $tmpVal) {
        if (isset($tmpVal["StreetDirPrefix"])) {
            echo $tmpKey." => ".$tmpVal["StreetDirPrefix"]."\n";
        }
        if (isset($tmpVal["UnparsedAddress"])) {
            echo $tmpVal["UnparsedAddress"]."\n";
        }
        if (isset($tmpVal["SalePrice"])) {
            echo $tmpVal["SalePrice"]."\n";
        }

        //...... ect.....

    }
}

?>

edited Jul 17, 2019 at 21:16

answered Jul 17, 2019 at 20:41

SeeQue

516 bronze badges

2 Comments

kangular Over a year ago

Excellent example, one more question, how can I make it work if I want to extract multiple values and display them, I'm trying to create a featured properties row, example "StreetDirPrefix", "UnparsedAddress", "SalePrice" & "mainImage" and also not show the "0 => ".

kangular Over a year ago

I actually analized the you example and was able to remove the => and loop over other values, thank you very much.

Collectives™ on Stack Overflow

PHP how to loop over nested JSON Object?

2 Answers 2

3 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related