Commits the current transaction

Object-oriented style

public mysqli::commit(int $flags = 0, ?string $name = null): bool

Procedural style

mysqli_commit(mysqli $mysql, int $flags = 0, ?string $name = null): bool

Commits the current transaction for the database connection.

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 COMMIT/*name*/ is executed.

Returns true on success or false on failure.

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).

mysqli::commit