Login or Register to Ask a Question and Join Our Community

Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

sqlsrv_fetch(3) [php man page]

SQLSRV_FETCH(3) 														   SQLSRV_FETCH(3)

sqlsrv_fetch - Makes the next row in a result set available for reading

SYNOPSIS

       mixed sqlsrv_fetch (resource  $stmt, [int  $row], [int  $offset])

DESCRIPTION

	Makes the next row in a result set available for reading. Use sqlsrv_get_field(3) to read the fields of the row.

PARAMETERS

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

	      o $row
		-  The	row  to  be accessed. This parameter can only be used if the specified statement was prepared with a scrollable cursor. In
		that case, this parameter can take on one of the following values:

		     oSQLSRV_SCROLL_NEXT

		     oSQLSRV_SCROLL_PRIOR

		     oSQLSRV_SCROLL_FIRST

		     oSQLSRV_SCROLL_LAST

		     oSQLSRV_SCROLL_ABSOLUTE

		     oSQLSRV_SCROLL_RELATIVE

	      o $offset
		- Specifies the row to be accessed if the row parameter is set to SQLSRV_SCROLL_ABSOLUTE or SQLSRV_SCROLL_RELATIVE. Note that  the
		first row in a result set has index 0.

RETURN VALUES

	Returns  TRUE  if the next row of a result set was successfully retrieved, FALSE if an error occurs, and NULL if there are no more rows in
       the result set.

EXAMPLES

       Example #1

	      sqlsrv_fetch(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_get_field(3), sqlsrv_fetch_array(3), sqlsrv_fetch_object(3).

PHP Documentation Group 													   SQLSRV_FETCH(3)

Check Out this Related Man Page

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)
Man Page