Laravel select query returning array

Question

My select query is returning an array... but I would like for it to return an object

PHP:

$language = DB::select(select query here);

I tried adding ->get() after but it seems that I can't add that to an array.

Tosin John · Accepted Answer · 2017-06-28 22:59:25Z

6

Yes, It's supposed to return an array of stdClass objects, no need for ->get when usind DB:select to run raw MySql code.

If you are selecting a row with the raw sql, then you can access the object for that row as $language[0], else you have to loop through it.

answered Jun 28, 2017 at 22:59

Tosin John

5247 silver badges15 bronze badges

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

Comments

Don't Panic · Accepted Answer · 2017-06-28 22:51:14Z

2

->get() returns a collection. If you just want to get one object, use ->first() instead.

See the query builder documentation under "Retrieving A Single Row / Column From A Table" for more details.

answered Jun 28, 2017 at 22:51

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges