How to fetch JSON data when the values are in below format?

Question

{"cities":[{"city":{"id":1,"name":"Bangalore","status":"Active"}},
{"city":{"id":2,"name":"Mysore","status":"Active"}},... ]}

The above is the JSON format and this is how I fetch from JSON as shown below,

$city=$data['cities'];
$citycount=count($city);
for($i=0;$i<$citycount;$i++)
{
  echo $data['cities'][$i]['city']['id'];
}

Now How to fetch JSON values when the format is like below

{"result":[["id","name","status"],[1,"Bangalore","Active"],[2,"Mysore","Active"],... ]}

I'm using core PHP to fetch data from JSON with the method file_get_contents and json_decode

@PaulCrovella Ya but I'm trying for other format which I specified in above. Trying in different format. — Kirataka, Apr 18 '16 at 06:13
@MubasharAbbas I'm trying to fetch values from new JSON format — Kirataka, Apr 18 '16 at 06:14
json_decode will successfully decode it into a php object. Next you have add some checks for the first array because it has headers as well as data.. after that.. you need a loop for the rest of arrays to extract data. — Mubashar Abbas, Apr 18 '16 at 06:19
@MubasharAbbas It has header but no data in first array. Data are in next array as shown in the SECOND format. — Kirataka, Apr 18 '16 at 06:24
if you look carefully, then the first array has as first element, an array with all the header items. and then the second, third, fourth elements are the values.. — Mubashar Abbas, Apr 18 '16 at 06:26

score 2 · Answer 1 · edited Apr 21 '18 at 19:18

2

Try it like this.

$result = json_decode($newjson);
$result = $result->result;
$data = [];
$headers= $result[0]; // get the first row.
foreach($result as $key => $row) {
   // ignore the headers row.
   if($key != 0) {
       array_push($data, [
          $headers[0] => $row[0],
          $headers[1] => $row[1],
          $headers[2] => $row[2]
       ]);
   }
}

To show these values in form elements like 'dropdown' use this.

<select name="somename">
   <?php foreach($data as $item) { ?>
      <option><?= $item['name'] ?></option>
   <?php } ?>
</select>

edited Apr 21 '18 at 19:18

halfer

19,824
17
99
186

answered Apr 18 '16 at 06:25

Mubashar Abbas

5,536
4
38
49

It is showing invalid argument supplied for `foreach()` – Kirataka Apr 18 '16 at 06:40
Yea.. Now it is displaying the values of JSON. But how to display it in text box or dropdown box. – Kirataka Apr 18 '16 at 06:44
$result = $result->result; are you sure you did this? – Mubashar Abbas Apr 18 '16 at 06:44
that is another concept for starters use – Mubashar Abbas Apr 18 '16 at 06:46
Its working for single value.. How to do it for dynamic values? how to include it in `foreach` – Kirataka Apr 18 '16 at 07:28
could you please accept my answer as the correct one too? – Mubashar Abbas Apr 18 '16 at 09:01
@Mabashar Abbas . Another doubt... The above code is working fine till now only when there is one JSON fetching attempt but how to do the same when there is more than one JSON fetching in `foreach`. Its not working when I implement two `foreach` in same php page. – Kirataka Apr 20 '16 at 04:13
You should post another question for that and if my answer solved your problem, then you should mark it as correct. – Mubashar Abbas Apr 20 '16 at 05:10
also check the tick option below the voting buttons. it will turn green. – Mubashar Abbas Apr 21 '16 at 05:19

score 1 · Answer 2 · answered Apr 18 '16 at 06:59

Try this

$json = '{"result":[["id","name","status"],[1,"Bangalore","Active"],[2,"Mysore","Active"]]} ';
$result = json_decode($json,true);
$dataArray = [];
foreach($result['result'] as $key => $value) {

   if($key != 0) {
       array_push($dataArray, [
          $result['result'][0][0] => $value[0],
          $result['result'][0][1] => $value[1],
          $result['result'][0][2] => $value[2]
       ]);
   }
}
print_r($dataArray);
exit;

score 0 · Answer 3 · answered Apr 18 '16 at 07:44

Here you have a more dynamic method, does not matter what headers you have it will combine automatically, but is very important that each row need to contain the same array length.

$data = '{"result":[["id","name","status"],[1,"Bangalore","Active"],[2,"Mysore","Active"]]}';

$_data = json_decode($data);
if(!empty($_data)){
    $i = 0; //I know that the first row is the header
    foreach($_data->result as $row){
        if($i++ == 0){
            $header = $row;
            continue;
        }
        $newData[] = array_combine($header, $row);
    }
    echo '<pre>';
    print_r($newData);
}

How to fetch JSON data when the values are in below format?

3 Answers3