How to prepare statement for update query? [duplicate]

by

An UPDATE works the same as an insert or select. Just replace all the variables with ?.

$sql = "UPDATE Applicant SET phone_number=?, street_name=?, city=?, county=?, zip_code=?, day_date=?, month_date=?, year_date=? WHERE account_id=?";

$stmt = $db_usag->prepare($sql);

// This assumes the date and account_id parameters are integers `d` and the rest are strings `s`
// So that's 5 consecutive string params and then 4 integer params

$stmt->bind_param('sssssdddd', $phone_number, $street_name, $city, $county, $zip_code, $day_date, $month_date, $year_date, $account_id);
$stmt->execute();

if ($stmt->error) {
  echo "FAILURE!!! " . $stmt->error;
}
else echo "Updated {$stmt->affected_rows} rows";

$stmt->close();

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: can it prepare multiple queries in one statement?
  6. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  7. using nulls in a mysqli prepared statement
  8. Is mysql_real_escape_string() necessary when using prepared statements?
  9. Using Prepared Statement, how I return the id of the inserted row?
  10. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  11. When should I use MySQLi instead of MySQL?
  12. mysqli::query(): Couldn’t fetch mysqli
  13. PHP MySQLI Prevent SQL Injection [duplicate]
  14. mysql PDO how to bind LIKE
  15. How to test if a MySQL query was successful in modifying database table data?
  16. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  17. How can I use mysqli_fetch_array() twice?
  18. PHP Commands Out of Sync error
  19. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  20. store_result() and get_result() in mysql returns false
  21. Using wildcards in prepared statement – MySQLi
  22. bind_param Number of variables doesn’t match number of parameters in prepared statement
  23. Use of PDO in classes [duplicate]
  24. How can I bind an array of strings with a mysqli prepared statement?
  25. Mysqli Prepare Statement – Returning False, but Why? [duplicate]
  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. How do I ensure I caught all errors from MySQLi::multi_query?
  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