mysqli_stmt::bind_param() expects parameter 1 to be string, array given

Question

I don't know why, but this doesnt work.

array_unshift($params,$types);
if($stmt = $conn->prepare($sql)){
  call_user_func_array(array($stmt, 'bind_param'), refValues($params));

  $stmt->execute();

Now it says:

Warning: mysqli_stmt::bind_param() expects parameter 1 to be string, array given...

So what is wrong with this code?

function refValues($arr){
if(strnatcmp(phpversion(),'5.3') >= 0){ //Reference is required for PHP 5.3
    $refs = array();
    foreach($arr as $key => $value){
        $refs[$key] = &$arr[$key];
    }
    return $refs;
}
return $arr;
}

The print_r of refValues($params);

Array ( [0] => Array ( [0] => i [1] => i [2] => i [3] => i [4] => i [5] => i [6] => i [7] => i [8] => i [9] => s [10] => i [11] => i [12] => i [13] => i [14] => i [15] => i [16] => i [17] => i [18] => i [19] => i [20] => i [21] => i ) [1] => 1 [2] => 0 [3] => 0 [4] => 0 [5] => 0 [6] => 0 [7] => 0 [8] => 1241 [9] => [10] => [11] => 1 [12] => [13] => [14] => [15] => 432 [16] => 243 [17] => 0 [18] => 0 [19] => 0 [20] => 0 [21] => 0 [22] => 78 )

Here's the solution: I just had to implode the $types array. So Then the first parameter is a string and not an array anymore.

There are 2 Arrays, is that correct? I'm not sure if this can work. — modsfabio
– modsfabio, Commented Jun 20, 2017 at 11:42
@modsfabio Is there any alternative? the array at array[0] contains all datatypes. — pandaNine
– pandaNine, Commented Jun 20, 2017 at 11:45

modsfabio · Accepted Answer · 2017-06-20 11:37:03Z

1

I don't know what's inside $params, but mysqli_stmt::bind_param expects the second and the following parameters by reference.

bool mysqli_stmt::bind_param ( string $types , mixed &$var1 [, mixed &$... ] )

Source: Doc: mysqli_stmt::bind_param

So you have to change the array values to references. For example:

$params = array(&$var1, &$var2, &$var3);

In case your array is dynamic, use the following function to convert it:

function arrayToRef(&$rawArray)
{ 
    $refArray = array(); 
    foreach($rawArray as $key => $value) 
    {
        $refArray[$key] = &$rawArray[$key];
    }
    return $refArray; 
}

edited Jun 20, 2017 at 11:37

answered Jun 20, 2017 at 11:26

modsfabio

1,1371 gold badge13 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

pandaNine Over a year ago

I want to bind the parameters dynamically. You solution doesn't work dynamically, doesn't it?

modsfabio Over a year ago

You can convert the array, I added it to my answer

pandaNine Over a year ago

The function I used does the same as yours do:

function refValues($arr){     if(strnatcmp(phpversion(),'5.3') >= 0){ //Reference is required for PHP 5.3         $refs = array();         foreach($arr as $key => $value){             $refs[$key] = &$arr[$key];         }         return $refs;     }     return $arr;   }

So the error message is still the same.

Collectives™ on Stack Overflow

mysqli_stmt::bind_param() expects parameter 1 to be string, array given

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related