PDO绑定未知数量的参数? [英] PDO bind unknown number of parameters?

问题描述

$statement = $db->prepare('SELECT blah FROM blah_table WHERE blahID IN (:a, :b, :c)');

如果直到运行时未知参数数量，该怎么办?我能想到的唯一一件事是，以一种怪诞的方式构建sql字符串，以根据需要创建尽可能多的参数占位符.

What if the number of parameters is unknown until run-time? The only thing I can think of doing is a hacky kind of building of the sql string to make as many parameter placeholders as I need.

推荐答案

您可以动态构建"IN(...)"字符串:

You can build the "IN (...)" string dynamically:

$in_string = '(';
foreach ( $array_of_parameters as $parameter ) {
    $in_string .= ':' . chr($i + 97) . ','; // Get the ASCII character
}
$in_string = substr($in_string, 0, -1) . ')';

$statement = $db->prepare("SELECT blah FROM blah_table WHERE blahID IN ($in_string)");

这篇关于PDO绑定未知数量的参数?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！