PHP development practice: How to use PHP and MySQL to implement search functions

PHP Development Practice: How to Use PHP and MySQL to Implement Search Functions

Introduction:
In modern Internet applications, the search function is one of the most common and important functions. Using PHP and MySQL to implement search functions can provide users with better user experience and data retrieval capabilities. This article will introduce how to use PHP and MySQL to implement search functions and provide corresponding code examples.

1. Create database and table
First, we need to create a database and create a table in the database to store search-related data. The following is an example SQL statement:

CREATE DATABASE search_db;
USE search_db;

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255),
    description TEXT,
    price DECIMAL(10, 2)
);

2. Insert sample data
In order to demonstrate the use of the search function, we need to insert some sample data into the table. The following is an example SQL statement:

INSERT INTO products (name, description, price) VALUES
    ('iPhone 12', 'Apple latest smartphone', 999.99),
    ('Samsung Galaxy S20', 'Samsung flagship smartphone', 799.99),
    ('Google Pixel 5', 'Google's latest smartphone', 699.99);

3. Create a search form
In the HTML page, add a search form for users to enter search keywords. The sample code is as follows:

<form method="GET" action="search.php">
    <input type="text" name="keyword" placeholder="请输入关键字" />
    <button type="submit">搜索</button>
</form>

4. Process search requests and return results
Create a PHP file named search.php to process search requests and return corresponding results. The following is a sample code for processing a search request:

<?php
// 连接到MySQL数据库
$connection = mysqli_connect('localhost', 'username', 'password', 'search_db');

// 处理搜索请求
if (isset($_GET['keyword'])) {
    $keyword = $_GET['keyword'];

    // 使用LIKE语句进行数据库查询
    $query = "SELECT * FROM products WHERE name LIKE '%$keyword%' OR description LIKE '%$keyword%'";
    $result = mysqli_query($connection, $query);

    // 显示搜索结果
    echo '<h2>搜索结果：</h2>';
    while ($row = mysqli_fetch_assoc($result)) {
        echo '<p>名称：' . $row['name'] . '</p>';
        echo '<p>描述：' . $row['description'] . '</p>';
        echo '<p>价格：' . $row['price'] . '</p>';
        echo '<hr>';
    }
}

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

The above code will perform a fuzzy matching query in the database based on the keywords entered by the user, and traverse the query results line by line and display them on the page.

Conclusion:
Through the introduction of this article, we have learned how to use PHP and MySQL to implement the search function. From creating databases and tables, inserting sample data, to creating search forms and handling search requests, there are code examples for each step. I hope this article can be helpful to developers who use PHP and MySQL to develop search functions.

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