多条件复合搜索的实现

$where = array();
if(!empty($type)){
   $where[] = " `type` = ".$type ;
}
if(!empty($price)){
   $where[] = " `price` = ".$price ;
}
if(!empty($area)){
   $where[] = " `area` = ".$area ;
}
if(!empty($where)){
   $where = implode(' And ',$where);
   $sql = " SELECT * FROM `table` Where ".$where;
}else{
   $sql = "SELECT * FROM `table` "; 
}

当$where数组中只有一个元素时

假定：$where=array('name’);

implode(' and ',$where);//返回的只是字符串name，不带and

转载于:https://www.cnblogs.com/zrp2013/archive/2013/04/11/3015429.html