Store references in array

[wisni1rr]

I'm writing a dynamic search page for my mysql database.

I'm having trouble with my mysqli_stmt_bind_param() statement entering multiple parameters.

Before the statement I am saving all my parameters in to an array called $paramArray.

How would I add each element of the $paramArray to end of the function arguments?

My original thought was to implode the array with the "," delimiter. However, the function will treat the implode as a single string.

//Excerpt
$paramArray[] = 100;
$paramArray[] = 500;
$paramArray[] = 800;
 
...
 
mysqli_stmt_bind_param($stmt, "iii", implode(",",$paramArray));
 
 

The implode function creates the string, "100,500,800".
However I need it to work like this:

mysqli_stmt_bind_param($stmt, "iii", $paramArray[0], $paramArray[1], $paramArray[2]); 
 

Any ideas? Thanks in advance!

[Exequiel]

can you state some output examples that you want to print by your code??

[Dormilich]

My original thought was to implode the array with the "," delimiter. However, the function will treat the implode as a single string.

because it is a single string.

Before the statement I am saving all my parameters in to an array called $paramArray.

How would I add each element of the $paramArray to end of the function arguments?

unfortunately there is no easy way to do that in mysqli. you either do it manually (as demonstrated in your last code block) or you could try call_user_func_array():

array_unshift($paramArray, str_pad("", "i", count($paramArray)));
call_user_func_array(array($stmt, "bind_param"), $paramArray);

[wisni1rr]

Thanks.

In order to get this to work I needed to add "&" to each of my variables stored in my $paramArray. (They are not all static values.)

[Dormilich]

(They are not all static values.)

you must not pass values into ->bind_param() only variables, hence you need the references.