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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160
|
$menu_query = "SELECT distinct marque FROM voiture ORDER BY marque" ;
$result = mysql_query( $menu_query ,$connexion ) or exit("Erreur dans la requête!");
while( $ligne=mysql_fetch_object($result) )
{
$menu_marque[] = $ligne->marque ;
}
$marq=$_GET['sel_marque'];
$cat=$_get['sel_cat'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html" charset="utf-8" />
<title>Document sans titre</title>
<style type="text/css">
<!--
.button {
background: #c7ab1c;
background: -webkit-gradient(linear, left top, left bottom, from(#c70a0a), to(#c7ab1c));
background: -webkit-linear-gradient(top, #c70a0a, #c7ab1c);
background: -moz-linear-gradient(top, #c70a0a, #c7ab1c);
padding: 4.5px 9px;
-webkit-border-radius: 0px;
-moz-border-radius: 0px;
border-radius: 0px;
-webkit-box-shadow: rgba(0,0,0,1) 0 1px 0;
-moz-box-shadow: rgba(0,0,0,1) 0 1px 0;
box-shadow: rgba(0,0,0,1) 0 1px 0;
text-shadow: rgba(0,0,0,.4) 0 1px 0;
color: #003;
font-size: 13px;
font-family: Georgia, serif;
text-decoration: none;
vertical-align: middle;
background-color: #C00;
background-position: top;
border: 1px inset #FC0;
}
.button:hover {
border-top-color: #0a033b;
background: #0a033b;
color: #e8f718;
}
.button:active {
border-top-color: #091f2e;
background: #091f2e;
}
-->
</style>
</head>
<body>
<form name = "recherche" method="get" action="recherche.php" target="résultat" align="right">
<div align="center">
<table width="90%" border="0">
<tr>
<td><div align="center"><font size="-1"><strong><em><strong><font color="#FF0000" size="-1">RECHERCHE PERSONNALISEE</font></strong></em></strong></font></div></td>
</tr>
<tr>
<td> <center></font> <font size="-1"><strong><em> Marque :</em></strong></font><font color="#FFCC33">
<select name="sel_marque">
<option value=""><font size="-1">-CHOISISSEZ-</font></option>
<?php
foreach($menu_marque as $valeur)
{echo "<option value=\"$valeur\">$valeur</option>";}
?>
</select></font></center></td>
</tr>
<tr>
<td>
<?
$menu_query = "SELECT distinct categorie FROM voiture where marque='.$marq.' ORDER BY categorie" ;
$result = mysql_query( $menu_query ,$connexion ) or exit("Erreur dans la requête!");
while( $ligne=mysql_fetch_object($result) )
{
$menu_categorie[] = $ligne->categorie ;
}
?>
<div align="center">
<font size="-1"><strong><em> Catégorie :</em></strong></font><font color="#FFCC33">
<select name="sel_cab">
<?php
foreach($menu_categorie as $valeur)
{echo "<option value=\"$valeur\">$valeur</option>";}
?>
</select></div></td>
</tr>
<tr>
<td>
<?
$menu_query = "SELECT distinct carburant FROM voiture where marque='.$carb.' and categorie='$cat' ORDER BY carburant" ;
$result = mysql_query( $menu_query ,$connexion ) or exit("Erreur dans la requête!");
while( $ligne=mysql_fetch_object($result) )
{
$menu_carburant[] = $ligne->carburant ;
}
?>
<div align="center">
<font size="-1"><strong><em> Carburant :</em></strong></font><font color="#FFCC33">
<select name="sel_cab">
<?php
foreach($menu_carburant as $valeur)
{echo "<option value=\"$valeur\">$valeur</option>";}
?>
</select></font>
</div></td>
</tr>
<tr>
<td><div align="center">
<font color="#FFFFFF">
<label><font color="#000000" size="-1"><strong>Budget entre</strong> </font><font size="-1">
<input name="sel_min" type="text" size="5" />
</font> </label>
<font color="#000000">- </font>
<input name="sel_max" type="text" size="5" />
<font color="#000000"><strong>€</strong></font></font></div></td>
</tr>
<tr>
<td><div align="center"> <p><font size="-1"><strong><em>Classé par :</em></strong></font>
<font size="-1">Prix</font>
<input name="sel_tri" type="radio" value="prix" checked="checked" />
<font size="-1">Modèle</font>
<input name="sel_tri" type="radio" value="modele" />
<font size="-1">Km</font>
<input name="sel_tri" type="radio" value="kilometre" />
</div></td>
</tr>
<tr>
<td> <div align="center">
<p><font color="#FFFFFF">
<input type="submit" class="button" name="Submit1" value="Rechercher" action="rech.php" />
</font></p>
<p><font size="3" face="Comic Sans MS"><a href="admin/index.php" TARGET="popup" onClick="window.open('','popup', 'height=600, top=200, left=200, toolbar=no, menubar=no, location=no, resizable=no, scrollbars=no, status=no')"><img src="Sans titre.gif" height="16px" width="16px"border="0" alt="" align="center" /></a></font></p>
</div></td>
</tr>
</table>
</form>
</body>
</html> |
Partager