sqlsrv_get_field(3) [php 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)

SQLSRV_EXECUTE(3)														 SQLSRV_EXECUTE(3)

sqlsrv_execute - Executes a statement prepared withsqlsrv_prepare(3)

SYNOPSIS

       bool sqlsrv_execute (resource  $stmt)

DESCRIPTION

	Executes  a  statement prepared with sqlsrv_prepare(3). This function is ideal for executing a prepared statement multiple times with dif-
       ferent parameter values.

PARAMETERS

	      o $stmt
		- A statement resource returned by sqlsrv_prepare(3).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      sqlsrv_execute(3) example

	       This example demonstrates how to prepare a statement with sqlsrv_prepare(3) and re-execute it multiple times (with different param-
	      eter values) using sqlsrv_execute(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 = "UPDATE Table_1
		      SET OrderQty = ?
		      WHERE SalesOrderID = ?";

	      // Initialize parameters and prepare the statement.
	      // Variables $qty and $id are bound to the statement, $stmt.
	      $qty = 0; $id = 0;
	      $stmt = sqlsrv_prepare( $conn, $sql, array( &$qty, &$id));
	      if( !$stmt ) {
		  die( print_r( sqlsrv_errors(), true));
	      }

	      // Set up the SalesOrderDetailID and OrderQty information.
	      // This array maps the order ID to order quantity in key=>value pairs.
	      $orders = array( 1=>10, 2=>20, 3=>30);

	      // Execute the statement for each order.
	      foreach( $orders as $id => $qty) {
		  // Because $id and $qty are bound to $stmt1, their updated
		  // values are used with each execution of the statement.
		  if( sqlsrv_execute( $stmt ) === false ) {
			die( print_r( sqlsrv_errors(), true));
		  }
	      }
	      ?>

NOTES

	When  you  prepare  a statement that uses variables as parameters, the variables are bound to the statement. This means that if you update
       the values of the variables, the next time you execute the statement it will run with updated parameter values.	For  statements  that  you
       plan to execute only once, use sqlsrv_query(3).

SEE ALSO

       sqlsrv_prepare(3), sqlsrv_query(3).

PHP Documentation Group 													 SQLSRV_EXECUTE(3)