mysqli bind_param() expected to be a reference, value given

by

UPDATE

This answer is outdated. Please use the spread operator in newer PHP versions like answered by Stacky.

From php docu:

Care must be taken when using mysqli_stmt_bind_param() in conjunction with call_user_func_array(). Note that mysqli_stmt_bind_param() requires parameters to be passed by reference, whereas call_user_func_array() can accept as a parameter a list of variables that can represent references or values.

And on the page mysqli-stmt.bind-param you have different solutions:

For example:

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

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;
}

More Related Contents:

  1. PHP create new array by value
  2. How to bind mysqli bind_param arguments dynamically in PHP?
  3. How to fix Trying to access array offset on value of type null error
  4. Fatal error: Cannot use object of type mysqli_result [closed]
  5. MySQLi Bind Param with an array for IN [duplicate]
  6. Returning Multiple Rows with MySqli and Arrays
  7. How do search array values and remove them based on a condition or string? [closed]
  8. inserting information and image in php and mysql
  9. mysqli or die, does it have to die?
  10. How to Flatten a Multidimensional Array?
  11. + operator for array in PHP?
  12. Difference in accessing arrays in PHP 5.3 and 5.4 or some configuration mismatch?
  13. How to get last key in an array?
  14. Characters allowed in php array keys?
  15. How to remove a variable from a PHP session array
  16. Will copy-on-write prevent data duplication on arrays?
  17. use strings to access (potentially large) multidimensional arrays
  18. Nested array. Third level is disappearing
  19. Looping a multidimensional array in php
  20. PHP PDO and MySQLi [duplicate]
  21. why is $_REQUEST empty
  22. Keep Duplicates while Using array_diff
  23. More concise way to check to see if an array contains only numbers (integers)
  24. mysqli query results to show all rows
  25. Is PHP’s count() function O(1) or O(n) for arrays?
  26. How to search in an array with preg_match?
  27. Convert a String to Variable
  28. How do I select 10 random things from a list in PHP?
  29. Array size limit in PHP
  30. How are associative arrays implemented in PHP?

Leave a Comment