Home >Backend Development >PHP Problem >How to implement search function on web using php

How to implement search function on web using php

PHPz
PHPzOriginal
2023-03-29 11:34:431582browse

PHP is a server-side scripting language widely used in Web development. It has powerful functions and flexibility and can implement a variety of complex functions. Among them, the search function is undoubtedly one of the most commonly used functions by users, so this article will introduce how to use PHP to implement the Web search function.

  1. Create a search form

Add a search form to the main page of the website, usually a simple text box and a search button. The code is as follows:

<form action="search.php" method="get">
  <input type="text" name="keyword" placeholder="搜索">
  <input type="submit" value="搜索">
</form>

Among them, the action attribute specifies the processing file when submitting the form as search.php, and the method attribute specifies the submission The method is get, you can also use the post method.

  1. Processing search requests

Submit search requests to the search.php file for processing. The code is as follows:

<?php
// 获取提交的搜索关键词
$keyword = $_GET[&#39;keyword&#39;];

// 连接数据库
$conn = mysqli_connect(&#39;localhost&#39;, &#39;root&#39;, &#39;password&#39;, &#39;database&#39;);

// 查询匹配的结果
$result = mysqli_query($conn, "SELECT * FROM articles WHERE title LIKE &#39;%$keyword%&#39; OR content LIKE &#39;%$keyword%&#39;");

// 处理查询结果
while ($row = mysqli_fetch_assoc($result)) {
  // 显示搜索结果
  echo $row[&#39;title&#39;];
  // ...
}

// 关闭数据库连接
mysqli_close($conn);
?>

First, get the keyword $keyword from the $_GET data, then connect to the database and use the SELECT statement to query the match the result of. In this example, all articles in the articles table whose titles and contents appear with the keyword $keyword are queried.

Finally, process the query results and display them on the page. Remember to close the database connection at the end.

  1. Exact match search

If you want to achieve exact match search, change LIKE in the WHERE statement to = is enough. The code is as follows:

$result = mysqli_query($conn, "SELECT * FROM articles WHERE title = '$keyword'");
  1. Display search results in pages

When the search results are queried, they are usually displayed on multiple pages. At this time, it is necessary to display relevant search results according to the number of divided pages. You can use PHP's LIMIT statement to paginate query results. The code is as follows:

// 分页每页显示的条数
$pagesize = 10;
// 当前页码
$page = isset($_GET['page']) ? intval($_GET['page']) : 1;

// 查询总记录数
$count_result = mysqli_query($conn, "SELECT COUNT(*) AS count FROM articles WHERE title LIKE '%$keyword%' OR content LIKE '%$keyword%'");
$count_row = mysqli_fetch_assoc($count_result);
$count = $count_row['count'];

// 计算总页数
$pagecount = ceil($count / $pagesize);

// 分页查询
$start = ($page - 1) * $pagesize;
$limit = "$start, $pagesize";
$result = mysqli_query($conn, "SELECT * FROM articles WHERE title LIKE '%$keyword%' OR content LIKE '%$keyword%' LIMIT $limit");

// 处理查询结果
// ...

// 显示分页链接
echo "<div class=&#39;pagination&#39;>";
for ($i = 1; $i <= $pagecount; $i++) {
  if ($i == $page) {
    echo "<span class=&#39;current&#39;>$i</span>";
  } else {
    echo "<a href=&#39;search.php?keyword=$keyword&page=$i&#39;>$i</a>";
  }
}
echo "</div>";

First, define the number of items displayed on each page and the current page number. Then query the total number of matching results and calculate the total number of pages. Finally, use the LIMIT statement to paginate the query results and display the paging link. Among them, the $start and $limit parameters are used to control the starting position and quantity of the query.

  1. Use full-text search

In addition to using exact matching or fuzzy matching in keywords, you can also use full-text search to achieve more precise result matching. Full-text search can be achieved through the MATCH and AGAINST statements that come with MySQL. The usage method is as follows:

$result = mysqli_query($conn, "SELECT * FROM articles WHERE MATCH(title, content) AGAINST('$keyword' IN NATURAL LANGUAGE MODE)");

keyword$keyword will be Automatic word segmentation, matching any field in title and content, and finally sorting and displaying the results according to the degree of matching.

The above is all about using PHP to implement the Web search function. Through the above steps, we can quickly add search functions to the website and improve the user experience of the website.

The above is the detailed content of How to implement search function on web using php. 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