php根据查询条件拼接sql语句

用变量$i,默认等于0是第一次，大于0是多次 ,key和val是一个一维数组 

 if($status){
$where_arr["goods_status="] = $status;
}
if($goods_id){
$where_arr["id="] = $goods_id;
}
if($goods_count == 1){
$where_arr["goods_count="] = 0;
}
if($goods_name){
$where_arr["goods_name like"] = ""%$goods_name%"";
}
if($goods_category){
$where_arr["goods_category="] = $goods_category;
}

  if(count($where_arr) > 0) {

$where = "where ";
$i=0;
foreach ($where_arr as $k=>$val){
  if($i==0) {
$where  .= $k.$val;
}else{
$where  .= " and ".$k.$val;
 }
   $i++;
 }
     }