PHP getting values from nested json

Question

I have this json listed below. I was using json_decode to get some of the values. Such as getting the id value:

$decoded_array = json_decode($result, true);
            foreach($decoded_array['issue'] as $issues ){
                    $value[] = $issues["id"];

This method is working for getting the id value, however, I want to get the emailAddress values for both Bob and John. I believe you can get a single value by doing this:

$value[] = $issues["fields"][people][0][emailAddress];

Is it possible to get both email addresses in an efficient manner?

Edited --------

How would you get data with an expanded dataset? Example:

{
"startAt": 0,
"issue": [
    {
        "id": "51526",
        "fields": {
            "people": [
                {
                    "name": "bob",
                    "emailAddress": "[email protected]",
                    "displayName": "Bob Smith",
                },
                {
                    "name": "john",
                    "emailAddress": "[email protected]",
                    "displayName": "John Smith",
                }
            ],
            "skill": {
                "name": "artist",
                "id": "1"
            }
        }
    },
{
        "id": "2005",
        "fields": {
            "people": [
                {
                    "name": "jake",
                    "emailAddress": "[email protected]",
                    "displayName": "Jake Smith",
                },
                {
                    "name": "frank",
                    "emailAddress": "[email protected]",
                    "displayName": "Frank Smith",
                }
            ],
            "skill": {
                "name": "writer",
                "id": "2"
            }
        }
    }
]

}

I only want to extract the email addresses from both "fields". Is there an easy way to loop through all the "fields" to get "emailAddress" data?

joshstrike · Accepted Answer · 2014-04-03 02:07:47Z

2

You need to delve deeper into the array.

foreach ($decoded_array['issue'][0]['fields']['people'] as $person) {
  echo $person['emailAddress'];
}

answered Apr 3, 2014 at 2:07

joshstrike

1,84313 silver badges17 bronze badges

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

1 Comment

Jason Over a year ago

That does it! Thanks for the help

Collectives™ on Stack Overflow

PHP getting values from nested json

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related