SQLSRV_BEGIN_TRANSACTION(3)											       SQLSRV_BEGIN_TRANSACTION(3)

sqlsrv_begin_transaction - Begins a database transaction

SYNOPSIS

       bool sqlsrv_begin_transaction (resource	$conn)

DESCRIPTION

	The  transaction  begun  by sqlsrv_begin_transaction(3) includes all statements that were executed after the call to sqlsrv_begin_transac-
       tion(3) and before calls to sqlsrv_rollback(3) or sqlsrv_commit(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 resource returned by a call to sqlsrv_connect(3).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      sqlsrv_begin_transaction(3) example

	       The following example demonstrates how to use sqlsrv_begin_transaction(3) together with sqlsrv_commit(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 />";
	      }
	      ?>

	      The above example will output something similar to:

SEE ALSO

       sqlsrv_commit(3), sqlsrv_rollback(3).

PHP Documentation Group 											       SQLSRV_BEGIN_TRANSACTION(3)