How to implement keyword search function in php-PHP Problem-php.cn

How to implement keyword search function in php

藏色散人

Release： 2023-03-14 20:44:01

Original

3916 people have browsed it

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.

How to implement keyword search function in php

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

How to implement keyword search function 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 search function 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 search function in php. For more information, please follow other related articles on the PHP Chinese website!