Home > Article > Backend Development > How to implement keyword search function in php
How to implement keyword search function in php
- 藏色散人Original
- 2022-01-18 10:10:573914browse
How to implement the keyword search function in php: 1. Create a database; 2. Get the entered keywords; 3. Connect to the database; 4. Query records that contain keyword text in the book title or description Come out and display the query results in a loop.
The operating environment of this article: Windows7 system, PHP7.1 version, DELL G3 computer
How does php implement the keyword search function?
Example of PHP implementation of keyword search after highlighting function
When I first started learning PHP, I was curious about the keyword highlighting after search, but When I was consolidating the foundation of PHP these days, I found that it is not difficult to achieve such an effect. As usual, let me show you the renderings first.
Running renderings
Database related
- The database name is Book has only one database table, which is also a book, and simulates 5 pieces of data.
- The name field is the title of the book, and the description field is the description of the book
##Code
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<title></title>
<link rel="stylesheet" href="">
</head>
<body>
<form action="14.php" method="post">
请输入关键字：<input type="text" name="keyword">
<input type="submit" value="提交" />
</form>
<?php
if(!empty($_POST['keyword'])){
$keyword = $_POST['keyword'];//获取输入的关键字
//进行数据库连接
$conn = mysql_connect("localhost","root","1234");
if(!$conn){
die("数据库连接失败");
}
$flag = mysql_select_db("book",$conn);
if(!$flag){
die("数据库打开失败");
}
mysql_query("set names utf8");
$sql = "select * from book where name like '%$keyword%' or description like '%$keyword%'";
$result = mysql_query($sql,$conn);
while($row = mysql_fetch_assoc($result)){
?>
<div style="width:300px;height:100px;background-color: #ccc;margin-bottom: 10px">
<p>书名：<?php echo str_ireplace($keyword, "<font color='#f00'>$keyword</font>",$row['name'])?></p>
<p>描述：<?php echo str_ireplace($keyword, "<font color='#f00'>$keyword</font>",$row['description'])?></p>
</div>
<?php
}
}else{
echo "很遗憾，没有找到书籍";
}
?>
</body>
</html> Finally, let’s talk about the implementation principle. First, get the keyword text input from the text box, and then connect to the database to query, query the records containing the keyword text in the book title or description, and display the query results in a loop. , when displaying the book title and description, use the str_ireplace() function to replace the keyword text with red text to achieve the effect of keyword highlighting.
PHP Video Tutorial"
The above is the detailed content of How to implement keyword search function in php. For more information, please follow other related articles on the PHP Chinese website!