如何通过php脚本搜索mysql数据库。 （不工作）

Question

I can not return results with the php scritp that quires the database and echos results? All i get is fetched data successfully. Any help would be great and thanks.

<form action="#" method="get">
search: <input type="text" name="Id"><br>  
<input type="submit" value="delete">
</form>

<?php
$dbhost = 'localhost:3036';
$dbuser = 'root';
$dbpass = '#####';
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
$search = $_GET['search'];
if($_GET){
$sql = 'SELECT Id, Employee_Name, 
           Employee_Email
    FROM Blog
    WHERE Id LIKE "%$sql%"';

 mysql_select_db('test');
 $retval = mysql_query( $sql, $conn );
 if(! $retval )
 {
 die('Could not get data: ' . mysql_error());
}
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
echo "Tutorial ID :{$row['Id']}  <br> ".
     "Title: {$row['Employee_Name']} <br> ".
     "Author: {$row['Employee_Email']} <br> ".
     "--------------------------------<br>";
} 
echo "Fetched data successfully
";
}
mysql_close($conn);
?>

Answer 1

Double quotes don't work in SQL queries. This:

$sql = 'SELECT Id, Employee_Name, 
       Employee_Email
FROM Blog
WHERE Id LIKE "%$sql%"';

Should be this:

$sql = "SELECT Id, Employee_Name, 
       Employee_Email
FROM Blog
WHERE Id LIKE '%$search%'";

Also, it's time to stop using the deprecated mysql functions. Switch to mysqli for MySQL, and switch to PDO if you want to interface with MySQL and other types of databases (MSSQL, Oracle, etc.).