From: cryogen at mac dot com Operating system: OSX Server 10.3.7 PHP version: 5.0.2 PHP Bug Type: Feature/Change Request Bug description: Add a BEGIN or START_TRANSACTION to mysqli
Description: ------------ I would like to suggest the addition of a START TRANSACTION or BEGIN method that would work along with the COMMIT and ROLLBACK methods already implemented in the mysqli class. It seems that the only examples using transactions always use $mysqli->autocommit(FALSE) in order to toggle autocommic on and off. It is not clear if this method turns autocommit on or off for the entire session, script, or just for the current transaction? Many of us prefer to leave autocommit on, and use the SQL commands"START TRANSACTION" or "BEGIN" which temporarily turn autocommit off for the current transaction. This seems a much cleaner way of performing transactions rather than turning off autocommit and then turning it back on for every transaction. Thanks for your consideration. -- Edit bug report at http://bugs.php.net/?id=31315&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31315&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=31315&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=31315&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=31315&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=31315&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=31315&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=31315&r=needscript Try newer version: http://bugs.php.net/fix.php?id=31315&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=31315&r=support Expected behavior: http://bugs.php.net/fix.php?id=31315&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=31315&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=31315&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=31315&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31315&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=31315&r=dst IIS Stability: http://bugs.php.net/fix.php?id=31315&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=31315&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=31315&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=31315&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=31315&r=mysqlcfg
