作为程序员一定要保持良好的睡眠,才能好编程

Laravel中first和firstOrNew及firstFail的区别

发布时间:2020-01-30


官方文档:

https://learnku.com/docs/laravel/6.x/eloquent/5176#b438f8


项目中经常会使用到 find 查找数据,有时候需要判断数据是否存在,laravel提供了这样的方式方法:


1、findOrNew


$result = OutPatientOrderModel::getQuery()->with([

    'detail' => function ($query) {

        $query->where('is_deleted', '0')->select('img_des', 'illness_des', 'order_id', 'pkid', 'is_visit');

    }

])->findOrNew($id, $fields)->toArray();


执行结果:

hospital\app\Services\Inquiry\OrderService.php line:49Array

(

)



2、findOrFail


$result = OutPatientOrderModel::getQuery()->with([

    'detail' => function ($query) {

        $query->where('is_deleted', '0')->select('img_des', 'illness_des', 'order_id', 'pkid', 'is_visit');

    }

])->findOrFail($id, $fields)->toArray();


执行结果:

"message": "No query results for model [App\\Models\\Inquiry\\OutPatientOrderModel] 5563908201780521180",



3、find


$result = OutPatientOrderModel::getQuery()->with([

    'detail' => function ($query) {

        $query->where('is_deleted', '0')->select('img_des', 'illness_des', 'order_id', 'pkid', 'is_visit');

    }

])->find($id, $fields)->toArray();


执行结果:

"message": "Call to a member function toArray() on null",



官方文档:

https://learnku.com/docs/laravel/6.x/eloquent/5176#b438f8