KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I'm using PHP's mysqli library. Database inserts and updates are always in a try-catch block. Success of each query is checked immediately ( if $result === false ), and any failure throws an exception. The catch calls mysqli_rollback() and exits with a message for the user. My question is, should I bother checking the return value of mysqli_rollback() ? If so, and rollback fails, what actions should the code take? I have a hard time understanding how a rollback could fail (barring some atrocious bug in MySQL). And since PHP is going to exit anyway, calling rollback almost seems superfluous. I certainly think it should be in the code for clarity, but when PHP exits it will close the connection to MySQL and uncommitted transactions are rolled back automatically.
Tags (comma-separated)
Save Edits
Cancel