php全表搜索,搜索整个表？ PHP MySQL

我创建了以下搜索脚本,但在查询数据库时只能搜索一个表列：

$query = "select * from explore where site_name like '%".$searchterm."%'";

我想知道如何搜索整个表格(探索).另外,我需要修复这行代码：

echo "$num_found. ".($row['site_name'])."
";

最后一件令我烦恼的事情是,当我在另一个页面上按下提交按钮时,我总是会显示消息“请输入搜索词”.即使我进入某事物？

感谢您的帮助,如果需要,这是整个脚本：

// Set variables from form.

$searchterm = $_POST['searchterm'];

trim ($searchterm);

// Check if search term was entered.

if (!$serachterm)

{

echo "Please enter a search term.";

}

// Add slashes to search term.

if (!get_magic_quotes_gpc())

{

$searchterm = addcslashes($searchterm);

}

// Connects to database.

@ $dbconn = new mysqli('localhost', 'root', 'root', 'ajax_demo');

if (mysqli_connect_errno())

{

echo "Could not connect to database. Please try again later.";

exit;

}

// Query the database.

$query = "select * from explore where site_name like '%".$searchterm."%'";

$result = $dbconn->query($query);

// Number of rows found.

$num_results = $result->num_rows;

echo "Found: ".$num_results."

";

// Loops through results.

for ($i=0; $i

{

$num_found = $i + 1;

$row = $result->fetch_assoc();

echo "$num_found. ".($row['site_name'])."
";

}

// Escape database.

$result->free();

$dbconn->close();

?>