<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<form action="" method="get">
<input type="text" name="search" value="<?=$_GET[search] ?>"><br>
<input type="submit" value="Търси">
</form>
<?php
if($_GET[search]){
$tarsene = $_GET['search'];
$server = "localhost";
$dbusername = "potrebitel ";
$dbpassword = "parola";
$db_name = "baza danni";
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$query = " SELECT * FROM songs WHERE author LIKE '%$tarsene%' OR artist LIKE '%$tarsene%' OR title LIKE '%$tarsene%'";
$result = mysql_query($query) or die('Грешка!');
$row = mysql_numrows($result);
echo "<center>Търсачката намери следните резултати:";
echo "<br><br>";
while($row = mysql_fetch_array($result))
{
$pesen = $row[title];
$idto = $row['id'];
$izpulnitel = $row[artist];
echo "<a href='playsong.php?id=$idto'style=' text-decoration:none;'><b><i>$izpulnitel - $pesen</i></b></a><br />";
}
}
?>
