1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
|
function affiche_search($_POST)
{
if($_POST['recherche'])
{
foreach($_POST as $key=>$val)
{
${$key} = $val;
if(!is_array(${$key}))
{
${$key} = protectsql(${$key}, ENT_QUOTES);
}
else
{
echo "Un problème est survenu.";
exit;
}
}
if (empty($idmarque) && empty($idmodele))
exit;
$sql = sql_vehicules();
$sql .= "WHERE 1 = 1";
if($idmarque)
$sql .= " AND vehicules.idmarque = '".$idmarque."'";
if($idmodele)
$sql .= " AND vehicules.idmodele = '".$idmodele."'";
$req = mysql_query($sql);# or die('Erreur SQL !<br>'.$sql11.'<br>'.mysql_error());
while ($e = mysql_fetch_assoc ($req))
{
echo $e['nom'] .'<br />';
}
}
} |