Req #31838 [Opn->Bgs]: enable mysql transactions per session instead per script

Edit report at http://bugs.php.net/bug.php?id=31838&edit=1 ID: 31838 Updated by: johannes@php.net Reported by: php at zion-it dot com Summary: enable mysql transactions per session instead per script -Status: Open +Status: Bogus Type: Feature/Change Request -Package: Feature/Change Request +Package: *General Issues Operating System: redhat PHP Version: 4.3.10 Block user comment: N Private report: N New Comment: This would at first be a feature request for the MySQL server to be ale to use a transaction with different connections as there is no way for PHP to guarantee that you hit the same web server child with the same connection again. Previous Comments: ------------------------------------------------------------------------ [2005-02-04 00:56:39] php at zion-it dot com Description: ------------ You should be able to keep a database connection open (like persistent connections) and execute transactions for mysql in another script for that specific mysql user and ip address. At the moment might apache create a new child process for a new http request and that makes it impossible to reuse the open database connection, because this new apache child process creates also a new database connection. The idea is that you can insert/delete/update in the mysql database and check the consequences in related scripts. When you do not like that, then you should be able to rollback and otherwise commit. Expected result: ---------------- Full control of keeping database connections open and reuse them. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/bug.php?id=31838&edit=1