i have this html code :
Code: Select all
<label for="manufacturer"><strong>manufacturer:</strong></label>
<select id="manufacturer">
<option selected="selected">All</option>
<option value="option1">BF Goodrich</option>
<option value="option2">Continental</option>
<option value="option3">Michelin</option>
<option value="option4">Pirelli</option>
</select>
</li>
<li>
<label for="model"><strong>tyretype:</strong></label>
<select id="model">
<option selected="selected">All</option>
<option value="option1">Summer tyre</option>
<option value="option2">winter tyre</option>
<option value="option3">winter tyre 2</option>
</select>
</li>
<li class="select-two">
<div>
<label for="min-price"><strong>width:</strong></label>
<select id="min-price">
<option selected="selected">All</option>
<option value="option1">145</option>
<option value="option2">150</option>
<option value="option3">155</option>
<option value="option3">160</option>
</select>
</div>
<div>
<label for="max-price"><strong>Profil:</strong></label>
<select id="max-price">
<option selected="selected">All</option>
<option value="option1">30</option>
<option value="option2">35</option>
<option value="option3">40</option>
<option value="option3">45</option
</select>
</div>
</li>
<li class="select-two">
<div>
<label for="min-price"><strong>Diameter:</strong></label>
<select id="min-price">
<option selected="selected">All</option>
<option value="option1">13"</option>
<option value="option2">14"</option>
<option value="option3">15"</option>
<option value="option3">16"</option>
<option value="option3">17"</option>
<option value="option3">18"</option>
<option value="option3">19"</option>
</select>
</div>
<div>
<label for="max-price"><strong>Maximum load:</strong></label>
<select id="max-price">
<option selected="selected">All</option>
<option value="option1">75</option>
<option value="option2">76</option>
<option value="option3">77</option>
<option value="option3">78</option>
<option value="option3">79</option>
<option value="option3">80</option>
<option value="option3">81</option>
<option value="option3">82</option>
<option value="option3">83</option>
<option value="option3">84</option>
</select>
</div>
</li>
<li>
<label for="engine"><strong>Maximum speed:</strong></label>
<select id="engine">
<option selected="selected">All</option>
<option value="option1">Q = max 160 km/h</option>
<option value="option2">R = max 170 km/h</option>
<option value="option3">S = max 180 km/h</option>
<option value="option3">T = max 190 km/h</option>
<option value="option3">H = max 210 km/h</option>
</select>
</li>
anyway back in mysql database i have the following structure:
Code: Select all
a table called tyre which has the following coloumns
name
manufacturer
width
profil
diameter
load
speed
price
Code: Select all
$manufacturer = $_POST['manufacturer'];
$type = $_POST['type'];
$width = $_POST['width'];
$profil = $_POST['profil'];
$diameter = $_POST['diameter'];
$load = $_POST['load'];
$speed = $_POST['speed'];
$sql = array();
if (!empty($manufacturer)) {
$sql[] = "Manufacturer='$manufacturer'";
}
if (!empty($type)) {
$sql[] = "type='$type'";
}
if (!empty($width)) {
$sql[] = "width='$width'";
}
if (!empty($profil)) {
$sql[] = "profil='$profil'";
}
if (!empty($diameter)) {
$sql[] = "diameter='$diameter'";
}
if (!empty($load)) {
$sql[] = "load='$load'";
}
if (!empty($speed)) {
$sql[] = "speed='$speed'";
}
$sql = implode(' AND ', $sql);
$sql = "SELECT * FROM tyre" . (!empty($sql)? " WHERE " . $sql: '');