如何使用PHP开发简单的网站搜索功能

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

<?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();
?>