MySQL търсачка

form.php

Код:
<head>
</head>
<form action="search.php" method="GET">
<table cellspacing=0 cellpadding=0 border=0 width="300">
<tr>
<td align="right" width="200">
<input type="text" name="search" size="30">
</td>
<td align="right" width="100">
<input type="submit" value="Търси!">
</td>
</tr>
</table>
</form>

search.php

Код:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
</head>
<?php

$tarsene = $_GET['search'];

if(empty($tarsene)
{
echo "Моля, въведете дума";
}

$connect = mysql_connect("localhost", "root", "") or die("Няма връзка с база данни");
$db = mysql_select_db(users) or die("Не може да избере база данни");
$result = mysql_query("SELECT * FROM text WHERE ime LIKE '%$tarsene%'") or die("Could not query");
$rows = mysql_num_rows($result);

echo "Намерени резултати за:<i><b> $tarsene</i></b>";
echo "<br/>";
while($row = mysql_fetch_array($result))
{
$ime = $row['ime'];
echo "<b>$ime</b><br/>";
}

?>

ето и демо :

http://87.252.174.185/search/form.php
 

Back
Горе