thinkphp-复合查询

个人博客地址https://xgs888.top/post/view?id=48

总结一下查 where查询

实现数组查询相同字段多次查询例如 status ！=0 and status !=4;

$where['status'] = array(array('neq',0),array('neq',4));

默认是and 如果是or 第三个参数加or

$where['status'] = array(array('neq',0),array('neq',4),'OR');

多个条件里既有AND又有OR的数组查询？例如 where (type = 1 and status =0) and ( updateat>'2017-05-06' or status = 1);

$where['updateat'] = array('GT',"2017-05-06");
$where['status'] = '1';
$where['_logic'] = 'or';
$map['_complex'] = $where;
$map['type'] = 1;
$map['status '] = 0;

M('table')->where($map)->selelct();