Mysqli_stmt how to dynamically bind parameter values?

Mysqli_stmt how to dynamically bind parameter values????
Mysqli_stmt method Bind_param, requires a one-time parameter all passed in, equivalent to the number of parameters and order must be hard-coded, but in practice may not be able to get
For example, when you do a query, the query statement will be written like this
$sql = "SELECT * from MyTable where price > 100";
if (...)
$sql. = "and Price <?";
if (...)
$sql. = "and CreatedDate <?";
if (...)
$sql. = "and EmployeeID =?";
......

How should I pass in the parameters?
You don't have to suggest how I can improve the way SQL is written, and there will be other similar SQL, and I'm just going to give you an example of how to set parameters dynamically.

Thank you!

Share to:

------Solution--------------------
Call_user_func_array

