tp5中多条件模糊查询

等于：$map["id"]  = array("eq",100);

不等于：$map["id"]  = array("neq",100);

大于 ：$map["id"]=array("gt",100);

大于等于：$map["id"]=array("egt",100);

小于：$map["id"]=array("lt",100);

小于等于：$map["id"]=array("elt",100);

模糊查询：$map["name"]=array("like","thinkphp%");

between:

             $map["id"]=array("between","1,8");

             $map["id"]=array("between",array(‘1’，‘8’）)；

in:  $map["id"]=array("id","1,2,,3");

      $map["id"]=array("not in","1,2,3");

$data=db("user")->where($map)->select();

更多参考：http://www.thinkphp.cn/document/314.html

多条件查询：

视图：

控制器：