malo tutorijal malo youtube i dobio sam sledece ...
<?php
mysql_connect("localhost", "root", "") or die("Connection Failed");
mysql_select_db("prijava")or die("Connection Failed");
$output = '';
//collect
if(isset($_POST['search'])) {
$searchq = $_POST['search'];
$searchq = preg_replace("#[^0-9a-z]#i","",$searchq);
$query = mysql_query("SELECT * FROM wp_cf7dbplugin_submits WHERE field_value LIKE '%$searchq%'") or die("Connection Failed");
$count = mysql_num_rows($query);
if($count == 0){
$output = 'Nema rezultata!';
}else{
while($row = mysql_fetch_array($query)) {
$fvalue = $row['field_value'];
$id = $row ['field_name'];
$output .= '<div>'.$fvalue.'</div>';
}
}
}
?>
<!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>Search</title>
</head>
<body>
<form action="index.php" method="post">
<input type="text" name="search" placeholder="Pretraga po imenu..."/>
<input type="submit" value="Traži"/>
</form>
<?php
print("$output");
?>
</body>
</html>
kako postavim vise polja za pretragu po svakom polju iz baze, ali tako da mi se svakim sledecim upisom suzava rezultat pretrage?
u prilogu je primer kako treba da funkcionise
[Ovu poruku je menjao ivanpro dana 17.07.2015. u 00:20 GMT+1]
Forma i filter za pretragu
