Documentation Home
Connectors and APIs Manual
Download this Manual

Connectors and APIs Manual  /  ...  /  mysqli::commit, mysqli_commit

7.3.8.7 mysqli::commit, mysqli_commit

Copyright 1997-2021 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

link

Procedural style only: A link identifier 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.

Notes
Note

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

Changelog

VersionDescription
8.0.0name is now nullable.

Examples

See the mysqli::begin_transaction example.

See Also

mysqli_autocommit
mysqli_begin_transaction
mysqli_rollback
mysqli_savepoint