PHP PDO Where子句中的post字符串列表

// 假设通过POST请求传递了一个名为"keywords"的字符串列表
$keywords = $_POST['keywords'];

// 连接数据库
$dsn = "mysql:host=localhost;dbname=mydatabase";
$username = "username";
$password = "password";
$dbh = new PDO($dsn, $username, $password);

// 构建预处理语句
$sql = "SELECT * FROM mytable WHERE keyword IN (";
$placeholders = implode(',', array_fill(0, count($keywords), '?'));
$sql .= $placeholders . ")";

// 准备和执行预处理语句
$stmt = $dbh->prepare($sql);
$stmt->execute($keywords);

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

// 处理查询结果
foreach ($result as $row) {
    // 处理每一行数据
}

// 关闭数据库连接
$dbh = null;