how to get collection results as array with ids

Question

it should be simple but I am missing something, lets say this simple eloquent:

Post::select('id')->take(5)->get();

I want to get simple array with the results id's so it will look like this:

[1,2,3,4,5]

but i am getting something like this:

[{"id":"1"},{"id":"2"},{"id":"3"},{"id":"4"},{"id":"5"}]

flatten() not working and I am getting the same results:

Post::select('id')->take(5)->get()->flatten();

http://laravel.com/docs/master/collections#method-flatten

The flatten method flattens a multi-dimensional collection into a single dimension:

what i am missing? I remember there is a short line laravel way of getting this results without iterate through the array and create a new one

Amir Bar · Accepted Answer · 2016-01-13 20:39:44Z

5

just got it, its the lists() that do the magic so the answer is:

Post::select('id')->take(5)->lists('id');

Update: as of laravel 5.2 lists() become deprecated

The lists method on the Collection, query builder and Eloquent query builder objects has been renamed to pluck. The method signature remains the same.

the new method name is pluck which work the same:

Post::select('id')->take(5)->pluck('id');

edited Jan 13, 2016 at 20:39

answered Nov 5, 2015 at 17:49

Amir Bar

3,1253 gold badges34 silver badges50 bronze badges

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

Collectives™ on Stack Overflow

how to get collection results as array with ids

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related