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)