how get all the data from json file using foreach in laravel?

Question

My laravel controller

   public function index()
    { 
    $get=Storage::disk('public')>get('Philippines.json');
    $json = json_decode($get, true); 
           
    return view('BarangayFolder.index')>with('json',$json);

the output i'm trying to achieve on my option tag is something like this;

    "BANI"
    "BUYON"
    "CABARUAN"
    "CABULALAAN"
    "CABUSLIGAN"
    "CALIOET-LIBONG"
    "CASILIAN"
    "COROCOR"

i'cant figure out how to get all the of "barangay_list" data, i tried many solution and ideas but still not getting it.

{
      "01": {
        "region_name": "REGION 1",
        "province_list": {
          "ILOCOS NORTE": {
            "municipality_list": {
              "ADAMS": {
                "barangay_list": [
                  "ADAMS (POB.)"
                ]
              },
              "BACARRA": {
                "barangay_list": [
                  "BANI",
                  "BUYON",
                  "CABARUAN",
                  "CABULALAAN",
                  "CABUSLIGAN",
                  "CADARATAN"
                ]
      }

}

i managed to get thedata of "region_name" which is "REGION 1" but i can't get the data of barangay_list.

<datalist id="datalist-content"> 
      foreach (array($json['01']) as $data)
            <option value="{{$data['region_name']}}"></option>
      endforeach
</datalist>

what is the error?

Babak Asadzadeh
– Babak Asadzadeh

2020-11-25 11:27:51 +00:00
Commented Nov 25, 2020 at 11:27 — Babak Asadzadeh
– Babak Asadzadeh, Commented Nov 25, 2020 at 11:27

Navid Anjum · Accepted Answer · 2021-03-26 18:25:09Z

1

You need to understand your json file to get proper data.

You want data of barangay_list. If we create a tree of your data it should look like following:

-01
--province_list
----->ILOCOS NORTE
----------->municipality_list
------------------>BACARRA
--------------------->barangay_list

Either you can use

foreach ($json['01']['province_list']['ILOCOS NORTE']['municipality_list']['BACARRA']['barangay_list'] as $data)
     <option value="{{$data}}"></option>
endforeach

or you can first save you list in variable and use it in loop

@php
       $barangay_list = $json['01']['province_list']['ILOCOS NORTE']['municipality_list']['BACARRA']['barangay_list'];
@endphp
@foreach ($barangay_list as $data)
         <option value="{{$data}}"></option>
@endforeach

You have used true with json_decode that will convert data into array so you dont need to add array function to convert in array.

edited Mar 26, 2021 at 18:25

answered Nov 25, 2020 at 12:49

Navid Anjum

927 bronze badges

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

Comments

sandip bharadva · Accepted Answer · 2020-11-25 11:42:33Z

1

your loop is not proper try with below code

<datalist id="datalist-content"> 
             foreach (array($json['01']['province_list']['ILOCOS NORTE']['municipality_list']['BACARRA']['barangay_list']) as $data)
              <option value="{{$data}}">{{$data}}</option>
             endforeach
</datalist>

answered Nov 25, 2020 at 11:42

sandip bharadva

6341 gold badge6 silver badges21 bronze badges

1 Comment

Ken Torres Over a year ago

Thank you for the idea sir sandy, it works well now after removing the array inside foreach.

Collectives™ on Stack Overflow

how get all the data from json file using foreach in laravel?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related