Laravel 5.4 get only 2 column data from db as array key and value

Question

db column screenshot

I want to fetch only two columns data from table 1st column data as array key and another column data as array value.

as array['wid'=>'temp']

result should be array['1'=>'1.5','2'=>'11.50']

for laravel 5.4

Rwd · Accepted Answer · 2018-06-23 21:47:28Z

1

You could use the pluck() method (scroll down to the Retrieving A List Of Column Values) e.g.

$data = DB::table('city_list')->pluck('city_name', 'cid');

answered Jun 23, 2018 at 21:47

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

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

Comments

KaziBablu · Accepted Answer · 2018-06-26 11:16:21Z

1

Use Collection pluck() The pluck method retrieves all of the values for a given key:

$data = DB::table('city_list')->pluck('city_name','cid');

For more information visit laravel doc here

answered Jun 26, 2018 at 11:16

KaziBablu

5432 gold badges6 silver badges18 bronze badges

Comments

Rwd · Accepted Answer · 2019-05-02 21:12:33Z

0

This worked for me.

$data = DB::table('city_list')->select('cid','city_name')->get(); 
$val = array();

foreach ($data as $key => $value) { 
    $val[$value->cid]=$value->city_name; 
}

edited May 2, 2019 at 21:12

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

answered Jul 4, 2018 at 13:18

Khagesh

1911 silver badge11 bronze badges

Collectives™ on Stack Overflow

Laravel 5.4 get only 2 column data from db as array key and value

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related