Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2004071

Re: [PHP-DB] Mysql and rollbacks From: John W. Holmes (holmes072000 <email protected>)
Date: 07/13/04

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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php