mysqli::commit

mysqli_commit

Commits the current transaction

Description

Object-oriented style

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

Procedural style

bool mysqli_commit(mysqli $mysql, int $flags = 0, stringnull $name = null)

Commits the current transaction for the database connection.

Parameters

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.

Return Values

Returns true on success or false on failure.

Errors/Exceptions

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.

Changelog

Version Description
8.0.0 name is now nullable.

Notes

Note:

This function does not work with non transactional table types (like MyISAM or ISAM).

See Also

  • mysqli_autocommit
  • mysqli_begin_transaction
  • mysqli_rollback
  • mysqli_savepoint