SQLSRV_ROLLBACK(3)														SQLSRV_ROLLBACK(3)

sqlsrv_rollback - Rolls back a transaction that was begun withsqlsrv_begin_transaction(3)

SYNOPSIS

       bool sqlsrv_rollback (resource  $conn)

DESCRIPTION

	Rolls back a transaction that was begun with sqlsrv_begin_transaction(3) and returns the connection to auto-commit mode.

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_rollback(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 />";
	      }
	      ?>

SEE ALSO

       sqlsrv_begin_transaction(3), sqlsrv_commit(3).

PHP Documentation Group 													SQLSRV_ROLLBACK(3)