phpcms 高级搜索

<?php
// 假设我们有一个搜索表单，用户输入关键词和其他条件
$keyword = $_GET['keyword'] ?? '';
$start_date = $_GET['start_date'] ?? '';
$end_date = $_GET['end_date'] ?? '';

// 构建SQL查询语句
$sql = "SELECT * FROM articles WHERE 1=1";
$params = [];

if (!empty($keyword)) {
    $sql .= " AND (title LIKE ? OR content LIKE ?)";
    $params[] = "%$keyword%";
    $params[] = "%$keyword%";
}

if (!empty($start_date) && !empty($end_date)) {
    $sql .= " AND publish_date BETWEEN ? AND ?";
    $params[] = $start_date;
    $params[] = $end_date;
}

// 执行查询
$stmt = $pdo->prepare($sql);
$stmt->execute($params);

$results = $stmt->fetchAll(PDO::FETCH_ASSOC);

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