php 搜索页

// 示例代码：使用MySQL全文搜索
$query = "SELECT * FROM articles WHERE MATCH(title, content) AGAINST('$keyword' IN NATURAL LANGUAGE MODE)";
$result = mysqli_query($conn, $query);

// 示例代码：使用缓存
if (isset($_SESSION['cached_results'])) {
    $results = $_SESSION['cached_results'];
} else {
    $query = "SELECT * FROM articles WHERE title LIKE '%$keyword%'";
    $result = mysqli_query($conn, $query);
    $results = mysqli_fetch_all($result, MYSQLI_ASSOC);
    $_SESSION['cached_results'] = $results;
}

// 示例代码：使用预处理语句
$stmt = $conn->prepare("SELECT * FROM articles WHERE title LIKE ?");
$stmt->bind_param("s", $keyword);
$keyword = "%$keyword%";
$stmt->execute();
$result = $stmt->get_result();
$results = $result->fetch_all(MYSQLI_ASSOC);