选定的值从数据库获取到下拉选择框

Question

我有一个员工表格编辑。我的问题是，我的编辑功能运行良好，但我无法获取员工类型的值。

我有 4 种员工类型：

• 职员

• 导师

• 经理

• 超级用户

每次我去编辑表单时，下拉列表中的员工类型总是在员工上（我想显示，如果员工是“经理”，那么下拉框显示经理）。

这是editroledetails.blade.php的代码

<div class="form-group">

    <label for="editCustomerType">Customer Type</label><br/>

    <select name="editCustomerType">

        <option value="Staff">Staff</option>

        <option value="Supervisor">Supervisor</option>

        <option value="Manager">Manager</option>

        <option value="Super User">Super User</option>

    </select>

</div>

控制器功能

public function editroledetails(Request $request)

{

    $user = \Auth::user();

    $userphone = 0;

    $reportTo = DB::select(DB::raw("select username from customer_type where customer_type = 'Supervisor' or customer_type ='Manager' "));

    $select = DB::select(DB::raw("select customer_type from customer_type "));

    $data = [

        'editUsername' => $request->editUsername,

        'editNik' => $request->editNik,

        'editEmail' => $request->editEmail,

        'editRegIdentities' => $request->editRegIdentities,

        'editReportTo' => $request->editReportTo,

        'editID' => $request->editID

    ];

    return view('editroledetails', compact('user', 'userphone', 'data', 'reportTo', 'select'));

}

Answer 1

你可以这样做：<div class="form-group">&nbsp; &nbsp; &nbsp;<label for="editCustomerType">Customer Type</label><br/>&nbsp; &nbsp; &nbsp;<select name="editCustomerType">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;@if($user->customer_type == 'Staff')&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <option value="Staff">Staff</option>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;@endif&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;@if($user->customer_type == 'Supervisor')&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<option value="Supervisor">Supervisor</option>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;@endif&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;@if($user->customer_type == 'Manager')&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<option value="Manager">Manager</option>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @endif&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @if($user->customer_type == 'Super User')&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<option value="Super User">Super User</option>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @endif&nbsp; &nbsp; &nbsp;</select>&nbsp;</div>

Answer 2

您可以使用它来显示选择列表中的所选项目<?php&nbsp; &nbsp; $customerTypes = [&nbsp; &nbsp; &nbsp; &nbsp; 'Staff' => 'Staff',&nbsp; &nbsp; &nbsp; &nbsp; 'Supervisor' => 'Supervisor',&nbsp; &nbsp; &nbsp; &nbsp; 'Manager' => 'Manager',&nbsp; &nbsp; &nbsp; &nbsp; 'Super User' => 'Super User',&nbsp; &nbsp; ];?><div class="form-group">&nbsp; &nbsp; <label for="editCustomerType">Customer Type</label><br/>&nbsp; &nbsp; <select name="editCustomerType">&nbsp; &nbsp; &nbsp; &nbsp; @foreach($customerTypes as $type)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $selected = "";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @if($user->customer_type == $type) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $selected = "selected";&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <option value="{{ $type }}" {{ $selected }} >{{ $type }}</option>&nbsp; &nbsp; &nbsp; &nbsp; @endforeach&nbsp; &nbsp; </select></div>

Answer 3

selected在选择选项上使用属性<div class="form-group">&nbsp; &nbsp; <label for="editCustomerType">Customer Type</label><br/>&nbsp; &nbsp; <select name="editCustomerType">&nbsp; &nbsp; &nbsp; &nbsp; <option value="Staff" @if($user->customer_type == 'Staff')selected@endIf>Staff</option>&nbsp; &nbsp; &nbsp; &nbsp; <option value="Supervisor" @if($user->customer_type == 'Supervisor')selected@endIf>Supervisor</option>&nbsp; &nbsp; &nbsp; &nbsp; <option value="Manager" @if($user->customer_type == 'Manager')selected@endIf>Manager</option>&nbsp; &nbsp; &nbsp; &nbsp; <option value="Super User" @if($user->customer_type == 'Super User')selected@endIf>Super User</option>&nbsp; &nbsp; </select></div>