MySQLI bind params using call_user_func_array not working

Question

Why its not working? I am trying to dynamically bind params based on what user send GET data. Not sure what is wrong about it.

    $bind_param = array();
    $array_param = array();
    $params = array();
    $i = 0;
    $bind_param[$i] = "i";
    $array_param[$i] = $_GET['p2'];

    $query = "SELECT * from point where fixture_id = ? ";

    if(isset($_GET['p1'])){
        $query .= "and user_id = ? ";
        $i++;
        $bind_param[$i] = "i";
        $array_param[$i] = $_GET['p1'];
    }

    $param_type = '';
    $n = count($bind_param);
    for($i = 0; $i < $n; $i++) {
      $param_type .= $bind_param[$i];
    }

    $params[] = $param_type;
    for($i = 0; $i < $n; $i++) {
      $params[] = $array_param[$i];
    }

    $stmt = $mysqli->prepare($query);

    call_user_func_array(array($stmt, 'bind_param'), $params);

    $stmt->execute();

Error :

PHP Warning:  Parameter 2 to mysqli_stmt::bind_param() expected to be a reference, value given

Anders Carstensen · Accepted Answer · 2015-10-24 09:23:46Z

1

Try putting references into the array instead of values (notice the ampersands):

$params[] = &$param_type;
for($i = 0; $i < $n; $i++) {
  $params[] = &$array_param[$i];
}

answered Oct 24, 2015 at 9:23

Anders Carstensen

4,3441 gold badge27 silver badges24 bronze badges

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

2 Comments

ggDeGreat Over a year ago

wow. i just missed out the & symbol. i never know what is the use of & to be put at the front of array variable.

Anders Carstensen Over a year ago

@ggDeGreat You can read more about references in the PHP Manual. If this has answered your question, please mark it as accepted.

Collectives™ on Stack Overflow

MySQLI bind params using call_user_func_array not working

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related