php用数组复合查询,thinkphp-复合查询

总结一下查 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();