Loop through JSON response using PHP

Question

I am making an API request via PHP cURL.

When I run echo $response I get the following JSON:

JSON (application/json):

{
    "workers": [
        {
            "email": "micky@mcgurk.com",
            "manager": {
                "email": "boss@mcgurk.com"
            }
        },
        {
            "email": "michelle@mcgurk.com",
            "manager": {
                "email": "another_boss@mcgurk.com"
            }
        }
    ]
}

I'd like to loop through the results & echo out the email and associated manager. How do I do this?

score 3 · Answer 1 · answered Jun 18 '18 at 09:32

3

Look into json_decode() http://php.net/manual/en/function.json-decode.php

The result will be an associative array (or object) that you can iterate through

answered Jun 18 '18 at 09:32

Eriks Klotins

3,804
1
10
24

Fantastic, thank you, Eriks! – michaelmcgurk Jun 18 '18 at 09:32

Pupil · Accepted Answer · 2018-06-18T09:37:51.160

2

Use PHP's function json_decode()

<?php
$json = '{
    "workers": [
        {
            "email": "micky@mcgurk.com",
            "manager": {
                "email": "boss@mcgurk.com"
            }
        },
        {
            "email": "michelle@mcgurk.com",
            "manager": {
                "email": "another_boss@mcgurk.com"
            }
        }
    ]
}';
$dec = json_decode($json);
$users = array();
if (! empty($dec->workers)) {
    foreach ($dec->workers as $worker) {
        $user['email'] = $worker->email;
        $user['manager_email'] = $worker->manager->email;
        $users[] = $user;
    }
}
echo '<pre>';print_r($users);echo '</pre>';
?>

Output:

Array
(
    [0] => Array
        (
            [email] => micky@mcgurk.com
            [manager_email] => boss@mcgurk.com
        )

    [1] => Array
        (
            [email] => michelle@mcgurk.com
            [manager_email] => another_boss@mcgurk.com
        )

)

Now, loop over $dec->workers and you will get the required email addresses.

edited Jun 18 '18 at 09:37

answered Jun 18 '18 at 09:34

Pupil

23,528
5
42
64

Hi @Pupil - this is great! I'm looking to insert these into a table in my database. Instead of `print_r($dec->employees);` - is there a way to loop through (foreach?) and output each row in a line? – michaelmcgurk Jun 18 '18 at 09:37
1

@michaelmcgurk, answer updated. Please verify. – Pupil Jun 18 '18 at 09:38
Is it something like `foreach ($dec->workers as &$value) {echo $value['email'];}`? – michaelmcgurk Jun 18 '18 at 09:38
1

Thank you so much, Pupil. That is incredibly helpful. Thanks for your patience here too. I have learned a lot today :-) – michaelmcgurk Jun 18 '18 at 09:39
1

@michaelmcgurk, nothing special about. When I was a neophyte, people helped me to learn. This is the way we grow. :) – Pupil Jun 18 '18 at 09:40
1

You are welcome! – Pupil Jun 18 '18 at 09:59

score 1 · Answer 3 · answered Jun 18 '18 at 09:33

1

$data = json_decode($response, true);

answered Jun 18 '18 at 09:33

Militaru

483
5
9

Loop through JSON response using PHP

3 Answers3