我想使用findOrFail
而不是get()
,但它不起作用。
那么,如果该行不存在,返回404响应的最佳方式是什么呢?
$log = DB::table('dmlog')
->select(
'dmlog.*',
'membership.membership',
'department.department',
'category.category',
'communication.communication',
'room.room AS room',
'room.category AS room_cat',
'roommove.room AS roommove',
'roommove.category AS roommove_cat'
)
->join('membership', 'membership.id', '=', 'id_membership')
->join('department', 'department.id', '=', 'id_department')
->join('category', 'category.id', '=', 'id_category')
->join('communication', 'communication.id', '=', 'id_communication')
->join('room', 'room.id', '=', 'id_room')
->join('room AS roommove', 'roommove.id', '=', 'id_roommove')
->where('dmlog.id', $id)->get(); // <----- HERE
return response()->json($log);
如果$log
为空,您可以在返回行之前添加一行abort_if($log->isEmpty(), 404);
以中止
findOrFail是一个雄辩的方法,而不是DB原始类方法。你需要使用雄辩。
您需要直接参考模型才能使用findOrFail
$model = AppYourModel::findOrFail($id);
https://laravel.com/docs/master/eloquent#retrieving-单一型号