Home > Article > Backend Development > How to implement keyword tracing in php
How to implement keyword tracing in php
- 藏色散人Original
- 2021-11-18 09:35:272531browse
php method to implement keyword tracing: 1. Get the keyword text input from the text box; 2. Connect to the database and query; 3. Display the query results in a loop; 4. Use the str_ireplace function Just replace the keyword text with red text.
The operating environment of this article: windows7 system, PHP7.1 version, DELL G3 computer
How to implement keyword tracing in php?
Example of PHP's implementation of the red highlight function after keyword search
This article describes an example of PHP's implementation of the red highlight function after keyword search. I share it with you for your reference. The details are as follows:
When I first started learning PHP, I was curious about the keyword tracing after searching. But in the past few days, when I was consolidating the basics of PHP, I found that this was the case. It is not difficult to achieve the 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 tracing in php. For more information, please follow other related articles on the PHP Chinese website!