多个字段关键字查询 

 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     }

 

posted @ 2017-09-18 11:20  原来是个帅小伙  阅读(508)  评论(0)  编辑  收藏  举报