Parsing and echoing JSON with PHP

Question

Ok I have banged my head for the last 24hrs and cannot figure this out after testing and reading SO. I have a JSON file that I need to parse and for some reason I cannot get the right combination of code to echo anything out other than "Array" or "Trying to get property of non-object" or "Invalid argument supplied for foreach()". Here is the full JSON that I am trying to iterate over. I need to print out the name of each 'project', the 'dataset' in each project, and the 'permissions' for each 'dataset'. I am building this JSON myself, so I can change the format if necessary.

$data = json_decode($json, true);

Outputs JSON below:

[
   [
      {
         "projects":[
            {
               "project":"test-project-1",
               "datasets":[
                  {
                     "dataset":"testing1",
                     "permissions":[
                        {
                           "role":"READER",
                           "google_group":"[email protected]"
                        }
                     ]
                  },
                  {
                     "dataset":"testing2",
                     "permissions":[
                        {
                           "role":"OWNER",
                           "google_group":"[email protected]"
                        }
                     ]
                  },
                  {
                     "dataset":"testing3",
                     "permissions":[
                        {
                           "role":"READER",
                           "google_group":"[email protected]"
                        }
                     ]
                  },
                  {
                     "dataset":"testing4",
                     "permissions":[
                        {
                           "role":"WRITER",
                           "google_group":"[email protected]"
                        }
                     ]
                  }
               ]
            },
            {
               "project":"test-project-2",
               "datasets":[
                  {
                     "dataset":"testing1",
                     "permissions":[
                        {
                           "role":"READER",
                           "google_group":"[email protected]"
                        }
                     ]
                  },
                  {
                     "dataset":"testing2",
                     "permissions":[
                        {
                           "role":"READER",
                           "google_group":"[email protected]"
                        }
                     ]
                  },
                  {
                     "dataset":"testing3",
                     "permissions":[
                        {
                           "role":"READER",
                           "google_group":"[email protected]"
                        }
                     ]
                  },
                  {
                     "dataset":"testing4",
                     "permissions":[
                        {
                           "role":"READER",
                           "google_group":"[email protected]"
                        }
                     ]
                  }
               ]
            }
         ]
      }
   ]
]

I have tried things like:

foreach($data->projects as $output)
{
    echo $output->project . "\n";
    foreach($output->datasets as $datasets)
    {
        echo $output->dataset . "\n";
    }
}

Thank you for the help!

EDIT: Working code that parses the JSON above:

$projects = $json['projects'];
foreach ($projects as $project) {
    echo $project['project'] . "<br>";
    foreach ($json['projects'][0]['datasets'] as $datasets){
        echo $datasets['dataset'] . "<br>";
        foreach ($json['projects'][0]['datasets'][0]['permissions'] as $permissions){
            echo $permissions['role'] . "<br>";
            echo $permissions['google_group'] . "<br>";
        }
    }
}

var_dump($output->dataset);

Matt
– Matt

2017-03-28 18:30:29 +00:00
Commented Mar 28, 2017 at 18:30 — Matt
– Matt, Commented Mar 28, 2017 at 18:30

Philipp · Accepted Answer · 2017-03-28 19:01:13Z

2

Your json contains two nested arrays, which contain the object, you want. So first you could use something like [0][0] to get the associative array, which contains the project.

// ...
$projects = $json['projects'];
foreach ($projects as $project) {
    echo "Project: " . $project['project'] . "\n";
    foreach ($project['datasets'] as $dataset) {
        echo "Dataset: " . $dataset['dataset'];
        foreach ($dataset['permissions'][0] as $key => $value) {
            // ...
        }
    }
}

edited Mar 28, 2017 at 19:01

answered Mar 28, 2017 at 18:34

Philipp

15.6k4 gold badges37 silver badges53 bronze badges

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

3 Comments

user3282173 Over a year ago

Ok Philip I'm getting somewhere, $projects = $json[0][0]['projects']; did not work but $projects = $json['projects']; foreach ($projects as $project) { echo $project['project']; }did work and successfully printed the 2 project names. How would I then proceed to print the dataset names and their permissions?

Philipp Over a year ago

@user3282173 seems like, you posted the wrong json in your post, if you dont need the [0][0] part. However - I updated my answer to read permissions and datasets

user3282173 Over a year ago

Thanks Philip, you led me in the correct direction. I posted the updated code that now works and prints as expected. Thank you for the quick response!

Collectives™ on Stack Overflow

Parsing and echoing JSON with PHP

1 Answer 1

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Related