go to bug id or search bugs for
Using autocommit(FALSE) on a mysqli object does not turn autocommit off. There is more information at the URL listed under "Reproduce code."
I expect the result to be "Autocommit is 1 Autocommit is 0".
The actual result is "Autocommit is 1 Autocommit is 1".
Add a Patch
Add a Pull Request
Please try using this CVS snapshot:
Works just fine here.
I do not have a Sun machine at home, and I am unable to make this request at my place of work at the moment. For now, I'll use the work-around of mysqli->query('set autocommit = 0').
I was fairly certain this wasn't a bug since it worked in Windows; however, my search for why this was happening turned up empty handed. Is there anything in the php.ini, my.cnf, or configure that might affect autocommit, or does mysqli work "out of the box"?
Thanks for your time.
This bug has been fixed in CVS.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
Thank you for the report, and for helping us make PHP better.