How does mysqli_stmt dynamically bind parameter values?

How does mysqli_stmt dynamically bind parameter values ???? The mysqli_stmt & nbsp; Method & nbsp; bind_param requires that all parameters be input at a time, which is equivalent to the number and order of parameters must be hard-coded, however, in practice, it may not be possible to obtain results. for example, when performing a query, the query statement may write mysqli_stmt to dynamically bind the parameter value ????
The mysqli_stmt method bind_param requires that all parameters be passed in at a time, which is equivalent to the number and order of parameters which must be hard-coded, but not necessarily possible.
For example, when performing a query, the query statement may 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 we pass in parameters?
You don't need to advise me how to improve the writing of SQL statements. there will be other similar SQL statements. here I am just an example. I just want to know how to set parameters dynamically.

Thank you! Share:
------ Solution --------------------
Call_user_func_array