PHP / MySQLi - array as bind_param

Question

I am curious if there is a way to bind array of parameters at once?

In simple words, something like this:

$sql = "SELECT * FROM table WHERE id IN (?)";
$stmt = $db->prepare($sql);
$stmt->bind_param("<array>", $array_of_ids);
$stmt->execute();

Thoughts?

Sadly, no, Possible duplicate: [PHP/MySQL using an array in WHERE clause](https://stackoverflow.com/questions/907806/php-mysql-using-an-array-in-where-clause) — Ryan Vincent, Jun 16 '15 at 09:42

score 0 · Answer 1 · answered Jun 16 '15 at 09:37

I don't think you can do that as such but if you set up an array of params and values you could use a foreach loop something like

$params=array(
    ':id'=>1,
    ':cat'=>'bananas'
    ':type'=>100
);
foreach( $params as $param=>$value )$stmt->bind_param( $param,$value );

score 0 · Answer 2 · answered Jan 10 '18 at 13:00

Since PHP 5.6, this is possible with the ... operator (see also the documentation). This operator unpacks a list when calling a function, causing the list to act like multiple variables.

You could use the following:

$stmt->bind_param($types, ...$data);

This assumes that $types is a string containing the types for the data and $data a list containg the data for the query.

PHP / MySQLi - array as bind_param

2 Answers2