我在我的项目中使用 Laravel 5.3,我正在尝试获取多列并在视图中的下拉选择元素中显示数据。我正在像这样进行查询:
$users = User::select(
DB::raw("CONCAT(first_name,' ', last_name) AS full_name, id")
)->lists('full_name', 'id')->toArray();
但这是我从中得到的数据:
array:6 [▼
14 => " "
15 => " "
16 => " "
17 => " "
19 => " "
22 => " "
]
这些值对于full_name
为空,我该如何解决?
尽量避免使用 full_name
关键字,例如:
User::select('id', DB::raw("CONCAT(first_name, ' ', last_name) as full"))
->lists('full','id')
->toArray();