How to display array data from json field to the blade view?

Question

I created a json field produce_stored to store array data.

Warehouse Table Structure

In the Warehouse Model I'm using $casts to store the array data

protected $casts = [
    'produce_stored' => 'array'
];

In the WarehouseController - index method

$warehouses = DB::table('warehouses')
                ->join('regions', 'regions.id', '=', 'warehouses.region_id')
                ->join('districts', 'districts.id', '=', 'warehouses.district_id')
                ->join('users', 'users.id', '=', 'warehouses.agent_assigned')
                ->select(
                    'warehouses.id',
                    'warehouses.name as warehouseName',
                    'warehouses.ownership_type',
                    'warehouses.capacity',
                    'warehouses.produce_stored',  // json field with array data
                    'regions.name as regionName', 
                    'districts.name as districtName',
                    'users.name as agent_assigned',
                    'warehouses.status'
                    )
                ->get();

return view('admin.warehouses.index', compact('warehouses'));

In the blade view

{{ $warehouse->produce_stored }}

This is the output in the browser

["1", "2"]

When I try looping through the array to get the produce ids to load the produce names

@foreach ($warehouse->produceStored as $produce)
    {{$produce}}
@endforeach

The above throws an error

Invalid argument supplied for foreach()

How do I get the produce ids from the produce_stored field?

Problem is, that you are not using model, but DB call. In his case, the casting is not called. Replace DB::table('warehouses') with model calling, \App\Warehouse::select ... (correct Model placing) — Autista_z
– Autista_z, Commented May 31, 2020 at 12:59

OMR · Accepted Answer · 2020-05-31 13:06:48Z

3

you have two choices:

 <?php $warehouse->produceStored = json_decode($warehouse->produceStored, false); ?>

and then try

@foreach ($warehouse->produceStored as $produce)
    {{$produce}}
@endforeach

2- like Autista_z said in comment:

$warehouses = Warehouse::query()
                ->join('regions', 'regions.id', '=', 'warehouses.region_id')
                ->join('districts', 'districts.id', '=', 'warehouses.district_id')
                ->join('users', 'users.id', '=', 'warehouses.agent_assigned')
                ->select(
                    'warehouses.id',
                    'warehouses.name as warehouseName',
                    'warehouses.ownership_type',
                    'warehouses.capacity',
                    'warehouses.produce_stored',  // json field with array data
                    'regions.name as regionName', 
                    'districts.name as districtName',
                    'users.name as agent_assigned',
                    'warehouses.status'
                    )
                ->get();

note: replace Warehouse with your model name if they are not the same...

answered May 31, 2020 at 13:06

OMR

12.3k5 gold badges26 silver badges39 bronze badges

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

2 Comments

h4kl0rd Over a year ago

Now that the produce ids are listed. How do I retrieve the produce names?

OMR Over a year ago

i think you should load them in controller before send them to view

Collectives™ on Stack Overflow

How to display array data from json field to the blade view?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related