Laravel 5 - database table for array with predefined index

Question

Is there any way to retrieve the results of a query in the database and transfer it to a Array with one of the table fields being index of Array?

You could achieve this result in two steps. After the query makes a loop and turns into the Array with desired index.

You can check this result in one step?

This is the code that returns me to query:

$lang = DB::table('language')->select('id', 'name')->get();

I wanted to $lang is an array of the type $lang[id=>name].

Answer 1

Try using the function Pluck

$lang = DB::table('language')->select('id', 'name')->pluck('name', 'id')->toArray();