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?

Answer 1

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 );

Answer 2

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.