note 128864 added to mysqli.rollback
| From: | YorickPhoenix at main dot php dot net | Date: | Thu, 07 Sep 2023 17:55:39 +0000 |
| Subject: | note 128864 added to mysqli.rollback | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-220825@lists.php.net to get a copy of this message | ||
If you use savepoints - eg savepoint($foo) - be wary of trying to rollback to the save point with
rollback(0, $foo) as that executes "ROLLBACK /* $foo */" instead of "ROLLBACK TO
$foo".
The manual page is clear about this, but is easily overlooked.
Instead use: $mysqli->query("ROLLBACK TO $foo");
----
Server IP: 45.112.84.4
Probable Submitter: 45.91.157.134 (proxied: 2a09:bac1:76a0:1ee8::1d3:89)
----
Manual Page -- https://php.net/manual/en/mysqli.rollback.php
Edit -- https://main.php.net/note/edit/128864
Del: integrated -- https://main.php.net/note/delete/128864/integrated
Del: useless -- https://main.php.net/note/delete/128864/useless
Del: bad code -- https://main.php.net/note/delete/128864/bad+code
Del: spam -- https://main.php.net/note/delete/128864/spam
Del: non-english -- https://main.php.net/note/delete/128864/non-english
Del: in docs -- https://main.php.net/note/delete/128864/in+docs
Del: other reasons-- https://main.php.net/note/delete/128864
Reject -- https://main.php.net/note/reject/128864
Search -- https://main.php.net/manage/user-notes.php