Home > Article > Backend Development > Implementation method of php keyword query

Implementation method of php keyword query

藏色散人Original: 2020-11-02 11:46:582762browse

How to implement keyword query in php: first obtain user input; then decompose multiple keywords entered by the user and store them in an array; then construct an SQL statement based on multiple keywords; and finally sort the search results , and display the current search results.

Recommended: "PHP Video Tutorial"

PHP searches the database mainly by using like in the SQL statement clause to achieve. If you search for multiple keywords at the same time, you can use the union clause to combine the search results. The following code implements a search page.

Quote

<?php require_once(&#39;&#39;Connections/conn.php&#39;&#39;); ?>
<?php
$colname_rs = $_GET[&#39;&#39;key&#39;&#39;]; //获得用户输入
$result = explode(&#39;&#39;,&#39;&#39;,$_GET[&#39;&#39;key&#39;&#39;]);//分解用户输入的多个关键词，存入$result数组
mysql_select_db($database_conn, $conn); //连接数据库
//根据多个关键词构建SQL语句
$query_rs = "SELECT * FROM (";
for($i=0;$i<count($result);$i++) //根据每个搜索关键词构建SQL语句
{
if($i==0) //对第一个关键词，不使用UNION
$query_rs .= "SELECT * FROM searchtable WHERE title LIKE &#39;&#39;%$result[0]%&#39;&#39;
OR content LIKE &#39;&#39;%$result[0]%&#39;&#39;";
else //对其他关键词，使用UNION连接
$query_rs .= " UNION SELECT * FROM searchtable WHERE title LIKE
&#39;&#39;%$result[$i]%&#39;&#39; OR content LIKE &#39;&#39;%$result[$i]%&#39;&#39;";
}
$query_rs .= ") T ORDER BY last_access DESC"; //对搜索结果排序
//执行SQL语句
$rs = mysql_query($query_rs, $conn) or die(mysql_error());
$row_rs = mysql_fetch_assoc($rs);
$totalRows_rs = mysql_num_rows($rs);
?>
<html>
<head>
<title>Search</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<form name="form1" method="get" action="?">
<div align="center">请输入要搜索关键词：
<input name="key" type="text" size="64" value="<?php echo $_GET[&#39;&#39;key&#39;&#39;] ?>">
<input type="submit" value="Submit">
</div>
</form>
<p align="center"><B>当前关键词：
<?php
for($i=0;$i<count($result);$i++) { //循环显示关键词
echo $result[$i]." ";
}
?></B></p>
<p><hr></p>
<?php if($totalRows_rs>0) do { //显示当前搜索结果 ?>
<p>* <a href="show.php?key=<?php echo $colname_rs ?>&id=<?php echo
$row_rs[&#39;&#39;id&#39;&#39;]; ?>"><?php echo $row_rs[&#39;&#39;title&#39;&#39;]; ?></a>(<?php echo
$row_rs[&#39;&#39;click&#39;&#39;]; ?> | <?php echo $row_rs[&#39;&#39;last_access&#39;&#39;]; ?>)</p>
<?php } while ($row_rs = mysql_fetch_assoc($rs)); ?>
</body>
</html>
<?php
mysql_free_result($rs);
?>

Here, you can use English commas "," on the page to search for multiple keywords.

Here, the connection with the database is still placed in a special PHP file to facilitate later modifications.

The above is the detailed content of Implementation method of php keyword query. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：How to install pdo_mysql extension in phpNext article：How to install pdo_mysql extension in php

See more

Implementation method of php keyword query

Related articles