1.采用闭包方式
tp5中采用闭包的方式:
$map[‘user_id’]=1;
$map[‘status’]=0;
$or_map[‘user_id’]=$map[‘user_id’];
$or_map[‘audit’]=[‘in’,[‘1,2’]];
$list = Db::name(‘table’)->where(function ($query) use ($map) {
$query->where($map);
})->whereOr(function ($query) use ($or_map) {
$query->where($or_map);
})->select();
//生成的sql语句:
//SELECT * FROM tp\_table WHERE ( user\_id = ‘1’ AND status = 0 ) OR ( user\_id = ‘1’ AND audit IN (‘1,2’) )
[Read More]