mysqli: can it prepare multiple queries in one statement?

by

A prepared statement can only execute one MySQL query. You can prepare as many statements as you want in different variables:

$stmtUser = $sql->prepare("INSERT INTO user (id_user, username, pw, email) VALUES (?,?,?,?)");
$stmtProc = $sql->prepare("INSERT INTO process (id_user, idp) VALUES (?,?);");

And then execute them later. If you want to ensure that neither one is ever run unless both are able to run, then you need to look into transactions, like Thomas said.

Also, a general tip: “call to member function on a non-object” is the standard error you get when prepare() fails and so $stmt isn’t actually a prepared statement object. It usually means you need to look for an error in your prepare() statement rather than anything later.

More Related Contents:

  1. mysqli_stmt::bind_result(): Number of bind variables doesn’t match number of fields in prepared statement
  2. How to use mysqli prepared statements?
  3. MySQLi prepared statements error reporting [duplicate]
  4. Example of how to use bind_result vs get_result
  5. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  6. using nulls in a mysqli prepared statement
  7. Is mysql_real_escape_string() necessary when using prepared statements?
  8. How to prepare statement for update query? [duplicate]
  9. Using Prepared Statement, how I return the id of the inserted row?
  10. PHP – Using PDO with IN clause array
  11. How to display errors for my MySQLi query? [duplicate]
  12. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  13. When should I use MySQLi instead of MySQL?
  14. mysqli::query(): Couldn’t fetch mysqli
  15. How can I enable the MySQLi extension in PHP 7?
  16. How can I use mysqli_fetch_array() twice?
  17. Advantages Of MySQLi over MySQL [closed]
  18. check if the query results empty row mysqli [duplicate]
  19. Updating from MYSQL to MYSQLI [duplicate]
  20. PDO error: SQLSTATE[HY000]: General error: 2031
  21. Using fetch_assoc on prepared statements
  22. store_result() and get_result() in mysql returns false
  23. Use of PDO in classes [duplicate]
  24. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  25. How to run the bind_param() statement in PHP?
  26. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  27. Strange problem with the length of the field gotten from database [duplicate]
  28. PHP prepared statements and transactions in a loop [duplicate]
  29. Mysqli multiple row insert, simple multi insert query [duplicate]
  30. Should I use mysqli_real_escape_string or should I use prepared statements? [duplicate]

Leave a Comment