在PDO准备好的语句中将值传递给MySQL IN操作? [英] Passing values to MySQL IN operation in PDO prepared statement?

问题描述

我有一个表单字段，该表单字段返回一个逗号分隔的字符串，我想将该字符串传递给PHP PDO MySQL查询IN操作，但是IN操作要求这些值以逗号分隔(与我的 字符串 (带分隔符的值).

I have a form field that is returning a comma-delimited string that I want to pass in to a PHP PDO MySQL query IN operation, but the IN operation requires that the values be comma-delimited (as opposed to my string of delimited values).

我该怎么做?

$values = $_POST['values']; # '10,5,4,3' (string)
$query = "SELECT * FROM table WHERE id IN (:values)";
$data = array( ':values' => $values );

推荐答案

您不能在单个占位符中传递多个值.您必须为要传入IN ()的每个值输入一个不同的占位符.由于您不知道会有多少个，因此请使用?而不是命名参数.

You can't pass in multiple values in a single placeholder. You will have to enter a different placeholder for each value to be passed into IN (). Since you don't know how many there will be, use ? instead of named parameters.

$values = explode(',', $values) ;

$placeholders = rtrim(str_repeat('?, ', count($values)), ', ') ;
$query = "SELECT * FROM table WHERE id IN ($placeholders)";

$stm = $db->prepare($query) ;
$stm->execute($values) ;

这篇关于在PDO准备好的语句中将值传递给MySQL IN操作?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！