HOW TO CREATE A PHP SEARCH ENGINE TO SEARCH SONGS IN MY /MUSIC DIRECTORY? A SIMPLE ONE INDEED IS WHAT I WANT.?

< ?
//This is only displayed if they have submitted the form
if ($searching =="yes")
{
echo "

Results

“;

//If they did not enter a search term we give them an error
if ($find == “”)
{
echo “

You forgot to enter a search term”;
exit;
}

// Otherwise we connect to our Database
mysql_connect(“mysql.yourhost.com”, “user_name”, “password”) or die(mysql_error());
mysql_select_db(“database_name”) or die(mysql_error());

// 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
$data = mysql_query(“SELECT * FROM users WHERE upper($field) LIKE’%$find%’”);

//And we display the results
while($result = mysql_fetch_array( $data ))
{
echo $result['fname'];
echo ” “;
echo $result['lname'];
echo “
“;
echo $result['info'];
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($data);
if ($anymatches == 0)
{
echo “Sorry, but we can not find an entry to match your query

“;
}

//And we remind them what they searched for
echo “Searched For: ” .$find;
}
?>

Notice the LIKE’%$find% << — this is used to search in SQL

$data = mysql_query(“SELECT * FROM users WHERE upper($field) LIKE’%$find%’”)

This code actually does the searching. We are choosing all the data from our table WHERE the the field they choose is LIKE their search string. We use upper () here to search the uppercase version of the fields. We also use the ‘%’ percentage on either side of our $find variable to indicate that we are not looking solely for that term but rather that term possibly contained in a body of text.