tp3 and or复合查询

发表于 | 更新于: | 分类于 | 
1
2
3
4
5
6
$where['did'] = $did;
$where['doctor_id'] = $doctor_id;
$where['_logic'] = 'or';
$map['_complex'] = $where;
$map['mcn_id'] = $mcn_id;
$doctorMcn = M("doctor_mcn")->where($map)->find();
1
2
echo M()->_sql();
select * from doctor_mcn where (did=1 or doctor_id=1) and mcn_id=8
坚持原创技术分享，您的支持将鼓励我继续创作！