How to fetch Array from .json in PHP

Question

I have json document with Indian States[Cities[Area]], similar to the following:

{
    "Andaman and Nicobar Islands": [{
            "Port Blair": [
                "Aberdeen Bazaar",
                "Bidhabad Village",
                "Chidiyatapu",
                "Corbyns Cove",
                "Dollygunj",
                "Ferrurgunj",
                "Goalghar",
                "Goodwill Estate",
                "Junglighat",
                "Marine Hill",
                "Phoenix Bay",
                "South Point"
            ]
        },
        {
            "Havelock Island": [
                "Govindnagar Beach",
                "Radhanagar Beach",
                "Vijaynagar Beach"
            ]
        },
        {
            "Neil Island": [
                "Ramnagar",
                "Bharat Pur",
                "Sitapur Beach",
                "Laxmanpur",
                "Neil Kendra"
            ]
        }....
}

I want to fetch this array in this format:

$stateData['Andaman and Nicobar Islands'] => [
    "Port Blair" => [
        "Aberdeen Bazaar" => "Aberdeen Bazaar",
        "Bidhabad Village" => "Bidhabad Village"
         .
         .
         .
    ]
]

and so on... I have this Json data in a json file and assign the value to a variable $stateData using $stateData = (array)json_decode(fread($file, filesize(public_path('india_state_city1.json'))));

Possible duplicate of [json\_decode to array](https://stackoverflow.com/questions/5164404/json-decode-to-array) — Adnan Y, Oct 26 '19 at 04:57
Check this demo of your code. https://paiza.io/projects/KtY-0X5O2Kc4LZSgJmctLQ — Nasser Ali Karimi, Oct 26 '19 at 05:00
as we can see in the [link](https://paiza.io/projects/KtY-0X5O2Kc4LZSgJmctLQ) json_decode() is returning multidimensional index array. i want that array as associative which have the key and value with same string. — Sahyog Vishwakarma, Oct 26 '19 at 05:04
I think It needs to implements it with some custom code, is it okay? — Nasser Ali Karimi, Oct 26 '19 at 05:21

Sajad Haibat · Answer 1 · 2019-10-26T06:03:07.573

I assume that your json is saved in a variable called $states.

  foreach (json_decode($states) as $key => $state) {
            foreach ($state as $stateData) {
                foreach ($stateData as $key2 => $city) {
                    foreach ($city as $key3 => $cit) {

                        $res[$key][$key2][$cit] = $cit;
                    }
                }

            }
        }

The output:

Check the Demo: https://paiza.io/projects/NlK9g5jluy8Lz9kmhMW69Q

Mohamed-Foly · Answer 2 · 2019-10-26T05:18:05.827

0

i got that you want to make the area array to be associative and the id,value is same. i f i'm right you can do this :

foreach ($stateData['Andaman and Nicobar Islands'] as &$array_1) {
    foreach ($array_1 as &$area_array){
        $formatted_array = [];
        foreach ($area_array as $area){
            $formatted_array[$area] = $area;
        }
        $area_array = $formatted_array;
    }
}

edited Oct 26 '19 at 05:18

answered Oct 26 '19 at 05:03

Mohamed-Foly

1
3

lets say i have $user->city and $user->area, and variables $stateData, $cities, $areas. for $cities array should be from $cities = $stateData[$user->state] , and for areas $area = $cities[$user->state] – Sahyog Vishwakarma Oct 26 '19 at 05:15

score 0 · Answer 3 · answered Oct 26 '19 at 07:36

long but simple solution i think

in my opinion json_decode function will help with second parameter passed as true because it will convert every inner object to array

by converting to array we can easily use the state,city and area name and if you want ordering even you can do that by key no of array

<?php
        $data = '{
              "Andaman and Nicobar Islands": [
                      {
    "Port Blair": [
        "Aberdeen Bazaar",
        "Bidhabad Village",
        "Chidiyatapu",
        "Corbyns Cove",
        "Dollygunj",
        "Ferrurgunj",
        "Goalghar",
        "Goodwill Estate",
        "Junglighat",
        "Marine Hill",
        "Phoenix Bay",
        "South Point"
    ]
},
{
    "Havelock Island": [
        "Govindnagar Beach",
        "Radhanagar Beach",
        "Vijaynagar Beach"
    ]
},
{
    "Neil Island": [
        "Ramnagar",
        "Bharat Pur",
        "Sitapur Beach",
        "Laxmanpur",
        "Neil Kendra"
          ]
      }
            ]
  }';
      $indian_states = json_decode($data,TRUE);

       foreach ($indian_states as $stateName=>$statesCities)
                {
                echo $stateName;

                foreach ($statesCities as $citiNo=>$cityAreas)
                       {
                            echo '<br />&nbsp;&nbsp;&nbsp;&nbsp;|---'; //comment this line
                            foreach ($cityAreas  as $citiName=>$areas)
                                   {
                                       echo $citiName;

                                       foreach ($areas as $areaName){
                                                  echo "<br     />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;|---"; //comment this line                                                 echo $areaName;echo '<br />';
                         }
                     }
              }
         }

      ?>

output

How to fetch Array from .json in PHP

3 Answers3