Някои има ли търсачка за текстове

[spaidur]

някои има ли търсачка за тзи урок http://web-tourist.net/login/login/view.php?st=2210

 

[justspy]

заповядай ..

<?php
// First connect to database
$host = "localhost";
$dbuser = "root";
$dbpass = "";
$db = "";

$con = mysql_connect($host, $dbuser, $dbpass);
if(!$con){
die(mysql_error());
}

$select = mysql_select_db($db, $con);
if(!$select){
die(mysql_error());
}


$item = $_REQUEST['find'];

$data = mysql_query("SELECT * FROM lyrics WHERE izpulnitel LIKE '%$item%' or pesen LIKE '%$item%'");
$id=$_GET['id'];
$zaqvka = mysql_query ("SELECT * from lyrics WHERE id = $id");
while($row = mysql_fetch_array($data)){
echo "<br /><a href=viewtext.php?id=$id".$row['id'].">".$row['izpulnitel']." - ".$row['pesen']."</a>
$row[dobavil]</td>
$row[prochetena]</td>
";

}

?>

 

[DeathGuard_]

Ето ти една примерна... (възможно най-проста..)

<input type="text" accesskey="s" name="search">
<input type="submit" value="Търси" name="button">
<?
$tarsene = $_POST['search'];
$query = " SELECT * FROM lyrics WHERE izpulnitel LIKE '%$tarsene%' OR pesen LIKE '%$tarsene%' order by id DESC";
$result = mysql_query($query) or die(mysql_error());
if ($_POST['button']){
while($row=mysql_fetch_array($result)){
echo "$row['izpulnitel']-$row['pesen']";
}
}
?>

 

[spaidur]

нестават