Form::select Orange

Question

I’m having trouble making one Form:select searching information from the database.

How is the Controller;

public function create() 
{   
    return View('internos.create');
}

How’s the View;

<div class="form-group">
  {{ Form::label('setor', 'Setor: ') }}
  {{ Form::select('setor_id', 
       array(''=>'Selecione...')+ Setor::all()->lists('descricao', 'id'), 
       null, array('class'=>'form-control'))  
  }}
</div>

Answer 1

First, the die has a traffic of Controller for View and vice versa, but never the View generate this information directly, example of modification of your Controller method:

public function create() 
{   
    $setors = Setor::pluck('descricao', 'id')
    $setors[''] = 'Selecione...';
    return View('internos.create', ['setors' => $setors]);
    // ou return View('internos.create', compact('setors'));
}

In his View make the following modifications:

<div class="form-group">
  {{ Form::label('setor', 'Setor: ') }}
  {{ Form::select('setor_id', $setors, null, array('class'=>'form-control')) }}
</div>

that is, in its View only has the variable with the information for your generation and not logic that stays in your Controller.