Laravel:在Select Box上显示STDCLASS对象值

Question

我想从db中显示 username的值。我可以显示仅1个值。但是数据不仅是1，我需要在Select框/下拉下显示。

$staff = DB::select(DB::raw("select username from customer_type where customer_type ='Staff'"));

这是$staff

的print_r

Array
(
    [0] => stdClass Object
        (
            [username] => test
        )
    [1] => stdClass Object
        (
            [username] => jayusman
        )
    [2] => stdClass Object
        (
            [username] => MuhammadFik
        )
    [3] => stdClass Object
        (
            [username] => test2
        )
)

我想在下拉菜单上显示用户名(Test，Jayusman，Muhammadfik，test2(。

Answer 1

您可以使用foreach循环通过实体循环

<select name="somethin">
@foreach($staff as $key => $name)
 <option value="{{$name->username}}">{{$name->username}}</option>
@endforeach
</select>

Answer 2

尝试使用

DB::table('customer_type')
    ->select('customer_id', 'username')
    ->where('customer_type', 'Staff')
    ->pluck('customer_id', 'username')

它将生成一个看起来像这样的数组：

Array (
    [2] => 'User #2',
    [5] => 'User #5',
    [7] => 'User #7',
)

这样，您可以在提交表单时通过其ID识别用户。