Primer za Ajax pretragu:
forma za pretragu (npr. proizvodi.php):
Code:<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="sr" lang="sr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
<script type="text/javascript">
function pretraga_polja() {
r = document.getElementById("racunari").value; //racunari
c1 = document.getElementById("c1").value; //Cena od
c2 = document.getElementById("c2").value; //Cena do
r1 = document.getElementById("r1").value; //RAM od
r2 = document.getElementById("r2").value; //RAM do
hdd = document.getElementById("hdd").value; //HDD
//Provera 3 čekiranih polja
if (document.getElementById("opcija1").checked == true) o1 = 1; else o1=0;
if (document.getElementById("opcija2").checked == true) o2 = 1; else o2=0;
if (document.getElementById("opcija3").checked == true) o3 = 1; else o3=0;
$("#rezultati").html("Učitavam...");
$.ajax({
type: "POST",
url: "pretraga.php?racunari="+r+"&c1="+c1+"&c2="+c2+"&r1="+r1+"&r2="+r2+"&hdd="+hdd+"&o1="+o1+"&o2="+o2+"&o3="+o3,
data: "status=1",
success: function(msg){
$("#rezultati").html(msg);
$("#rezultati").css("display","none");
$("#rezultati").slideDown(400);
},
error: function(msg){
$("#rezultati").html(msg);
}
});
}
</script>
</head>
<body>
<form name="moja_forma" action="" method="post">
<table>
<tr>
<td>Proizvodjac</td>
</tr>
<tr>
<td><select id="racunari" name="racunari">
<option value="">Izaberite proizvodjaca</option>
<option value="acer">Acer</option>
<option value="dell">Dell</option>
<option value="hp">HP</option>
</select>
</td>
</tr>
<tr>
<td>Cena</td>
</tr>
<tr>
<td>od <input id="c1" type="text" size="3" maxlength="5" name="cena1"> do <input id="c2" type="text" size="3" maxlength="5" name="cena2"></td>
</tr>
<tr>
<td>Kolicina RAM-a</td>
</tr>
<tr>
<td>od <input id="r1" type="text" size="3" maxlength="5" name="ram1"> do <input id="r2" type="text" size="3" maxlength="5" name="ram2"></td>
</tr>
<tr>
<td>Velicina HDD</td>
</tr>
<tr>
<td><input id="hdd" type="text" size="15" maxlength="15" name="godina" value=""></td>
</tr>
<tr>
<td>Graficka</td>
</tr>
<tr>
<td>
Integrisana<input id="opcija1" type="checkbox" value="integrisana" name="graficka"> |
Neintegrisana<input id="opcija2" type="checkbox" value="neintegrisana" name="graficka"> |
Svi<input id="opcija3" type="checkbox" value="svi" name="graficka">
</td>
</tr>
</table>
<input type="button" onclick="pretraga_polja();" value="Submit" />
</form>
<div id="rezultati"></div>
</body>
</html>
pretraga.php
Code:<?php
if (!isset($_REQUEST["racunari"]) AND !isset($_REQUEST["c1"]) AND !isset($_REQUEST["c2"]) AND !isset($_REQUEST["r1"]) AND !isset($_REQUEST["r2"]) AND !isset($_REQUEST["hdd"]) AND !isset($_REQUEST["o1"]) AND !isset($_REQUEST["o2"]) AND !isset($_REQUEST["o3"])) {
echo "Greška prilikom pretrage";
die;
} else {
$racunari = $_REQUEST["racunari"];
$cena1 = $_REQUEST["c1"]; $cena2 = $_REQUEST["c2"];
$ram1 = $_REQUEST["r1"]; $ram2 = $_REQUEST["r2"];
$hdd = $_REQUEST["hdd"];
$integrisana = $_REQUEST["o1"];
$neintegrisana = $_REQUEST["o2"];
$svi = $_REQUEST["o3"];
?>
<div style="background-color: #ccc; color: #000; padding: 6px;" >
<div><b>Pretraga:</b></div>
<div> </div>
<div>Proizvođač: <?php echo $racunari;?></div>
<div>Cena: <?php echo $cena1; ?> - <?php echo $cena2; ?></div>
<div>RAM: <?php echo $ram1; ?> - <?php echo $ram2; ?></div>
<div>HDD: <?php echo $hdd; ?></div>
<div>Integrisana: <?php echo $integrisana; ?> Neintegrisana: <?php echo $neintegrisana; ?> Svi: <?php echo $svi; ?></div>
</div>
<div> </div>
<div style="background-color: #000; color: #FFF; padding: 6px; width: 250px;" >
<div>MySQL upit:</div>
<div> </div>
SELECT * FROM proizvodi <br />WHERE proizvodjac = '<?php echo $racunari;?>'
<br />AND (cena>=<?php echo (int)$cena1;?> AND cena<=<?php echo (int)$cena2; ?>)
<br />AND (ram>=<?php echo (int)$ram1;?> AND ram<=<?php echo (int)$ram2; ?>)
<br />AND hdd>=<?php echo (int)$hdd;?>
<br />AND integrisana = <?php echo (int)$integrisana;?>
<br />AND neintegrisana = <?php echo (int)$neintegrisana;?>
<br />AND svi = <?php echo (int)$svi;?>
</div>
<?php
}
?>
Naravno, potrebno je da izmeniš upit u zavisnosti od dizajna tvoje baze podataka i proveriš sva polja pre upita (da li je u pitanju broj, zaštita od inject...).
I hope I didn't brain my damage - Homer
if (wife.position == kitchen) {return sandwich};
Registrovani: 6 ( Darko Nedeljković, nato_bot, SlobaBgd, fangorn, B3R1, Nebojsa Milanovic )
Pretraga na sajtu
Re: Pretraga na sajtu