how to get two columns value in laravel where first is key and 2nd is value?

Question

I have 2 columns id = [10 , 22 , 31]; and loction_url = [123.456 , 654.325 , 632,983]; i want data into a single array like this $a = [10 => 123.456 , 22 => 654.325 , 31 => 632,983];

here is my query which only gets columns

$customers = Customer::whereIn('created_by', $adminot)->select(array('id' , 'location_url'))->get();

Does this answer your question? PHP - Merge two arrays (same-length) into one associative? — Remy
– Remy, Commented Dec 30, 2020 at 12:42

Dan · Accepted Answer · 2020-12-30 12:41:28Z

6

This is what Collection::pluck is for:

$customers = Customer::whereIn('created_by', $adminot)
    ->select(array('id' , 'location_url'))
    ->get()
    ->pluck('location_url', 'id');

It'll return an associative array where the key is the value of id and it's respective value is the value of location_url.

answered Dec 30, 2020 at 12:41

Dan

5,3782 gold badges21 silver badges34 bronze badges

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

Comments

Nathan · Accepted Answer · 2020-12-30 12:43:31Z

0

you can use array_merge like

$a = array_merge($id,$loction_url)

answered Dec 30, 2020 at 12:43

Nathan

12 bronze badges

Collectives™ on Stack Overflow

how to get two columns value in laravel where first is key and 2nd is value?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related