(PHP 5, PHP 7, PHP 8)
mysqli::rollback -- mysqli_rollback — Rolls back current transaction
Object-oriented style
public mysqli::rollback(int $flags = 0, ?string $name = null): bool
Procedural style
mysqli_rollback(mysqli $mysql, int $flags = 0, ?string $name = null): bool
Rollbacks the current transaction for the database.
mysql
Procedural style only: A mysqli object returned by mysqli_connect() or mysqli_init()
flags A bitmask of MYSQLI_TRANS_COR_* constants.
name If provided then ROLLBACK/*name*/ is executed.
If mysqli error reporting is enabled (MYSQLI_REPORT_ERROR) and the requested operation fails, a warning is generated. If, in addition, the mode is set to MYSQLI_REPORT_STRICT, a mysqli_sql_exception is thrown instead.
| Version | Description |
|---|---|
| 8.0.0 | name is now nullable. |
Note:
This function does not work with non transactional table types (like MyISAM or ISAM).
© 1997–2025 The PHP Documentation Group
Licensed under the Creative Commons Attribution License v3.0 or later.
https://www.php.net/manual/en/mysqli.rollback.php