How to get data from array in object in php?

Question

In a database table - about_us, I have a column named subject

I am trying to make a table from this data in laravel

Column subject looks like this:

[
    {
        "name1": "1",
        "name2": "2"
    },
    {
        "name1": "3",
        "name2": "4"
    }
]

from controller

public function about()
{
    $about  = About::find(1);
    return view('pages.about-us', compact('about'));
}

in about-us.blade.php

{{$about->subject}}

How can I extract the data to make a table like this?

You could start writing some code for that - what have you tried, where are you stuck? Without any details about the logic, there is no way to help you — Nico Haase
– Nico Haase, Commented Nov 13, 2019 at 10:55

Qirel · Accepted Answer · 2019-11-13 11:13:41Z

2

The contents of your subject property is a JSON string. Which means that you will have to decode it through json_decode() into an array/object before your can iterate over it.

<table>
    <thead>
        <tr>
            <th>right</th>
            <th>left</th>
        </tr>
    </thead>
    <tbody>
        @foreach(json_decode($about->subject) as $subject)
            <tr>
                <td>{{ $subject->name1 }}</td>
                <td>{{ $subject->name2 }}</td>
            </tr>
        @endforeach
    </tbody>
</table>

answered Nov 13, 2019 at 11:13

Qirel

26.6k7 gold badges54 silver badges71 bronze badges

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

Comments

Dmitry Leiko · Accepted Answer · 2019-11-13 12:10:35Z

1

Try code below:

<table>
    <tr>
        <td>right</td>
        <td>left</td>
    </tr>
    @foreach(json_decode($about->subject) as $subject)
        <tr>
            <td>{{ $subject->name1 }}</td>
            <td>{{ $subject->name2 }}</td>
        </tr>
    @endforeach
</table>

edited Nov 13, 2019 at 12:10

answered Nov 13, 2019 at 10:54

Dmitry Leiko

4,4923 gold badges29 silver badges48 bronze badges

Comments

Jaymin · Accepted Answer · 2019-11-13 11:03:36Z

0

<table>
<thead>
    <th><strong>right</strong></th>
    <th><strong>left</strong></th>
</thead>
<tbody>
@foreach($about->subject as $subject)
        <tr>
            <td>{{ $subject->name1 }}</td>
            <td>{{ $subject->name2 }}</td>
        </tr>
    @endforeach
</tbody>
</table>

Just loop over the data

answered Nov 13, 2019 at 11:03

Jaymin

1,6612 gold badges20 silver badges42 bronze badges

Comments

Shougat Mahmud Zihan · Accepted Answer · 2019-11-13 11:08:50Z

0

Try this

<table>
<thead>
      <tr>
        <th>Right</th>

        <th>Left</th>

       </tr>
</thead>
<tbody>
@foreach($about->subject as $subject)
    <tr>
        <td>{{ $subject->name1 }}</td>
        <td>{{ $subject->name2 }}</td>
    </tr>
@endforeach


</tbody>
</table>

answered Nov 13, 2019 at 11:08

Shougat Mahmud Zihan

3,7421 gold badge17 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to get data from array in object in php?

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related