/*--------------------按条件查询-------------------------------*/ $ConditionsArray = array("$changhe", "$price", "$leixing", "$pingzhong", "$country" ); $SearchSQLArray = array(" WHERE INSTR(keywords,'".$changhe."')>0", " WHERE INSTR(keywords,'".$price."')>0", " WHERE INSTR(keywords,'".$leixing."')>0", " WHERE INSTR(keywords,'".$pingzhong."')>0", " WHERE INSTR(keywords,'".$country."')>0" ); for($i = 0; $i < count($ConditionsArray); ++$i) { if(fnmatch("请选择",$ConditionsArray[$i])) { $SearchSQLArray[$i] = ""; } if($ConditionsArray[$i] == "" ) { $SearchSQLArray[$i] = ""; } $haveWhere=false; for($j = 0; $j < $i; $j++) { $wherePosition = strpos($SearchSQLArray[$j],"WHERE"); if(($wherePosition == "1") && ($haveWhere == false)) { $SearchSQLArray[$i] = @ereg_replace("WHERE", "AND", $SearchSQLArray[$i]); $haveWhere = true; } } } for($i=0; $i < count($ConditionsArray); ++$i) { $search_SQL=$search_SQL.$SearchSQLArray[$i]; } $search_SQL = "SELECT * FROM zl_goods ".$search_SQL.";"; $search = $db->getAll($search_SQL); $smarty->assign('search', $search); /*--------------------按条件查询结束-------------------------------*/