Laravel, get nested array

Question

So, this is my json format data

{
   "New Purchase Orders Created":{
      "date":"2018-02-26 14:05:14.000000",
      "timezone_type":3,
      "timezone":"UTC"
   },
   "colour":"bg-primary"
}

This is my view in blade.php

<ul class="list-group list-group-flush">
         @foreach( $notifications as $notification )
                <?php $notificationData = json_decode($notification->data, true);?>
         @foreach( $notificationData as $key=>$item )
                <li class="list-group-item text-white {{ $notificationData['colour'] }}">
                  @if ($key!='colour')
                      {{ $key }}<br>  
                      {{ $item['date'] }}

                  @endif
                </li>
          @endforeach
          @endforeach
</ul>

I want to get the data into the blade. So what should I do?

This is what i want to get.

Please help. Thanks.

Why is the notification title the key for the date?

Phiter
– Phiter

2018-02-26 14:47:28 +00:00
Commented Feb 26, 2018 at 14:47 — Phiter
– Phiter, Commented Feb 26, 2018 at 14:47
@Phiter it's because this is notification view

BlackLotus
– BlackLotus

2018-02-26 14:59:57 +00:00
Commented Feb 26, 2018 at 14:59 — BlackLotus
– BlackLotus, Commented Feb 26, 2018 at 14:59

Adlan Arif Zakaria · Accepted Answer · 2018-02-26 15:54:41Z

1

Assuming the above JSON is an object array like this:

<?php
$notifications = '[{
   "New Purchase Orders Created":{
      "date":"2018-02-26 14:05:14.000000",
      "timezone_type":3,
      "timezone":"UTC"
   },
   "colour":"bg-primary"
},
{
   "New Purchase Orders Created":{
      "date":"2018-02-26 14:05:14.000000",
      "timezone_type":3,
      "timezone":"UTC"
   },
   "colour":"bg-primary"
}]';
?>

Thus, the script will be like this:

<ul class="list-group list-group-flush">
    @foreach( json_decode($notifications, true) as $notification => $data )
        <?php $item = $data[key($data)]; ?>
        <li class="list-group-item text-white {{ $data['colour'] }}">
            {{ key($data) }}<br>  
            {{ $item['date'] }}
        </li>
    @endforeach
</ul>

edited Feb 26, 2018 at 15:54

answered Feb 26, 2018 at 15:39

Adlan Arif Zakaria

1,7451 gold badge11 silver badges14 bronze badges

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

2 Comments

BlackLotus Over a year ago

Undefined offset: 0. Error =(

Adlan Arif Zakaria Over a year ago

I made changes to my answer, can you please verify?

Alexey Mezenin · Accepted Answer · 2018-02-26 15:23:44Z

0

Use json_decode. This works with JSON you've shown:

{{ json_decode($json, true)['New Purchase Orders Created']['date'] }}

If New Purchase Orders Created key may be different in every JSON, use the array_first() helper:

{{ array_first(json_decode($json, true))['date'] }}

If you will have many elements, iterate over them:

$array = json_decode($json, true);
@foreach ($array as $key => $element)
    {{ $array[$key]['date'] }}
@endforeach

edited Feb 26, 2018 at 15:23

answered Feb 26, 2018 at 14:47

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

10 Comments

BlackLotus Over a year ago

If not only just have the ['New Purchase Orders Created'], but ['Purchase Orders Arrived'] or somthing different can i still read? Or I have to change to using index? But how to use indexing?

Alexey Mezenin Over a year ago

@JweiWei if you'll use array_first() as I've shown, it doesn't matter what key the array has.

BlackLotus Over a year ago

If now i got many and many data in, how should i get the second, third and fourth one?

Alexey Mezenin Over a year ago

@JweiWei iterate over the array with foreach(). I've updated the answer.

BlackLotus Over a year ago

Its output me an error "Illegal string offset 'date'"

|

Collectives™ on Stack Overflow

Laravel, get nested array

2 Answers 2

2 Comments

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related