tp5tp6thinkphp使用数组where条件方式

1. 区间查询:

   $map['i.birthday'] = array(
                           array('>=',$week_start),
                           array('<',$week_end),
                           'and'
                       );
   

2. 两字段模糊查询:

   $where='%'.$where.'%';
           $map['i.member_name|d.phone'] = array(
               'like',$where
           );
   

3. 不为空null查询

   $data["map"] = ['uid' => $uid,"alipay_appid"=>["not null","EXP"]];
   

4. 普通and查询

   $where['name'] = "laodi";
   $wehre['sex'] = "woman";
   

5. 建议使用框架自带的搜索器进行搜索条件定义。