多条件复合搜索的实现
$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
时不我待,不负韶华!立刻行动!不吃学习的苦就会吃生活的苦!