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();