- 区间查询:
$map['i.birthday'] = array(array('>=',$week_start),array('<',$week_end),'and');
- 两字段模糊查询:
$where='%'.$where.'%';$map['i.member_name|d.phone'] = array('like',$where);
- 不为空null查询
$data["map"] = ['uid' => $uid,"alipay_appid"=>["not null","EXP"]];
- 普通and查询
$where['name'] = "laodi";$wehre['sex'] = "woman";
- 建议使用框架自带的搜索器进行
搜索条件定义
。