多个字段关键字查询

 1 //    关键字查询
 2     if(!empty($param['keyword'])){
 3         $tags= Db::table('ce_deal_record')
 4             ->where('roll_name','like','%'.$param['keyword'].'%')
 5             ->whereOr('roll_user','like','%'.$param['keyword'].'%')
 6             ->whereOr('receive_name','like','%'.$param['keyword'].'%')
 7             ->whereOr('receive_user','like','%'.$param['keyword'].'%')
 8             ->whereOr('remark','like','%'.$param['keyword'].'%')
 9             ->select();
10     }

 

转载于:https://www.cnblogs.com/luojie-/p/7542151.html