Re: mysqli auto rollback on script termination

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Martin Koch Andersen wrote:
Hi,

In case the PHP script dies (from fatal error, die() or similar), is any started transaction (BEGIN TRANSACTION) automatically rolled back (ROLLBACK) by PHP then?

It should be rolled back when a connection is lost or a transaction isn't explicitly committed.

Whether that's a php script dying or the server being shut down mid-transaction or anything similar (eg a remote server's lan connection goes down).

Of course this assumes you're using innodb tables and not myisam - myisam doesn't support transactions..

--
Postgresql & php tutorials
http://www.designmagick.com/

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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux