PHP Mysqli::commit() Method: Usage and Examples

Commits the transaction currently active on the MySQL connection.

The examples focus on the operation itself, including the important distinction: rollback discards pending transactional changes.

What It Does

Use the examples below to observe the behavior on a small dataset before extending it to application code.

Syntax and Return Value

Mysqli::commit(...) — requires the corresponding optional extension

The displayed signature describes the API or identifies any correction or optional dependency. When a parameter is optional, supply it only when the task requires it.

Example 1: Basic Use

Examples assume a demo database containing users(id, email, active), products(id, name, price), and orders(id, user_id, total) as required by the query.

<?php
$mysqli = new mysqli(getenv('DB_HOST') ?: '127.0.0.1', getenv('DB_USER') ?: 'app', getenv('DB_PASSWORD') ?: '', getenv('DB_NAME') ?: 'demo');
$mysqli->set_charset('utf8mb4');
$selectedId = 7;
$mysqli->begin_transaction();
$mysqli->query("UPDATE users SET active = 1 WHERE id = " . (int) 7);
$mysqli->commit();

This example is meant for a configured application environment; output depends on the installed extension, external service, or database contents.

Example 2: Checking Behavior

Examples assume a demo database containing users(id, email, active), products(id, name, price), and orders(id, user_id, total) as required by the query.

<?php
$mysqli = new mysqli(getenv('DB_HOST') ?: '127.0.0.1', getenv('DB_USER') ?: 'app', getenv('DB_PASSWORD') ?: '', getenv('DB_NAME') ?: 'demo');
$mysqli->set_charset('utf8mb4');
$selectedId = 12;
$mysqli->begin_transaction();
$mysqli->query("UPDATE users SET active = 1 WHERE id = " . (int) 12);
$mysqli->commit();

This example is meant for a configured application environment; output depends on the installed extension, external service, or database contents.

Example 3: Practical Example

Examples assume a demo database containing users(id, email, active), products(id, name, price), and orders(id, user_id, total) as required by the query.

<?php
$mysqli = new mysqli(getenv('DB_HOST') ?: '127.0.0.1', getenv('DB_USER') ?: 'app', getenv('DB_PASSWORD') ?: '', getenv('DB_NAME') ?: 'demo');
$mysqli->set_charset('utf8mb4');
$selectedId = 24;
$mysqli->begin_transaction();
$mysqli->query("UPDATE users SET active = 1 WHERE id = " . (int) 24);
$mysqli->commit();

This example is meant for a configured application environment; output depends on the installed extension, external service, or database contents.

Important Behavior and Edge Cases

Only transactional statements on supported engines can be rolled back before commit.

This API is supplied by an optional extension that is not installed in the local test runtime, or requires a different PHP version. The example must be verified in a matching environment.

Comparison with Related Approaches

Common Beginner Mistakes

Key Takeaways

• Commits the transaction currently active on the MySQL connection.
• Only transactional statements on supported engines can be rolled back before commit.
• rollback discards pending transactional changes.

Use Mysqli::commit when its documented behavior matches the problem. Test the relevant edge cases in your own runtime before deploying it.