phpcms 搜索指定栏目

<?php
// 假设我们有一个数据库连接
$mysqli = new mysqli("localhost", "username", "password", "database");

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: " . $mysqli->connect_error;
    exit();
}

// 获取用户输入的关键词和栏目ID
$keyword = $_GET['keyword'];
$catid = $_GET['catid'];

// 构建SQL查询
$sql = "SELECT * FROM `v9_news` WHERE `catid` = ? AND (`title` LIKE ? OR `content` LIKE ?)";
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("iss", $catid, "%$keyword%", "%$keyword%");

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

// 处理结果
while ($row = $result->fetch_assoc()) {
    echo "Title: " . $row['title'] . "<br>";
    echo "Content: " . $row['content'] . "<br><br>";
}

// 关闭连接
$stmt->close();
$mysqli->close();
?>