Layman ThinkPHP 中 where条件 or,and 同时使用

Eg:('a'=1 and 'b'=2) or ('c'=3 and 'd'=4) and 'e'=5

解决方法

$condition1['a'] = 1;
$condition1['b'] = 2;
$condition2['c'] = 3;
$condition2['d'] = 4;
$condition['_complex'] = array(
    $condition1,
    $condition2,
    '_logic' => 'or'
);
$condition['e'] = 5;
D('模型')->where($condition)->select();

 

posted @ 2018-09-19 15:06  AA-Layman  阅读(974)  评论(0编辑  收藏  举报