这是我的查询
$RecipientList = Employees::select(DB::Raw('CONCAT(first_name," ",last_name) as employee_name'),'email')->pluck('employee_name','email');
哪能给我正确的结果,
但在我执行查询后,我还有1个键=>值对推入结果数组.
如果我打印当前结果,它是这样的.
Illuminate\Support\Collection Object
(
[items:protected] => Array
(
[punit@*****.com] => Punit Gajjar
[milan@*****.com] => Milan Gajjar
[pritesh@*****.com] => Pritesh Modi
[pratik@*****.com] => Pratik Modi
[jyoti@*****.com] => Jyotiranjan J..
)
)
如果我试图将我的Key => valye对推入这个数组,那就不行了.
array_push(array("All"=>"All"),$RecipientList);
需要输出类似的东西
Illuminate\Support\Collection Object
(
[items:protected] => Array
(
[All] => All
[milan@*****.com] => Milan Gajjar
[milan@*****.com] => Milan Gajjar
[pritesh@*****.com] => Pritesh Modi
[pratik@*****.com] => Pratik Modi
[jyoti@*****.com] => Jyotiranjan J..
)
)
解决方法
这是因为$RecipientList是Collection而不是Array.
试试这个
RecipientList = Employees::select(DB::Raw('CONCAT(first_name,'email')->toArray();
如果这不起作用,请尝试以下代码
RecipientList = Employees::select(DB::Raw('CONCAT(first_name,'email')->get()->pluck('employee_name','email')->toArray();
希望这会帮助你.
