ibase_commit_ret(3) [php man page]

IBASE_COMMIT_RET(3)							 1						       IBASE_COMMIT_RET(3)

ibase_commit_ret - Commit a transaction without closing it

SYNOPSIS

       bool ibase_commit_ret NULL ([resource  $link_or_trans_identifier])

DESCRIPTION

	Commits a transaction without closing it.

PARAMETERS

	      o $link_or_trans_identifier
		-  If  called without an argument, this function commits the default transaction of the default link. If the argument is a connec-
		tion identifier, the default transaction of the corresponding connection will be committed. If the argument is a transaction iden-
		tifier,  the  corresponding  transaction  will be committed. The transaction context will be retained, so statements executed from
		within this transaction will not be invalidated.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

PHP Documentation Group 												       IBASE_COMMIT_RET(3)

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)