How to implement keyword tracing in php-PHP Problem-php.cn

How to implement keyword tracing in php

藏色散人

Release： 2023-03-13 21:34:01

Original

2578 people have browsed it

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.

How to implement keyword tracing in php

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

How to implement keyword tracing in php

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

How to implement keyword tracing in php

##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[&#39;keyword&#39;])){
    $keyword = $_POST[&#39;keyword&#39;];//获取输入的关键字
    //进行数据库连接
    $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 &#39;%$keyword%&#39; or description like &#39;%$keyword%&#39;";
    $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=&#39;#f00&#39;>$keyword</font>",$row[&#39;name&#39;])?></p>
  <p>描述：<?php echo str_ireplace($keyword, "<font color=&#39;#f00&#39;>$keyword</font>",$row[&#39;description&#39;])?></p>
</div>
<?php
  }
}else{
  echo "很遗憾，没有找到书籍";
}
?>
</body>
</html>

Copy after login

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.

Recommended learning: "

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!