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?

CodePudding user response：

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>

CodePudding user response：

On your controller:

  $data = json_decode($data, true);

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

CodePudding user response：

If you only want the HD element of each object, you can extract it like this:

$data = json_decode($data, true);
$data = array_column(array_column($data, "T"), "HD");

$data now looks like this:

Array
(
    [0] => Array
        (
            [HD01] => 1
            [HD02] => 06033942
            [HD03] => 3736803
        )

    [1] => Array
        (
            [HD01] => 2
            [HD02] => 06035419
            [HD03] => 4736521
        )

)

And you can use a single simple foreach loop over them.

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

This is pretty much the same as Peppermintology's answer; it's a matter of taste whether you prefer sticking with Laravel's Collections or using PHP's built-in array-handling functions.