语法::参数（）必须是类型阵列

Question

我得到这个错误

参数1传递给照亮\数据库\语法::参数化（的）必须是类型的阵列，串给出的，

当我尝试添加array[]在我查看使用选择窗体。但是，当我删除它，我没有得到任何错误。我只是想在我的选择列表中输入一个多个值。我需要使用foreach吗？

查看

<div class = "form-group {{ $errors->has('approver') ? ' has-error' : '' }}"> 

    <label for = "approver" class = "control-label">Approver:</label> 

    <select name = "approver[]" multiple class = "form-control select2-multi"> 

     @foreach ($approver as $list) 
      <option value = "{{ $list->id }}">{{ $list->username }}</option> 
     @endforeach 

    </select> 

    @if ($errors->has('approver')) 
     <span class = "help-block">{{ $errors->first('approver') }}</span> 
    @endif 

</div> 

控制器

public function getDocuments() 
{ 
    $approver = DB::table('users')->where('id', '!=', Auth::id())->get(); 

    return view ('document.create')->with('approver', $approver); 
} 

public function postDocuments(Request $request) 
{ 

    $this->validate($request, 
    [ 
     'title' => 'required|regex:/(^[A-Za-z0-9 ]+$)+/|max:255', 
     'content' => 'required', 
     'category' => 'required', 
     'recipient' => 'required', 
     'approver' => 'required', 
    ]);  


    $document = new Document(); 
    $approve = new Approve(); 
    $user = Auth::user(); 
           //Request in the form 
    $document->title = $request->title; 
    $document->content = $request->content; 
    $document->category_id = $request->category; 
    $approve->approver_id = $request->approver; 

    $approve->save(); 

    $document->save(); 

    $document->sentToApprovers()->sync([$approve->id],false); 

} 

更新

我死并转储$approver变量和给出的值的数组。

也死不了并转储$request正如你可以在这里看到我输入的和我在选择列表中的ID。

Answer 1

好吧，你的问题是，你要保存的数组，你需要遍历的审批，而不是一个奇异值。

各地更改您的控制器逻辑是：

foreach ($request->approver as $approver) { 
    $approve    = new Approve(); 
    $approve->approver_id = $approver; 
    $approve->save(); 

    $document->sentToApprovers()->sync([$approve->id],false); 
}