Documentation Home
MySQL PHP API
Download this Manual
PDF (US Ltr) - 2.4Mb
PDF (A4) - 2.4Mb
HTML Download (TGZ) - 251.4Kb
HTML Download (Zip) - 258.8Kb


MySQL PHP API  /  ...  /  mysqli::commit, mysqli_commit

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 name);

Procedural style

bool mysqli_commit(mysqli link,
                   int flags= =0,
                   string name);

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

Examples

See the mysqli::begin_transaction example.

See Also

mysqli_autocommit
mysqli_begin_transaction
mysqli_rollback
mysqli_savepoint