Szabadszavas keresõ
Keresési eredmények:
Kérem írja be a mezõbe, amit szeretne kerestetni!";
exit;
}
// Otherwise we connect to our Database
mysql_connect("localhost", "kartevoi_fa", "9W*2Bi)LgnEd") or die(mysql_error());
mysql_select_db("kartevoi_vendeg") or die(mysql_error());
$k = "SET NAMES LATIN2";
mysql_query($k);
$table = "novenyek";
// We preform a bit of filtering
$find = strtoupper($find);
$find = strip_tags($find);
$find = trim ($find);
//Now we search for our search term, in the field the user specified
$dataa = mysql_query("SELECT * FROM ".$table." WHERE upper($field) LIKE'%$find%'");
//And we display the results
while($resultt = mysql_fetch_array( $dataa ))
{
echo ''.$resultt['nick'].'' ;
echo " ";
echo "
";
echo $resultt['message'];
echo "
";
echo "
";
}
//This counts the number or results - and if there wasn't any it gives them a little message explaining that
$anymatches=mysql_num_rows($dataa);
if ($anymatches == 0)
{
echo "Sajnálom, átnéztem az adatbázist, de nem találtam semmit.
";
}
//And we remind them what they searched for
echo "A megadott kulcsszó: " .$find;
}
?>
![shape'.$result['nick'].'](novenykep/'.$result['email'].'.jpg)
'.$result['nick'].'' ;
echo " ";
echo " ";
echo '/'.$result['latin'].'/';
echo ": ";
echo ""; echo $result['message']; echo "
"; echo "