今天在該別人代碼時(shí)遇到這個(gè)問題藐石，首先在SQL查詢外寫好where()條件递览，然后SQL語(yǔ)句如下执虹。 使用了匿名函數(shù)捕透，用 use 引用匿名函數(shù)的外部變量
SELECT * FROM `ny_information`
WHERE `status` = 1
AND (`username` LIKE '%1111%'
OR `cert_number` LIKE '%1111%'
OR `username` LIKE '%1111%')
ORDER BY input_time desc LIMIT 0,8
$whereOr = ' ';//已經(jīng)給其賦了where條件
$where_1 = ' ';
$where_2 = ' ';
$info = Db::table('ny_information')
->where('status', '=', 1) //where whereOr
//匿名函數(shù)用法
->where(function($query) use ($where_1, $whereOr, $where_2){
$query->where($where_1)
->whereOr($whereOr)
->whereOr($where_2);
})
->order("input_time desc")
->paginate(8,false,['query' => request()->param()]);
