Laravel 4 - DB::select returns array but not found $array[$key]

Question

In laravel 4 route, i have a database query like this

$data1 = DB::select('SELECT MAX(id) AS mxid FROM table_name', array());
return $data1["mxid"];

But it gives the following error:

enter image description here

Help me. I can't understand why this key is not found . If i write

return $data1;

it gives,

[{"mxid":"0"}]

palatok · Accepted Answer · 2014-03-29 07:30:09Z

4

Solution:

return $data1[0]->mxid;

answered Mar 29, 2014 at 7:30

palatok

1,0345 gold badges21 silver badges30 bronze badges

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

1 Comment

Hey, i was stuck on the same thing. How do you count the number of rows the query fetches?

Jason Lewis · Accepted Answer · 2014-03-29 09:26:48Z

3

You could leverage the query builder to make this slightly easier and nicer looking.

return DB::table('table_name')->selectRaw('MAX(id) AS mxid')->pluck('mxid');

This should pluck the mxid column from the result and return it immediately.

answered Mar 29, 2014 at 9:26

Jason Lewis

18.7k4 gold badges63 silver badges65 bronze badges

KalC · Accepted Answer · 2014-09-18 04:01:11Z

1

I am getting "Trying to get property of non-object" error. Any idea?

EDIT:

This solved the problem for me:

return $result[0]['field_name'];

answered Sep 18, 2014 at 3:50

KalC

1,8504 gold badges25 silver badges34 bronze badges