How to iterate a JSON ARRAY with Laravel Blade?

Question

I am trying to iterate through the values of a JSON ARRAY with no success. When the file has a single value, I loop through it with no problem.

Controller

$data = '[{
        "T": {
            "HD": {
                "HD01": "1",
                "HD02": "06033942",
                "HD03": "3736803"
                }
            }
         }]';
             
      $data = json_decode($data);
      return view('dashboard.book.index', ['data' => $data[0]]);

Blade

<tbody>
        @foreach($data as $item)
            <tr>
                 @foreach($item->HD as $title)
                <td>{{ $title }}</td>
                 @endforeach
            </tr>
        @endforeach
<tbody>

Result

Table

But when it starts to have more than one value, I can't get the same results:

Controller

$data = '[{
        "T": {
            "HD": {
                "HD01": "1",
                "HD02": "06033942",
                "HD03": "3736803"
                }
            }
        },
        {
        "T": {
            "HD": {
                "HD01": "2",
                "HD02": "06035419",
                "HD03": "4736521"
                }
            }
        }]';

$data = json_decode($data);
return view('dashboard.book.index', ['data' => $data]);

Result

Error

With $data[0] I get the values individually, but when I want to send the whole array I get errors.

How can I modify my code to make it work?

Peppermintology · Accepted Answer · 2022-08-31 20:45:26Z

1

It might be easier to convert the JSON to an associative array and then to a Laravel collection in order to use some of the helper methods available.

So for example:

return view('dashboard.book.index', [
    'data' => collect(json_decode($data, true))->flatten(2)
]);

Then in your blade view file:

<table>
    <tr>
        @foreach ($data->first() as $key => $value)
            <th>{{ $key }}</th>
        @endforeach
    </tr>
    @foreach ($data as $items)
        <tr>
            @foreach ($items as $key => $value)
                <td>{{ $value }}</td>
            @endforeach
        </tr>
    @endforeach
</table>

Update

If you want to remove certain keys from the $data variable, you could do the following:

$keysToRemove = ['HD02', 'HD06'];

$data = collect(json_decode($data, true))
    ->flatten(2)
    ->map(function ($array, $key) use ($keysToRemove) {
        foreach ($keysToRemove as $key) {
            if (array_key_exists($key, $array)) {
                unset($array[$key]);
            }
        }
        return $array;
});

return view('dashboard.book.index', [
    'data' => $data
]);

edited Aug 31, 2022 at 20:45

answered Aug 31, 2022 at 15:20

Peppermintology

10.4k4 gold badges34 silver badges60 bronze badges

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

3 Comments

Adolfi Téllez Over a year ago

It works perfectly. I'll put you as the correct answer... I only have one more question: how do I have control over the <th> to obtain the individual values?... For example, if I want to obtain 'HD01' and 'HD08', and I want to remove 'HD06 '....

Peppermintology Over a year ago

@AdolfiTéllez Have a look at my update which I think answers your second question about removing unwanted elements based on the array key.

Adolfi Téllez Over a year ago

Dude, you're a genius... You have my respect... I really appreciate it...

Kevin · Accepted Answer · 2022-08-31 14:46:09Z

0

On your controller:

  $data = json_decode($data, true);

The second parameter When true, returned objects will be converted into associative arrays.

answered Aug 31, 2022 at 14:46

Kevin

1,1936 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to iterate a JSON ARRAY with Laravel Blade?

2 Answers 2

Update

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Update

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related