PHP development tips: How to implement fast search-PHP Tutorial-php.cn

PHP development tips: How to implement fast search

王林

Release： 2023-08-17 11:24:01

Original

1332 people have browsed it

PHP development tips: How to implement fast search

PHP Development Tips: How to Implement Fast Search

Introduction:
In many Web applications, the search function is an essential part. Whether it is for e-commerce websites, news websites or social media platforms, fast and efficient search functions can greatly improve user experience. This article will introduce some PHP development skills to help you implement fast search functions.

1. Use full-text indexing technology
MySQL provides full-text indexing function, which can improve search efficiency. First, make sure your version of MySQL supports full-text indexing. Then, create a full-text index on the table fields that need to be searched. For example, we have a table named products, which contains a field name, we can create a full-text index using the following command:

ALTER TABLE products ADD FULLTEXT(name);

Copy after login

Next, we can use The MATCH() and AGAINST() functions search on the full-text index. For example, if we want to search for products containing the keyword 手机, we can use the following query statement:

SELECT * FROM products WHERE MATCH (name) AGAINST ('手机');

Copy after login

2. Using caching technology
The search function usually faces a problem, that is, the search results The amount of data is large, and each search requires querying the database. In this case, using caching technology will greatly improve the search speed. You can use a cache server such as Memcached or Redis to store search results and reduce the number of queries to the database.

The following is a sample code that uses Memcached to cache search results:

$keyword = $_GET['keyword'];

$memcached = new Memcached();
$memcached->addServer('localhost', 11211);

$result = $memcached->get('search_' . $keyword);

if ($result) {
    echo '搜索结果来自缓存：<br>';
    foreach ($result as $item) {
        echo $item['name'] . '<br>';
    }
} else {
    // 从数据库中查询搜索结果
    $sql = "SELECT * FROM products WHERE name LIKE '%" . $keyword . "%'";
    $result = $db->query($sql);
    $arr = [];
    if ($result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            $arr[] = $row;
        }
        $memcached->set('search_' . $keyword, $arr, 3600); // 缓存结果一小时
        echo '搜索结果来自数据库：<br>';
        foreach ($arr as $item) {
            echo $item['name'] . '<br>';
        }
    } else {
        echo '抱歉，没有找到相关结果。';
    }
}

Copy after login

3. Use AJAX to implement real-time search
In order to improve the user experience of search, you can use AJAX technology to implement real-time search. When the user types a keyword in the search box, the front-end JavaScript sends an AJAX request to the back-end, the back-end returns the matching search results, and then the front-end displays the search results to the user. The following is a real-time search sample code implemented using jQuery and PHP:

<!DOCTYPE html>
<html>
<head>
    <title>实时搜索</title>
    <script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
    <script>
        $(document).ready(function () {
            $("#keyword").keyup(function () {
                var keyword = $(this).val();
                $.ajax({
                    url: "search.php",
                    type: "POST",
                    data: {keyword: keyword},
                    success: function (data) {
                        $("#result").html(data);
                    }
                });
            });
        });
    </script>
</head>
<body>
    <input type="text" id="keyword" placeholder="请输入关键词">
    <div id="result"></div>
</body>
</html>

Copy after login

// search.php
$keyword = $_POST['keyword'];

$sql = "SELECT * FROM products WHERE name LIKE '%" . $keyword . "%'";
$result = $db->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo $row['name'] . '<br>';
    }
} else {
    echo '抱歉，没有找到相关结果。';
}

Copy after login

Summary:
When developing the search function of a web application, the use of full-text indexing, caching, AJAX and other technologies can greatly improve the search efficiency Speed and user experience. I hope the PHP development skills introduced in this article can be helpful to you.

The above is the detailed content of PHP development tips: How to implement fast search. For more information, please follow other related articles on the PHP Chinese website!