phpcms的多条件查询

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

// 定义查询条件
$conditions = [
    'status' => 1,
    'category_id' => 5,
    'created_at' => ['>=', '2023-01-01']
];

// 构建查询语句
$query = "SELECT * FROM articles WHERE ";
$bindings = [];
$index = 0;

foreach ($conditions as $key => $value) {
    if (is_array($value)) {
        $query .= ($index > 0 ? ' AND ' : '') . "{$key} >= ?";
        $bindings[] = $value[0];
    } else {
        $query .= ($index > 0 ? ' AND ' : '') . "{$key} = ?";
        $bindings[] = $value;
    }
    $index++;
}

// 执行查询
$stmt = $db->prepare($query);
$stmt->execute($bindings);

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

// 输出结果
print_r($results);
?>