php 多条件筛选源码

<?php
// 数据库连接配置
$host = 'localhost';
$dbname = 'your_database';
$user = 'your_username';
$pass = 'your_password';

try {
    // 创建PDO实例
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $user, $pass);

    // 获取筛选条件
    $filters = [
        'name' => isset($_GET['name']) ? $_GET['name'] : '',
        'age' => isset($_GET['age']) ? $_GET['age'] : '',
        'city' => isset($_GET['city']) ? $_GET['city'] : ''
    ];

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

    if (!empty($filters['name'])) {
        $sql .= " AND name LIKE :name";
        $params[':name'] = "%{$filters['name']}%";
    }
    if (!empty($filters['age'])) {
        $sql .= " AND age = :age";
        $params[':age'] = $filters['age'];
    }
    if (!empty($filters['city'])) {
        $sql .= " AND city = :city";
        $params[':city'] = $filters['city'];
    }

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

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

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

} catch (PDOException $e) {
    echo "数据库连接失败: " . $e->getMessage();
}
?>