How to get the first record with laravel 4 raw queries

Question

How can i get the first record with laravel 4 raw queries.

Something like DB::select('')->first(); is not working neither did DB::first('')

check this http://stackoverflow.com/questions/14687993/laravel-4-how-to-run-a-raw-sql — jeewiya, Nov 05 '13 at 16:44
@jeewiya i'm asking specifically on how to get the FIRST RECORD like using the first() method like with Eloquent. — Iyad Al aqel, Nov 05 '13 at 16:47
Just added a feature request: https://github.com/laravel/framework/issues/11896 — Meglio, Jan 14 '16 at 23:04

Antonio Carlos Ribeiro · Answer 1 · 2013-11-05T16:56:22.190

27

The fact is that DB:select() returns an array, so you have to:

DB::select(DB::raw('select * from users'))[0];

You also can

DB::table('users')->first();

edited Nov 05 '13 at 16:56

answered Nov 05 '13 at 16:48

This is what i have right now but i was hoping for an alternative. Thanks anyway – Iyad Al aqel Nov 05 '13 at 16:52
Giving another option. But, as I said, select will return an array directly, not an object, so there are no methods. – Antonio Carlos Ribeiro Nov 05 '13 at 16:57
6

DB::select(DB::raw('select * from users'))[0]; triggers an undefined offset exception if no records found – Agu Dondo Feb 13 '15 at 23:25

score 2 · Answer 2 · answered Nov 05 '13 at 16:49

2

Like this:

DB::table('users')->take(1)->get()[0];

answered Nov 05 '13 at 16:49

nikoskip

6

This triggers an undefined offset exception if no records found. – Gras Double Mar 15 '16 at 18:40

score 1 · Answer 3 · answered Mar 18 '15 at 05:07

1

DB::table('users')->first(0);

answered Mar 18 '15 at 05:07

undefined

score 1 · Answer 4 · answered Apr 07 '17 at 15:49

1

When using eloquent you can do this:

 $user = User::take(1)->get();

answered Apr 07 '17 at 15:49

Cengkuru Michael

score 0 · Answer 5 · edited Oct 31 '19 at 08:48

0

Use like this

$allmarketers = ProductStock::take(3)->get()[2];

Take will return how many rows you want and you use the offset like 2 to pick individual rows

edited Oct 31 '19 at 08:48

Pantani

answered Oct 31 '19 at 07:26

Midel Group

5 Answers5