Re: Mysql and rollbacks
| From: | John W. Holmes | Date: | Tue, 13 Jul 2004 15:27:34 +0000 |
| Subject: | Re: Mysql and rollbacks | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-35221@lists.php.net to get a copy of this message | ||
Peter Westergaard wrote:
I'm developing a site where I anticipate the need to make several updates to several forms, and I'll want to "commit" them all at once (i.e. if there's a failure with any of the transactions, I'd like to be able to back out to before I started). Is there a decent way to do this with PHP and Mysql?Use InnoDB tables which have transaction support. Or use a database abstraction layer that simulates transactions such as ADOdb: http://phplens.com/adodb/tutorial.smart.transactions.html -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com