Convert eloquent result to associative array in Laravel

Question

How can convert the result from eloquent to associative array. I need to select tow column and have one as key and another as value. Here is the closet I got, however the value is an array. I want it to be only "my_value" column.

$array = Post::select('my_key','my_value')->get()->keyBy('my_key')

What results do you get with this code? And what do you expect to get? Give some examples. — Laerte
– Laerte, Commented Apr 27, 2017 at 19:06
I was looking for array:2 [▼ "key1" => "value1" "key2" => "value2" ] — Mehdi
– Mehdi, Commented Apr 28, 2017 at 2:57
The above approach after converting toArray was giving me: array:2 [▼ "key1" => array:2 [▼ "my_key" => "key1" "my_value" => "value1" ] "key2" => array:2 [▼ "my_key" => "key2" "my_value" => "value2" ] ] — Mehdi
– Mehdi, Commented Apr 28, 2017 at 3:03

Laerte · Accepted Answer · 2017-04-28 12:59:59Z

25

You should use lists (Laravel 5.1) or pluck (Laravel 5.2+):

$array = Post::lists('my_value', 'my_key');

or

$array = Post::pluck('my_value', 'my_key');

edited Apr 28, 2017 at 12:59

answered Apr 28, 2017 at 12:29

Laerte

7,0833 gold badges35 silver badges52 bronze badges

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

3 Comments

Mehdi Over a year ago

Thanks, looks like lists have been renamed to plunk, I just modified it a bit $array = Post::plunk('my_value', 'my_key')->toArray();

Flipper Over a year ago

Just wanted to point out for any future people: @Mehdi's answer is a typo. It is "pluck" not "plunk".

jovialcore Over a year ago

@Mehdi pluck not plunk

Mehdi · Accepted Answer · 2017-04-28 02:54:43Z

6

I found a way to do so, I'm not sure whether it's proper way to do this performance wise though...

$array = Post::select('my_key','my_value')->get()->mapWithKeys(function ($item) {
            return [$item['my_key'] => $item['my_value']];
        })->toArray();

answered Apr 28, 2017 at 2:54

Mehdi

3831 gold badge4 silver badges15 bronze badges

1 Comment

Bikash Over a year ago

You can just $array = $array ->toArray() to convert object as string. Its buildin method.

Collectives™ on Stack Overflow

Convert eloquent result to associative array in Laravel

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related