Get number of rows matched by UPDATE query with PHP mysqli

by

I used the following code:

// Parse the digits from the info string that has the following format:
// Rows matched: 0 Changed: 0 Warnings: 0
preg_match_all('!\d+!', $mysqli->info, $m);
return $m[0][0];

More Related Contents:

  1. inserting information and image in php and mysql
  2. mysqli or die, does it have to die?
  3. How to display errors for my MySQLi query? [duplicate]
  4. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  5. MySQL vs MySQLi when using PHP [closed]
  6. When should I use MySQLi instead of MySQL?
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. Example of how to use bind_result vs get_result
  9. mysqli::query(): Couldn’t fetch mysqli
  10. PHP MySQLI Prevent SQL Injection [duplicate]
  11. How to test if a MySQL query was successful in modifying database table data?
  12. How can I enable the MySQLi extension in PHP 7?
  13. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in [duplicate]
  14. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  15. How can I use mysqli_fetch_array() twice?
  16. PHP Commands Out of Sync error
  17. Advantages Of MySQLi over MySQL [closed]
  18. MYSQLi error: User already has more than ‘max_user_connections’ active connections [duplicate]
  19. check if the query results empty row mysqli [duplicate]
  20. using nulls in a mysqli prepared statement
  21. Is mysql_real_escape_string() necessary when using prepared statements?
  22. Updating from MYSQL to MYSQLI [duplicate]
  23. How to prepare statement for update query? [duplicate]
  24. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  25. PHP to MySQL SSL Connections
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. Strange problem with the length of the field gotten from database [duplicate]
  28. PHP prepared statements and transactions in a loop [duplicate]
  29. When should I close a database connection in PHP?
  30. Mysqli multiple row insert, simple multi insert query [duplicate]

Leave a Comment