php mysqli在哪里(?，?，?...) [英] php mysqli WHERE IN (?,?,? ...)

问题描述

根据 http://us2.php.net /manual/en/mysqli-stmt.bind-param.php ， 不同的类型是:

According to http://us2.php.net/manual/en/mysqli-stmt.bind-param.php, the different types are:

i   corresponding variable has type integer
d   corresponding variable has type double
s   corresponding variable has type string
b   corresponding variable is a blob and will be sent in packets

但是，如何处理呢?

->prepare("SELECT blabla FROM foo WHERE id IN (?)")

在哪里?将是ID列表.可能有一项或多项:

Where ? would be a list of ids. There could be one or more items:

$ids = "3,4,78";
->bind_param('s',$ids);

有可能吗?

我想使用准备好的语句，因为它将在循环中执行.

I'd like to use prepared statements because it will be executed in a loop.

推荐答案

如果您要绑定到IN语句的每个调用都有一个大小不同的变量列表，最简单的方法是以编程方式生成SQL字符串，并使用循环绑定变量:

If you have a list of variables that differs in size every call that you wanto to bind to an IN-statement, the most simple way would be to generate the SQL string programatically and use a loop to bind the variables:

/**
 * @param  array  $values
 * @param  mysqli $db
 * @return mysqli_stmt
 */
function bindInValues(array $values, mysqli $db)
{
    $sql = sprintf('SELECT blabla FROM foo WHERE id IN (%s)',
        implode(', ', array_fill(0, count($values), '?'))
    );
    $stmt = $db->prepare($sql);
    foreach ($values as $value) {
        $stmt->bind_param('s', $value);
    }
    return $stmt;
}

如果您喜欢call_user_func_array，则可以使用动态方法调用，而无需循环.

If you like call_user_func_array you can use dynamic method invocation and go along without a loop.

/**
 * @param  array  $values
 * @param  mysqli $db
 * @return mysqli_stmt
 */
function bindInValues(array $values, mysqli $db)
{
    $sql = sprintf('SELECT blabla FROM foo WHERE id IN (%s)',
        implode(', ', array_fill(0, count($values), '?'))
    );
    $stmt = $db->prepare($sql);
    array_unshift($values, implode('', array_fill(0, count($values), 's')));
    call_user_func_array(array($stmt, 'bind_param'), $values);
    return $stmt;
}

这篇关于php mysqli在哪里(?，?，?...)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！