Bind Param with array of parameters

by

call_user_func_array
“Call a callback with an array of parameters”

call_user_func_array(array($stmt, "bind_param"), array_merge(array($type), $params));

should do the job

UPDATE: you have also to change your params array:

$params = array(&$firstName, &$lastName, &$address, &$postcode, &$email, &$password);

as mysqli_stmt::bind_param expects the second and the following parameters by reference.

EDIT: Your query seems to be wrong. Maybe you have less fields than you have variables there. Do:

"INSERT INTO Users (field1, field2, field3, field4, field5, field6) VALUES (?, ?, ?, ?, ?, ?)"

where you replace the name of the fields by the correct names

More Related Contents:

  1. How to bind mysqli bind_param arguments dynamically in PHP?
  2. MySQLI binding params using call_user_func_array
  3. PHP create new array by value
  4. Turning a SQL row into an array
  5. How to insert database rows if there are no answers
  6. two person chat room
  7. Pagination data
  8. Example of how to use bind_result vs get_result
  9. mysqli::query(): Couldn’t fetch mysqli
  10. get array of rows with mysqli result
  11. How to start and end transaction in mysqli?
  12. How to install MySQLi on MacOS
  13. How do I iterate over the results in a MySQLi result set?
  14. PHP MySQLI Prevent SQL Injection [duplicate]
  15. The mysqli extension is missing. Please check your PHP configuration
  16. How to test if a MySQL query was successful in modifying database table data?
  17. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  18. PHP Commands Out of Sync error
  19. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  20. $stmt->execute() : How to know if db insert was successful?
  21. store_result() and get_result() in mysql returns false
  22. Checking if mysqli_query returned any values?
  23. Warning: mysqli_query() expects parameter 1 to be mysqli, string given in
  24. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  25. Fatal error: Call to undefined method mysqli_result::fetch_all()
  26. How to run the bind_param() statement in PHP?
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. Set character set using MySQLi
  29. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  30. How to get a list of databases?

Leave a Comment