Eloquent ORM laravel 5 Get Array of ids

Question

I'm using Eloquent ORM laravel 5.1, and I want to return an array of ids greater than 0, my model is called test.

I have tried :

$test=test::select('id')->where('id' ,'>' ,0)->get()->toarray();

It returns :

Array ( [0] => Array ( [id] => 1 ) [1] => Array ( [id] => 2 ) )

But I want the result to be in simple array like this:

Array ( 1,2 )

score 278 · Accepted Answer · edited Jan 06 '23 at 11:45

278

test::where('id' ,'>' ,0)->pluck('id')->toArray();

NOTE: If you need a string, for example in a blade, you can use function without the toArray() part, like:

test::where('id' ,'>' ,0)->pluck('id');

UPDATE: For versions < 5.2

You could use lists() :

test::where('id' ,'>' ,0)->lists('id')->toArray();

NOTE : Better if you define your models in Studly Case format, e.g Test.

You could also use get() :

test::where('id' ,'>' ,0)->get('id');

edited Jan 06 '23 at 11:45

Gediminas Šukys

7,101
7
46
59

answered Dec 16 '15 at 09:31

Zakaria Acharki

66,747
15
75
101

3

with pluck('id') array is array('0'=>12, '1'=>14) and etc, when used in WhereIn('id', $array), it selects not by id, but by array key, so by 0,1... – Gediminas Šukys Jul 16 '18 at 09:02
3

`toArray()` should return an array like `[12,14]` – Zakaria Acharki Jul 16 '18 at 09:06
1

oh yes, you are right, I was debugging via Debugbar ant print_r, and both of them showed array values with keys, but there are no keys. Thank you! – Gediminas Šukys Jul 16 '18 at 11:19
We're stuck on 4.2 for one project, so I appreciate keeping the ->lists('id') reference. Although that generated an array directly, didn't need to ->toArray it. – Dustin Graham Jan 30 '20 at 17:55

George · Answer 2 · 2019-05-24T11:41:46.673

34

From a Collection, another way you could do it would be:

$collection->pluck('id')->toArray()

This will return an indexed array, perfectly usable by laravel in a whereIn() query, for instance.

edited May 24 '19 at 11:41

answered Oct 29 '18 at 11:44

George

6,886
3
44
56

2

Used for Drop Down list as well. – Bira Feb 12 '19 at 01:34
To get the collection to pluck from from model `\YourModel::all(['id'])` ... `->pluck...` (with specifying just the ID column you don't load all data to model) – jave.web May 21 '19 at 10:58

score 7 · Answer 3 · answered May 29 '17 at 16:59

7

The correct answer to that is the method lists, it's very simple like this:

$test=test::select('id')->where('id' ,'>' ,0)->lists('id');

Regards!

answered May 29 '17 at 16:59

Radames E. Hernandez

4,235
27
37

How would you get the related id's list in array through a many to many relationship?? – Pathros Jan 30 '18 at 17:09
Maybe you can use DB class, example: DB::table('name_of_table')->where('condition')->lists('id'); – Radames E. Hernandez Feb 06 '18 at 15:20

score 6 · Answer 4 · edited Jul 27 '19 at 14:46

6

You can use all() method instead of toArray() method (see more: laravel documentation):

test::where('id' ,'>' ,0)->pluck('id')->all(); //returns array

If you need a string, you can use without toArray() attachment:

test::where('id' ,'>' ,0)->pluck('id'); //returns string

edited Jul 27 '19 at 14:46

Rabbid76

202,892
27
131
174

answered Jul 27 '19 at 14:12

Mehmet Bütün

749
9
19

score 6 · Answer 5 · answered Nov 26 '19 at 10:39

6

Just an extra info, if you are using DB:

DB::table('test')->where('id', '>', 0)->pluck('id')->toArray();

And if using Eloquent model:

test::where('id', '>', 0)->lists('id')->toArray();

answered Nov 26 '19 at 10:39

Mahmoud Abdelsattar

1,299
1
15
31

Orici · Answer 6 · 2021-12-06T19:36:00.150

6

A simple way to get an array with the model IDs from a collection:

$test = test::select('id')->where('id' ,'>' ,0)->get('id')->modelKeys();

Available since Laravel 5.5: https://laravel.com/api/5.5/Illuminate/Database/Eloquent/Collection.html#method_modelKeys

edited Dec 06 '21 at 19:36

answered Jul 08 '21 at 14:37

Orici

411
6
12

2

As for Laravel 8: `... ->get()->modelKeys()` – Pathros Nov 05 '21 at 01:19
->get('id')->modelKeys(); - no need, it's enough ->->get()->model Keys(); – Heretic Sic Dec 03 '21 at 07:47

Amir Bar · Answer 7 · 2015-12-16T09:32:13.650

5

read about the lists() method

$test=test::select('id')->where('id' ,'>' ,0)->lists('id')->toArray()

edited Dec 16 '15 at 09:32

answered Dec 16 '15 at 09:25

Amir Bar

3,007
2
29
47

when I use in_array_command in blade file show this error. >in_array() expects parameter 2 to be array, object given – paranoid Dec 16 '15 at 09:29
oh now I get you, you need to call toArray(), lists() return collection – Amir Bar Dec 16 '15 at 09:32

score 2 · Answer 8 · answered Jan 06 '20 at 06:40

2

Although you have marked the Answer, This is a much simpler approach

App\User::pluck('id')->toArray()

answered Jan 06 '20 at 06:40

aslamdoctor

3,753
11
53
95

score 1 · Answer 9 · answered Jul 01 '22 at 21:59

1

In Laravel 8 this works for me

$arr = SomeModel::where("field", value)->get()->toArray();

answered Jul 01 '22 at 21:59

EduAvila

11
1

Eloquent ORM laravel 5 Get Array of ids

9 Answers9

Linked