Laravel. Get single column values of a table using Query Builder

Question

I have a table named "items" and an input for the where condition named "ref_code".

$items = DB::table('items')
             ->where('ref_code','=', $request->ref_code)
             ->get(['id', 'ref_code', 'name','price']);

But I can't seem to take the values of each column.

I checked wether the query builder worked or not by using:

return $items;

Fortunately, there's no problem.

But returning or getting a single value doesn't work with:

return $items->id

Is my syntax wrong? All of this are inside my controller.

EDIT: I tried

dd($items);

before returning and it showed me this:

  Collection {#325 ▼
  #items: array:1 [▼
    0 => {#322 ▶}
  ]
}

P.S: I used POST method to throw the ref_code input from the blade. — Jan Ariel San Jose
– Jan Ariel San Jose, Commented Jul 22, 2017 at 4:45
$items would be a collection, hence you would need to loop through $items to get its properties — linktoahref
– linktoahref, Commented Jul 22, 2017 at 4:45

Md. Abutaleb · Accepted Answer · 2017-07-22 05:00:09Z

8

Thanks for updating your question with the result. Look at your debug result. it looks like

array:1 [▼
    0 => {#322 ▶}
  ]

That means your query returning a collection of arrays because of you're using get() method. so get() method always return a collection of an array.

For avoiding this problem you have to use first() method instead of get(). Remember: all the time you have to use first() method when you want to get a single row.

So your query should be like :

$items = DB::table('items')
             ->select('id', 'ref_code', 'name', 'price')
             ->where('ref_code','=', $request->ref_code)
             ->first();

Or

$item = YourModelName::select('id', 'ref_code', 'name', 'price')
             ->where('ref_code','=', $request->ref_code)
             ->first();

And finally get output as like $item->id, $item->ref_code etc.

Hope it will help.

References: https://laravel.com/docs/5.4/queries#retrieving-results

answered Jul 22, 2017 at 5:00

Md. Abutaleb

1,6551 gold badge15 silver badges24 bronze badges

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

2 Comments

Jan Ariel San Jose Over a year ago

Thank you! This worked like magic like the other answer. Big help guys. :)

Md. Abutaleb Over a year ago

Select my provided solution as an answer. So it will be helpful for me as well.

linktoahref · Accepted Answer · 2017-07-22 04:53:01Z

2

get() would return a collection

$items = DB::table('items')
         ->where('ref_code','=', $request->ref_code)
         ->get(['id', 'ref_code', 'name','price']);

In the above case $items would be a collection, hence you need to loop through the collection to access the properties

foreach ($items as $item) {
    $item->price;
}

If you'd need to return a Model instance you could use the method first() instead

$items = DB::table('items')
             ->select('id', 'ref_code', 'name', 'price')
             ->where('ref_code','=', $request->ref_code)
             ->first();

and access the properties as

$items->price;

answered Jul 22, 2017 at 4:53

linktoahref

8,0273 gold badges32 silver badges54 bronze badges

Comments

Alireza Rahmani Khalili · Accepted Answer · 2022-12-06 21:32:36Z

0

Try this using model

$result =  Model_name::where('ref_code','=', $request->ref_code)
                       ->first(['id', 'ref_code', 'name', 'price']);

edited Dec 6, 2022 at 21:32

Alireza Rahmani Khalili

3,0042 gold badges34 silver badges38 bronze badges

answered Jul 22, 2017 at 5:27

sanjiv pandey

214 bronze badges

Collectives™ on Stack Overflow

Laravel. Get single column values of a table using Query Builder

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related