MYSQLND_MS_XA_COMMIT(3) 1 MYSQLND_MS_XA_COMMIT(3)mysqlnd_ms_xa_commit - Commits a distributed/XA transaction among MySQL servers
SYNOPSIS
int mysqlnd_ms_xa_commit (mixed $connection, string $gtrid)
DESCRIPTION
Commits a global transaction among MySQL servers started by mysqlnd_ms_xa_begin(3).
If any of the global transaction participants fails to commit an implicit rollback is performed. It may happen that not all cases can be
handled during the rollback. For example, no attempts will be made to reconnect to a participant after the connection to the participant
has been lost. Solving cases that cannot easily be rolled back is left to the garbage collection.
Note
Experimental
The feature is currently under development. There may be issues and/or feature limitations. Do not use in production environments.
PARAMETERS
o $connection
- A MySQL connection handle obtained from any of the connect functions of the mysqli, mysql or PDO_MYSQL extensions.
o $gtrid
- Global transaction identifier (gtrid).
RETURN VALUES
Returns TRUE if the global transaction has been committed. Otherwise, returns FALSE
SEE ALSO
Quickstart XA/Distributed transactions, Runtime configuration, mysqlnd_ms_get_stats(3).
PHP Documentation Group MYSQLND_MS_XA_COMMIT(3)
Check Out this Related Man Page
SQLSRV_COMMIT(3)SQLSRV_COMMIT(3)sqlsrv_commit - Commits a transaction that was begun withsqlsrv_begin_transaction(3)SYNOPSIS
bool sqlsrv_commit (resource $conn)
DESCRIPTION
Commits a transaction that was begun with sqlsrv_begin_transaction(3). The connection is returned to auto-commit mode after sqlsrv_com-
mit(3) is called. The transaction that is committed includes all statements that were executed after the call to sqlsrv_begin_transac-
tion(3). Explicit transactions should be started and committed or rolled back using these functions instead of executing SQL statements
that begin and committ/roll back transactions. For more information, see SQLSRV Transactions.
PARAMETERS
o $conn
- The connection on which the transaction is to be committed.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
sqlsrv_commit(3) example
The following example demonstrates how to use sqlsrv_commit(3) together with sqlsrv_begin_transaction(3) and sqlsrv_rollback(3).
<?php
$serverName = "serverNamesqlexpress";
$connectionInfo = array( "Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn === false ) {
die( print_r( sqlsrv_errors(), true ));
}
/* Begin the transaction. */
if ( sqlsrv_begin_transaction( $conn ) === false ) {
die( print_r( sqlsrv_errors(), true ));
}
/* Initialize parameter values. */
$orderId = 1; $qty = 10; $productId = 100;
/* Set up and execute the first query. */
$sql1 = "INSERT INTO OrdersTable (ID, Quantity, ProductID)
VALUES (?, ?, ?)";
$params1 = array( $orderId, $qty, $productId );
$stmt1 = sqlsrv_query( $conn, $sql1, $params1 );
/* Set up and execute the second query. */
$sql2 = "UPDATE InventoryTable
SET Quantity = (Quantity - ?)
WHERE ProductID = ?";
$params2 = array($qty, $productId);
$stmt2 = sqlsrv_query( $conn, $sql2, $params2 );
/* If both queries were successful, commit the transaction. */
/* Otherwise, rollback the transaction. */
if( $stmt1 && $stmt2 ) {
sqlsrv_commit( $conn );
echo "Transaction committed.<br />";
} else {
sqlsrv_rollback( $conn );
echo "Transaction rolled back.<br />";
}
?>
SEE ALSO sqlsrv_begin_transaction(3), sqlsrv_rollback(3).
PHP Documentation Group SQLSRV_COMMIT(3)