How Can I Dynamically Bind Multiple Parameters in mysqli Queries?

Dynamic Binding of Multiple Parameters in mysqli Queries

Traditionally, PHP developers have relied on lengthy conditional statements or manual concatenation to bind multiple parameters into mysqli queries. This can be tedious and error-prone.

Hardcoded Parameter Binding

The example you provided demonstrates the hardcoded approach, where the number of question marks and parameter types is manually adjusted based on the number of input values. While this works, it's not an ideal solution for handling dynamic queries.

Argument Unpacking Operator

Fortunately, PHP 5.6 introduced the argument unpacking operator (...) which allows us to pass arrays as parameters to functions that expect multiple individual arguments.

Solution using Argument Unpacking

To dynamically bind an arbitrary number of parameters in PHP 5.6 , we can use the following approach:

1. Create a types string: Concatenate the character corresponding to the parameter type (e.g., s for string) as many times as there are parameters.

$types = str_repeat('s', count($array)); // returns sss...

2. Bind the parameters: Use the argument unpacking operator to pass the array of parameter values as individual parameters along with the types string:

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

Example:

$array = ['a','b','c']; 
$sql   = "SELECT name FROM table WHERE city IN (?,".str_repeat('?,', count($array) - 2).")"; //  returns ?,?,?...
$stmt  = $mysqli->prepare($sql);
$stmt->bind_param('s', ...$array); 
$stmt->execute();

This approach elegantly handles any number of input parameters without the need for conditional statements or manual concatenation.

The above is the detailed content of How Can I Dynamically Bind Multiple Parameters in mysqli Queries?. For more information, please follow other related articles on the PHP Chinese website!