sqlsrv_next_result(3) [php man page]

SQLSRV_NEXT_RESULT(3)													     SQLSRV_NEXT_RESULT(3)

sqlsrv_next_result - Makes the next result of the specified statement active

SYNOPSIS

       mixed sqlsrv_next_result (resource  $stmt)

DESCRIPTION

	Makes the next result of the specified statement active. Results include result sets, row counts, and output parameters.

PARAMETERS

	      o $stmt
		- The statment on which the next result is being called.

RETURN VALUES

	Returns TRUE if the next result was successfully retrieved, FALSE if an error occurred, and NULL if there are no more results to retrieve.

EXAMPLES

       Example #1

	      sqlsrv_next_result(3) example

	       The  following  example executes a batch query that inserts into a table and then selects from the table. This produces two results
	      on the statement: one for the rows affected by the INSERT and one for the rows returned by the SELECT. To get to the  rows  returned
	      by the SELECT, sqlsrv_next_result(3) must be called to move past the first result.

	      <?php
	      $serverName = "serverNamesqlexpress";
	      $connectionInfo = array("Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);

	      $query = "INSERT INTO Table_1 (id, data) VALUES (?,?); SELECT * FROM TABLE_1;";
	      $params = array(1, "some data");
	      $stmt = sqlsrv_query($conn, $query, $params);

	      // Consume the first result (rows affected by INSERT) without calling sqlsrv_next_result.
	      echo "Rows affected: ".sqlsrv_rows_affected($stmt)."<br />";

	      // Move to the next result and display results.
	      $next_result = sqlsrv_next_result($stmt);
	      if( $next_result ) {
		 while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)){
		    echo $row['id'].": ".$row['data']."<br />";
		 }
	      } elseif( is_null($next_result)) {
		   echo "No more results.<br />";
	      } else {
		   die(print_r(sqlsrv_errors(), true));
	      }
	      ?>

SEE ALSO

       sqlsrv_query(3), sqlsrv_fetch_array(3), sqlsrv_rows_affected(3).

PHP Documentation Group 												     SQLSRV_NEXT_RESULT(3)

SQLSRV_GET_FIELD(3)													       SQLSRV_GET_FIELD(3)

sqlsrv_get_field - Gets field data from the currently selected row

SYNOPSIS

       mixed sqlsrv_get_field (resource  $stmt, int  $fieldIndex, [int	$getAsType])

DESCRIPTION

	Gets field data from the currently selected row. Fields must be accessed in order. Field indices start at 0.

PARAMETERS

	      o $stmt
		- A statement resource returned by sqlsrv_query(3) or sqlsrv_execute(3).

	      o $fieldIndex
		-  The	index  of  the field to be retrieved. Field indices start at 0. Fields must be accessed in order. i.e. If you access field
		index 1, then field index 0 will not be available.

	      o $getAsType
		- The PHP data type for the returned field data. If this parameter is not set, the field data will be returned as its default  PHP
		data type. For information about default PHP data types, see Default PHP Data Types in the Microsoft SQLSRV documentation.

RETURN VALUES

	Returns data from the specified field on success. Returns FALSE otherwise.

EXAMPLES

       Example #1

	      sqlsrv_get_field(3) example

	       The following example demonstrates how to retrieve a row with sqlsrv_fetch(3) and get the row fields with sqlsrv_get_field(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));
	      }

	      $sql = "SELECT Name, Comment
		      FROM Table_1
		      WHERE ReviewID=1";
	      $stmt = sqlsrv_query( $conn, $sql);
	      if( $stmt === false ) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      // Make the first (and in this case, only) row of the result set available for reading.
	      if( sqlsrv_fetch( $stmt ) === false) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      // Get the row fields. Field indeces start at 0 and must be retrieved in order.
	      // Retrieving row fields by name is not supported by sqlsrv_get_field.
	      $name = sqlsrv_get_field( $stmt, 0);
	      echo "$name: ";

	      $comment = sqlsrv_get_field( $stmt, 1);
	      echo $comment;
	      ?>

SEE ALSO

       sqlsrv_fetch(3), sqlsrv_fetch_array(3), sqlsrv_fetch_object(3).

PHP Documentation Group 												       SQLSRV_GET_FIELD(3)