Re: Automattic Rollback on User Cancel with MySQL
| From: | Yasuo Ohgaki | Date: | Sat, 19 Oct 2002 02:38:06 +0000 |
| Subject: | Re: Automattic Rollback on User Cancel with MySQL | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22510@lists.php.net to get a copy of this message | ||
IIRC, someone added automatic rollback to MySQL from PHP 4.3.0 just
like PostgreSQL.
BTW, PostgreSQL module rollbacks uncommitted transaction automatically
from PHP3.
--
Yasuo Ohgaki
John W. Holmes wrote:
I Am using the latest PHP version 4.2.3 with MySQL 3.23.51-max. I use InnoDB tables for transactions and everything works fine with RollbackandCommit. But when the user presses cancel in the browser or the script stops due to an error in the script all open transactions are committedinsteadof rolled back. Is there some way to change this behavior ?Look at the Connection Handling functions in the manual. http://www.php.net/manual/en/features.connection-handling.php You can detect when the user has aborted the script (pressed cancel) and react accordingly. ---John Holmes...