sqlsrv_rollback(3) [php man page]

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)

Check Out this Related Man Page

SQLSRV_ROWS_AFFECTED(3) 												   SQLSRV_ROWS_AFFECTED(3)

sqlsrv_rows_affected - Returns the number of rows modified by the last INSERT, UPDATE, or DELETE query executed

SYNOPSIS

       int sqlsrv_rows_affected (resource  $stmt)

DESCRIPTION

	Returns  the  number  of  rows	modified  by  the  last INSERT, UPDATE, or DELETE query executed. For information about the number of rows
       returned by a SELECT query, see sqlsrv_num_rows(3).

PARAMETERS

	      o $stmt
		- The executed statement resource for which the number of affected rows is returned.

RETURN VALUES

	Returns the number of rows affected by the last INSERT, UPDATE, or DELETE query. If no rows were affected, 0 is returned. If the number of
       affected rows cannot be determined, -1 is returned. If an error occurred, FALSE is returned.

EXAMPLES

       Example #1

	      sqlsrv_rows_affected(3) example

	      <?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));
	      }

	      $sql = "UPDATE Table_1 SET data = ? WHERE id = ?";

	      $params = array("updated data", 1);

	      $stmt = sqlsrv_query( $conn, $sql, $params);

	      $rows_affected = sqlsrv_rows_affected( $stmt);
	      if( $rows_affected === false) {
		   die( print_r( sqlsrv_errors(), true));
	      } elseif( $rows_affected == -1) {
		    echo "No information available.<br />";
	      } else {
		    echo $rows_affected." rows were updated.<br />";
	      }
	      ?>

SEE ALSO

       sqlsrv_num_rows(3).

PHP Documentation Group 												   SQLSRV_ROWS_AFFECTED(3)

Linux and UNIX Man Pages

sqlsrv_rollback(3) [php man page]

Check Out this Related Man Page