RE: [PHP-DB] Automattic Rollback on User Cancel with MySQL
| From: | John W. Holmes | Date: | Fri, 18 Oct 2002 12:23:09 +0000 |
| Subject: | RE: [PHP-DB] Automattic Rollback on User Cancel with MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22495@lists.php.net to get a copy of this message | ||
> 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 Rollback
and
> Commit. But when the user presses cancel in the browser or the script
> stops
> due to an error in the script all open transactions are committed
instead
> of 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...