Extracting data from multiple Nested Json using PHP

Question

Here's the json

{"msg":"OK","server_time":"2021-11-19 16:41:22","status":200,"result":{"total_pages":1,"files":[{"download_url":"DOWNLOADLINKHERE1","single_img":"IMAGEURLHERE1","file_code":"CODEHERE1","title":"TITLEHERE1"},{"download_url":"DOWNLOADLINKHERE2","single_img":"IMAGEURLHERE2","file_code":"CODEHERE2","title":"TITLEHERE2"}],"results_total":"2","results":2}}

Here's my code

$json = json_decode($data);
foreach($json["result"] as $result){
    foreach($result["files"] as $file){
        echo $file["file_code"];
    }
}

I want to extract all values from the "file_code". I got an error Warning: Invalid argument supplied for foreach()

I was able get the VALUE of the first one using

echo $json->result->files[0]->file_code;

Is it possible to use a LOOP for the files[0]?

So did you check what you're providing as an argument to `foreach`? — miken32, Nov 19 '21 at 18:01
Does this answer your question? [json\_decode to array](https://stackoverflow.com/questions/5164404/json-decode-to-array) — computercarguy, Nov 19 '21 at 18:24

score 0 · Answer 1 · answered Nov 19 '21 at 17:59

0

I replicated your situation and it turns out that your JSON is invalid. You're missing a } at the end.

The reason for not getting an exception is because json_decode does not throw an error by default. You can make it do so by adding the JSON_THROW_ON_ERROR flag, read the docs for more info.

answered Nov 19 '21 at 17:59

renshul

95
1
7

The provided JSON data is clearly not complete, as `....` is not valid JSON. If the JSON were invalid, questions that are the result of a typo are not on-topic and should not be answered. – miken32 Nov 19 '21 at 18:00
@miken32 With the `....` removed the JSON is still invalid. – renshul Nov 19 '21 at 18:07
json is already edited and corrected i guess – Gir brodly Nov 19 '21 at 18:52
Have you tried running the code again with that json? – renshul Nov 19 '21 at 20:16

score 0 · Answer 2 · answered Nov 19 '21 at 19:09

0

This works perfect for me. If you have any thoughts please feel free to correct me.

$num = count($json->result->files);
echo $num;

for($i=0;$i<$num;$i++)
    {
echo $json->result->files[$i]->file_code;
    }

answered Nov 19 '21 at 19:09

Gir brodly

11
3

JMP · Accepted Answer · 2021-11-19T20:01:13.247

This line:

foreach($json["result"] as $result){

sees $json['result'] as an object, and so the next line tests for total_pages["files"], which doesn't exist.

Putting both foreach's together solves the problem:

$data='{"msg":"OK","server_time":"2021-11-19 16:41:22","status":200,"result":{"total_pages":1,"files":[{"download_url":"DOWNLOADLINKHERE1","single_img":"IMAGEURLHERE1","file_code":"CODEHERE1","title":"TITLEHERE1"},{"download_url":"DOWNLOADLINKHERE2","single_img":"IMAGEURLHERE2","file_code":"CODEHERE2","title":"TITLEHERE2"}],"results_total":"2","results":2}}';

$json = json_decode($data, true);
foreach($json["result"]["files"] as $file)
        print $file["file_code"];

Teh playground

Alternatively, make the JSON result into an array, and use object property accessors instead of associative array bindings.

$data='{"msg":"OK","server_time":"2021-11-19 16:41:22","status":200,"result":[{"total_pages":1,"files":[{"download_url":"DOWNLOADLINKHERE1","single_img":"IMAGEURLHERE1","file_code":"CODEHERE1","title":"TITLEHERE1"},{"download_url":"DOWNLOADLINKHERE2","single_img":"IMAGEURLHERE2","file_code":"CODEHERE2","title":"TITLEHERE2"}],"results_total":"2","results":2}]}';
$json = json_decode($data);
foreach($json->result as $result){
    foreach($result->files as $file){
        echo $file->file_code;
    }
}

Teh playground

Extracting data from multiple Nested Json using PHP

3 Answers3