phpcms 搜索代码

<?php
// 假设我们有一个搜索函数 search_content
function search_content($keyword) {
    // 连接数据库
    $db = new PDO('mysql:host=localhost;dbname=phpcms', 'username', 'password');

    // 构建搜索 SQL
    $sql = "SELECT * FROM content WHERE title LIKE :keyword OR content LIKE :keyword";
    $stmt = $db->prepare($sql);
    $stmt->bindParam(':keyword', "%$keyword%");

    // 执行查询
    $stmt->execute();

    // 获取结果
    $results = $stmt->fetchAll(PDO::FETCH_ASSOC);

    return $results;
}

// 使用示例
$keyword = $_GET['keyword'] ?? '';
$results = search_content($keyword);

// 输出结果
foreach ($results as $result) {
    echo "Title: " . $result['title'] . "<br>";
    echo "Content: " . $result['content'] . "<br><br>";
}
?>