3.8.7 mysqli::commit, mysqli_commit

Copyright 1997-2022 the PHP Documentation Group.

• mysqli::commit

  mysqli_commit

  Commits the current transaction

Description

Object-oriented style

public bool mysqli::commit(int flags= =0,
                           string|null name= =null);

Procedural style

bool mysqli_commit(mysqli mysql,
                   int flags= =0,
                   string|null 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.

Changelog

Version	Description
8.0.0	name is now nullable.

Examples

See the mysqli::begin_transaction example.

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