Popular select with database values

Question

I need a select in the form with values from another table. Type:

<select>
   <option value="29">Frentista</option>
</select>

I wrote my select like this:

{{ Form::select('set_id_fk', $setores, null, ['class'=>'form-control input-lg']) }}

But in the view is getting like this:

{"set_id": 29, "set_nome": "Frentista"}

I’m using the "laravelcollective/html": "^5.3.0" in my project.

Can someone help me?

Answer 1

If you have a table with unique types and identifiers becomes easy, assuming I have the following table:

id descricao
1   Álcool
2   Gasolina
3   Disel

and from this have my model created, assuming the model name Tipocombustible, to assemble the array of items just use the Pluck method as follows:

$arrayTipoCombustivel = App\Models\TipoCombustivel::pluck('descricao', 'id');

in this way, I would have the $arrayTipoCombustible like this

[
 '1' => 'Álcool',
 '2' => 'Gasolina',
 '3' => 'Disel'
]

I hope I’ve helped!

Answer 2

When Voce recover the data try to turn it into a list as follows:

$associados = Associado::all()->lists('associado','id');

The list transforms the result into an array with KEY and Value, the first parameter is what you want to appear in Select, and the key will be the value of within select.

How does it look:

<option value="id">associado</option>