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);

    // 获取搜索条件
    $search = isset($_GET['search']) ? $_GET['search'] : '';

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

    if (!empty($search)) {
        $keywords = explode(' ', $search);
        foreach ($keywords as $keyword) {
            $sql .= " AND (column1 LIKE :keyword OR column2 LIKE :keyword)";
            $params[':keyword'] = "%$keyword%";
        }
    }

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

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

    // 输出结果
    foreach ($results as $row) {
        echo "ID: " . $row['id'] . " - Name: " . $htmlentities($row['name']) . "<br>";
    }
} catch (PDOException $e) {
    echo "数据库连接失败: " . $e->getMessage();
}
?>