How to test if a MySQL query was successful in modifying database table data?

by

You’re currently only checking whether the SQL statement is correctly prepared, you’re not checking whether it actually deleted the record.

Try:

...
echo ($delRecord->affected_rows > 0) ? 'true' : 'false';
$delRecord->close();

That doesn’t address whether you’re correctly checking the result string in your Javascript code – if that’s a problem we’ll need more information.

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. How to get count of rows in MySQL table using PHP?
  8. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  9. Example of how to use bind_result vs get_result
  10. mysqli::query(): Couldn’t fetch mysqli
  11. PHP MySQLI Prevent SQL Injection [duplicate]
  12. How can I enable the MySQLi extension in PHP 7?
  13. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  14. How can I use mysqli_fetch_array() twice?
  15. Advantages Of MySQLi over MySQL [closed]
  16. check if the query results empty row mysqli [duplicate]
  17. PHP PDO and MySQLi [duplicate]
  18. using nulls in a mysqli prepared statement
  19. Is mysql_real_escape_string() necessary when using prepared statements?
  20. Updating from MYSQL to MYSQLI [duplicate]
  21. PHP + MySql + Stored Procedures, how do I get access an “out” value?
  22. How to prepare statement for update query? [duplicate]
  23. php password_verify() hash and pass won’t match
  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