$stmt->execute() : How to know if db insert was successful?

by

The execute() method returns a boolean … so just do this :

if ($stmt->execute()) { 
   // it worked
} else {
   // it didn't
}

Update: since 2022 and beyond, a failed query will throw an error Exception. So you won’t have to write any code to “skip other pieces of code further down the page” – it will be skipped automatically. Therefore you shouldn’t add any conditions and just write the code right away:

$stmt = $connection->prepare("insert into table (blah) values (?)");
$stmt->bind_param("s", $blah);  
$stmt->execute();

If you need to do something in case of success, then just do it right away, like

echo "success";

You will see it only if the query was successful. Otherwise it will be the error message.

More Related Contents:

  1. inserting information and image in php and mysql
  2. mysqli or die, does it have to die?
  3. MySQL vs MySQLi when using PHP [closed]
  4. Fatal error: Call to undefined function mysqli_connect()
  5. PHP error: “Cannot pass parameter 2 by reference”
  6. Warning: mysqli_query() expects parameter 1 to be mysqli, null given in
  7. How to get count of rows in MySQL table using PHP?
  8. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  9. How to bind mysqli bind_param arguments dynamically in PHP?
  10. Warning: mysqli_select_db() expects exactly 2 parameters, 1 given
  11. How can I enable the MySQLi extension in PHP 7?
  12. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  13. Headers and client library minor version mismatch
  14. Advantages Of MySQLi over MySQL [closed]
  15. check if the query results empty row mysqli [duplicate]
  16. Is mysql_real_escape_string() necessary when using prepared statements?
  17. Updating from MYSQL to MYSQLI [duplicate]
  18. mysqli_stmt::execute() expects exactly 0 parameters, 1 given
  19. Mysqli throws “Warning: mysqli_stmt_bind_param() expects parameter 1 to be mysqli_stmt, boolean given” [duplicate]
  20. mysqli query results to show all rows
  21. mysqli_real_connect(): (HY000/2002): No such file or directory
  22. mysqli + xdebug breakpoint after closing statement result in many warnings
  23. INSERT query produces “Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given”
  24. php password_verify() hash and pass won’t match
  25. How to use mysqli_query() in PHP?
  26. PHP to MySQL SSL Connections
  27. Set character set using MySQLi
  28. Cannot figure out how to run a mysqli_multi_query and use the results from the last query
  29. How to get a list of databases?
  30. new mysqli(): how to intercept an ‘unable to connect’ error?

Leave a Comment