How to develop a simple website search function using PHP

How to use PHP to develop a simple website search function

The rapid development of the Internet has caused the amount of information to grow explosively. In order to allow users to find the information they need more conveniently , website search function has become a basic element of modern websites. In this article, we will introduce how to use PHP to develop a simple website search function and provide specific code examples.

1. Database preparation

First, we need to prepare a database to store the content data of the website. We assume that there is a table named "articles" in the database, which contains the following columns: id (article ID), title (article title), content (article content), author (article author).

2. Search form writing

First, we need to create a search form on the website so that users can enter keywords to search. We can use HTML code to write a simple search form, the code is as follows:

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

3. Write PHP code for search function

Next, we need to write a PHP script to process users search request and obtain relevant search results from the database. We can create a file named "search.php" in the project root directory and add the following code:

<?php
// 获取用户输入的关键词
$keyword = $_POST['keyword'];

// 连接数据库
$mysqli = new mysqli("localhost", "username", "password", "database");

// 检查数据库连接是否成功
if ($mysqli->connect_errno) {
    echo "数据库连接失败：" . $mysqli->connect_error;
    exit();
}

// 设置SQL查询语句
$sql = "SELECT * FROM articles WHERE title LIKE '%{$keyword}%' OR content LIKE '%{$keyword}%'";

// 执行SQL查询
$result = $mysqli->query($sql);

// 检查查询结果
if ($result->num_rows > 0) {
    // 输出搜索结果
    while ($row = $result->fetch_assoc()) {
        echo "文章标题：" . $row['title'] . "<br>";
        echo "文章内容：" . $row['content'] . "<br>";
        echo "文章作者：" . $row['author'] . "<br>";
        echo "<hr>";
    }
} else {
    echo "抱歉，没有找到相关文章。";
}

// 关闭数据库连接
$mysqli->close();
?>

In the above code, we first get the user input through $_POST['keyword'] keyword, and then use mysqli to connect to the database. Next, set the SQL query statement and use the $mysqli->query() method to execute the query. Finally, the relevant article title, content and author information are output according to the query results.

4. Test the search function

After completing the above steps, we can open the website in the browser, enter keywords and click the search button to see the search results displayed. If relevant articles are found, they will be displayed according to the format set in the code; if no relevant articles are found, the corresponding prompt information will be displayed.

Summary:

Through the introduction of this article, we have learned how to use PHP to develop a simple website search function. Relevant code examples can help us understand and can be modified and extended according to our actual needs. I hope this article is helpful to everyone, and happy coding!

The above is the detailed content of How to develop a simple website search function using PHP. For more information, please follow other related articles on the PHP Chinese website!