sqlsrv_num_fields(3) [php man page]

SQLSRV_NUM_FIELDS(3)													      SQLSRV_NUM_FIELDS(3)

sqlsrv_num_fields - Retrieves the number of fields (columns) on a statement

SYNOPSIS

       mixed sqlsrv_num_fields (resource  $stmt)

DESCRIPTION

	Retrieves the number of fields (columns) on a statement.

PARAMETERS

	      o $stmt
		-  The	statment  for  which  the  number of fields is returned. sqlsrv_num_fields(3) can be called on a statement before or after
		statement execution.

RETURN VALUES

	Returns the number of fields on success. Returns FALSE otherwise.

EXAMPLES

       Example #1

	      sqlsrv_num_fields(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 = "SELECT * FROM Table_1";
	      $stmt = sqlsrv_query($conn, $sql);
	      if( $stmt === false) {
		 die( print_r( sqlsrv_errors(), true));
	      }

	      $numFields = sqlsrv_num_fields( $stmt );

	      while( sqlsrv_fetch( $stmt )) {
		 // Iterate through the fields of each row.
		 for($i = 0; $i < $numFields; $i++) {
		 {
		    echo sqlsrv_get_field($stmt, $i)." ";
		   }
		   echo "<br />";
	      }
	      ?>

SEE ALSO

       sqlsrv_field_metadata(3), sqlsrv_fetch(3), sqlsrv_get_field(3).

PHP Documentation Group 												      SQLSRV_NUM_FIELDS(3)

SQLSRV_CANCEL(3)														  SQLSRV_CANCEL(3)

sqlsrv_cancel - Cancels a statement

SYNOPSIS

       bool sqlsrv_cancel (resource  $stmt)

DESCRIPTION

	Cancels  a  statement.	Any results associated with the statement that have not been consumed are deleted. After sqlsrv_cancel(3) has been
       called, the specified statement can be re-executed if it was created with sqlsrv_prepare(3). Calling sqlsrv_cancel(3) is not  necessary	if
       all the results associated with the statement have been consumed.

PARAMETERS

	      o $stmt
		- The statement resource to be cancelled.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      sqlsrv_cancel(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 = "SELECT Sales FROM Table_1";

	      $stmt = sqlsrv_prepare( $conn, $sql);

	      if( $stmt === false ) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      if( sqlsrv_execute( $stmt ) === false) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      $salesTotal = 0;
	      $count = 0;

	      while( ($row = sqlsrv_fetch_array( $stmt)) && $salesTotal <=100000)
	      {
		   $qty = $row[0];
		   $price = $row[1];
		   $salesTotal += ( $price * $qty);
		   $count++;
	      }

	      echo "$count sales accounted for the first $$salesTotal in revenue.<br />";

	      // Cancel the pending results. The statement can be reused.
	      sqlsrv_cancel( $stmt);
	      ?>

NOTES

	The  main  difference between sqlsrv_cancel(3) and sqlsrv_free_stmt(3) is that a statement resource cancelled with sqlsrv_cancel(3) can be
       re-executed if it was created with sqlsrv_prepare(3). A statement resource cancelled with sqlsrv_free_statement(3) cannot be re-executed.

SEE ALSO

       sqlsrv_free_stmt(3), sqlsrv_prepare(3).

PHP Documentation Group 													  SQLSRV_CANCEL(3)