Laravel Dropdown表格获取表格数据库

Question

I am using laravel 5.4 . I am trying to get data form Department table and data come also the problem there more dropdown menu come also please tell how can i solve this problem. Thanks advance.[

<div class="form-group">
                        {{Form::label('department','Department')}}
     @foreach($department as $value)
      {{Form::select('department',[$value->name], ' ', array('placeholder' => 'Select Department','class'=>'form-control'))}}
     @endforeach

 </div>

</div>

Answer 1

It's not entirely clear what you're after. Your current code seems to output several select boxes, one for each department and my best guess is that you want to output only one select box, with each department as an option in it. You can achieve that by doing something like this (You may have to adapt this code slightly to suit your needs):

The manual approach

<div class="form-group">
    <label for="department">Department</label>
    <select id="department" name="department" class="form-control">
        <option value="">Select Department</option>
        @foreach ($departments as $department)
            <option value="{{ $department->id }}">{{ $department->name }}</option>
        @endforeach
    </select>
</div>

Using Laravel Collective's Form Builder

<div class="form-group">
    {!! Form::label('department', 'Department') !!}
    {!! Form::select('department', ['' => 'Select Department'] + $departments->pluck'name', 'id')) !!}
</div>