$data = Program::with('peserta', function ($query) {
return $query->peserta()->whereBetween('tanggal', array($request->from, $request->until));
})->get();
此代碼回傳錯誤:
mb_strpos() 期望引數 1 是字串,給定的物件”,例外:“ErrorException”。
幫助。謝謝
uj5u.com熱心網友回復:
內部的閉包函式with()必須是陣列并洗掉它return。laravel 檔案中的示例
$data = Program::with(['peserta' => function ($query) use($request) {
$query->whereBetween('tanggal', array($request->from, $request->until));
}])->get();
uj5u.com熱心網友回復:
您應該使用 whereHas 為關系設定條件:
$data = Program::whereHas('peserta', function ($query)use($request) {
return $query->whereBetween('tanggal', array($request->from, $request->until));
})->get()
如果您需要有關系資料,則應將“with”添加到查詢中:
$data = Program::whereHas('peserta', function ($query)use($request) {
return $query->whereBetween('tanggal', array($request->from, $request->until))->with('peserta');
})->get()
轉載請註明出處,本文鏈接:https://www.uj5u.com/yidong/380521.html
上一篇:Laravel搜索系統
