CODEWITHSUNDEEP
phpmysqllaravel
Hamza Qureshi
Hamza Qureshi

Reputation: 202

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

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();

Upvotes: 4

Views: 2514

Answers (2)

Nathan
Nathan

Reputation: 1

you can use array_merge like

$a = array_merge($id,$loction_url)

Upvotes: 0

Dan
Dan

Reputation: 5358

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.

Upvotes: 6

Related Questions