laravel打印执行的sql语句 Laravel 的 where or 查询
发布时间：2021-05-10, 04:34:03 分类：PHP | 编辑 off 网址 | 辅助
正文 297字数 505,854阅读
Laravel 打印SQL语句
DB::connection()->enableQueryLog();#开启执行日志
$a = self::where(['investorid'=>$id])->whereBetween('inserttime',[$start,$end])->where('deposit','>',0)->orderBy('id','asc')->Paginate(20);
print_r(DB::getQueryLog()); //获取查询语句、参数和执行时间Run code
Cut to clipboard
（支付宝）给作者钱财以资鼓励 （微信）→
有过 2 条评论 »
$orWhere = []; if ($params['name']) { $orWhere['name'] = $params['name']; } if ($params['mobile_number']) { $orWhere['mobile_number'] = $params['mobile_number']; } if ($params['email']) { $orWhere['email'] = $params['email']; } if ($params['score']) { $orWhere[] = ['score', '>', 1000, 'OR']; } DB::table('users') ->where('group_id', 'group id') ->where(function ($query) use ($orWhere) { $query->orWhere($orWhere); }) ->get();DB::table('users') ->where('group_id', 'group id') ->where(function ($query) { if ($params['name']) { $query->orWhere('name', $params['name']) } if ($params['mobile_number']) { $query->orWhere('mobile_number', $params['mobile_number']) } if ($params['email']) { $query->orWhere('email', $params['email']) } if ($params['score']) { $query->orWhere('score', '>', $params['score']) } }) ->get();