PLIK SEARCH.php
<?php ?>
Pobranie danych z url:
Formularz:
<form action="SEARCH.php" method="post"> <div> <br /> <span class="dodanodata">Czego szukasz?</span> <input type="text" class="tytul" style="width:250px;" name="szukaj" value="<?php echo $szukaj; ?>" /> <span class="dodanodata">od</span> <input type="text" class="tytul" name="min" value="<?php echo $min; ?>" style="width:50px;" onkeyup="this.value=this.value.replace(/\D/g,'')"/> <span class="dodanodata">do</span> <input type="text" class="tytul" name="max" value="<?php echo $max; ?>" style="width:50px;" onkeyup="this.value=this.value.replace(/\D/g,'')"/> <option name="sort" value="id">id</option> <option name="sort" value="price">cena</option> </select> <input type="submit" class="dodajbtn" value="szukaj" /> </div> </form>
Zapytanie SQL:
$query = mysql_query("SELECT * FROM `item` WHERE `tag` LIKE '%$szukaj%' AND price <= '$max' AND price >= '$min' ORDER BY `$sort` DESC LIMIT $limit,9");