Retrieve data from Collection object in Laravel

Question

I have something like this in my controller:

$item = item::where('id',1)->first();

I get a Collective object.

I want to retrieve a specific table from such item.

$item->only(['name]);

So I can give it to the view. However it won't work.

BadMethodCallException in Builder.php line 2508: Call to undefined method Illuminate\Database\Query\Builder::only()

How do I retrieve this concrete variable?

Alexey Mezenin · Accepted Answer · 2017-02-01 13:21:45Z

3

When you're using first() method, you get an object, so you can just access it's properties:

$item = item::where('id',1)->first();
$name = $item->name;

answered Feb 1, 2017 at 13:21

Alexey Mezenin

164k27 gold badges309 silver badges287 bronze badges

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

3 Comments

Noni Over a year ago

@alexyMezenin , when I use ->get() collection colud not return on $item->name , that return on $item[0]->name, can you explain this please thank you

Haisum Usman Over a year ago

@noni, when you use first() instead of get() you will always get the root level object instead of array of object therefore $item instead of $item[0]

Noni Over a year ago

Thanks, Haisum I posted that in 2018 :) Laravel 5 newly arrived at that time. Thanks anyways :)

Vikash · Accepted Answer · 2017-02-01 13:30:18Z

1

You can try this for retrieving the single value

$name = item::where('id',1)->value('name');

answered Feb 1, 2017 at 13:30

Vikash

3,5843 gold badges25 silver badges39 bronze badges

Comments

Ratana Dev · Accepted Answer · 2019-08-30 10:36:15Z

0

You can use any way that you want like as select or pluck

So if you wish to retrieve only column name you can try :

$item = item::where('id', 1)->select('name')->first();
$item->name;

or

$item = item::where('id', 1)->pluck('name')->first();

I hope it can help you to retrieve data for difference situation.

Thanks !

answered Aug 30, 2019 at 10:36

Ratana Dev

665 bronze badges

Collectives™ on Stack Overflow

Retrieve data from Collection object in Laravel

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related