how to get json data array with for loop

Question

I have a question about for loop. I am saving json data just in one column. For example:

1 / John / ["jsondata1","jsondata2","jsondata3"]
2 / Elizabeth / ["jsondata3","jsondata4"]

I need to show this values in a table. 3rd column max data size is allways 4. there is no jsondata5

I was created this loop in my blade view.

<table>
@foreach($values  as $value)
    <tr>
        <td>{{$value->id}}</td>
        <td>{{$value->name}}</td>
        @for ($i = 0; $i < 4; $i++)
        <td>{{$value->jsondata[$i]}}</td>
        @endfor
    </tr>
@endforeach
</table>

In this case i am getting some errors. Error is "Undefined offset: 2"

When i tried for ($i = 0; $i < 2; $i++)

it just show the last 2 data. But if i tried $i < 4 there is an error.

What is the right way to do this for loop? I tried so much ways.

json_decode($payload) ?

Leo
– Leo

2018-01-27 16:20:14 +00:00
Commented Jan 27, 2018 at 16:20 — Leo
– Leo, Commented Jan 27, 2018 at 16:20
i used json_decode in my controller.

Ali Özen
– Ali Özen

2018-01-27 16:23:50 +00:00
Commented Jan 27, 2018 at 16:23 — Ali Özen
– Ali Özen, Commented Jan 27, 2018 at 16:23

Alexey Mezenin · Accepted Answer · 2018-01-27 16:21:39Z

1

The best way to handle this is to use casting. From the docs:

The array cast type is particularly useful when working with columns that are stored as serialized JSON. For example, if your database has a JSON or TEXT field type that contains serialized JSON, adding the array cast to that attribute will automatically deserialize the attribute to a PHP array when you access it on your Eloquent model

Add this to the model and you'll be able to work with JSON data as with a simple array:

protected $casts = [
    'column_name' => 'array',
];

answered Jan 27, 2018 at 16:21

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

4 Comments

Leo Over a year ago

thats a great hidden feature.

Ali Özen Over a year ago

Its already added. I tried this today but i couldn't make it.

Ali Özen Over a year ago

You solved my all issues @Alexey Mezenin I am believing you can give me the solution. I got still same problem.

Alexey Mezenin Over a year ago

@AliÖzen please show results of {{ dd($values) }}

Collectives™ on Stack Overflow

how to get json data array with for loop

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest