Laravel: how to get value from query builder object

Question

I am new in laravel. i have a table but dont have model for this. I am using below to fetch record.

$classes = DB::table('school_classes')->get();
return view('classes', ['allClass' => $classes]);

it returns below:

[{"id":1,"register_school_id":1,"class":"I","section":"A","created_at":"2020-03-19 00:00:00","updated_at":"2020-03-19 00:00:00"},
{"id":2,"register_school_id":1,"class":"I","section":"B","created_at":"2020-03-19 00:00:00","updated_at":"2020-03-19 00:00:00"},
{"id":3,"register_school_id":1,"class":"I","section":"C","created_at":"2020-03-19 00:00:00","updated_at":"2020-03-19 00:00:00"},    {"id":4,"register_school_id":1,"class":"I","section":"D","created_at":"2020-03-19 00:00:00","updated_at":"2020-03-19 00:00:00"},        
{"id":5,"register_school_id":1,"class":"I","section":"E","created_at":"2020-03-19 00:00:00","updated_at":"2020-03-19 00:00:00"}]

how I can pick the value separately of each item... i tried foreach but getting error. plz help. thanks in advance.

In Laravel, if you echo out objects, they are automatically translated to json. Try the dump and die helper dd($allClass); to see the real object. Make use of models. It will greatly speed up the coding of your project. — Dimitri Mostrey
– Dimitri Mostrey, Commented Mar 20, 2020 at 8:38

Yamen Ashraf · Accepted Answer · 2020-03-19 21:43:22Z

3

The query builder returns a Illuminate\Support\Collection instance. You can access the collection as below:

@foreach($allClass as $class)
    {{ $class->id }}
@endforeach

Also check Collections

answered Mar 19, 2020 at 21:43

Yamen Ashraf

2,9782 gold badges25 silver badges28 bronze badges

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

Comments

shaedrich · Accepted Answer · 2023-10-12 14:30:45Z

0

You want to get data in array format, then you can use "toArray" & also easily access data using foreach loop Laravel function.

$classes = DB::table('school_classes')->get()->toArray();

return view('classes', ['allClass' => $classes]);

edited Oct 12, 2023 at 14:30

shaedrich

5,7633 gold badges31 silver badges47 bronze badges

answered Mar 20, 2020 at 12:32

Raghu Aryan

931 silver badge6 bronze badges

Collectives™ on Stack Overflow

Laravel: how to get value from query builder object

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related