sqlsrv_free_stmt(3) [php man page]

SQLSRV_FREE_STMT(3)													       SQLSRV_FREE_STMT(3)

sqlsrv_free_stmt - Frees all resources for the specified statement

SYNOPSIS

       bool sqlsrv_free_stmt (resource	$stmt)

DESCRIPTION

	Frees  all  resources  for  the specified statement. The statement cannot be used after sqlsrv_free_stmt(3) has been called on it. If sql-
       srv_free_stmt(3) is called on an in-progress statement that alters server state, statement execution is terminated  and	the  statement	is
       rolled back.

PARAMETERS

	      o $stmt
		-  The	statment  for  which resources are freed. Note that NULL is a valid parameter value. This allows the function to be called
		multiple times in a script.

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      sqlsrv_free_stmt(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));
	      }

	      $stmt = sqlsrv_query( $conn, "SELECT * FROM Table_1");
	      if( $stmt === false ) {
		   die( print_r( sqlsrv_errors(), true));
	      }

	      /*-------------------------------
		   Process query results here.
	      -------------------------------*/

	      /* Free the statement resources. */
	      sqlsrv_free_stmt( $stmt);

	      ?>

NOTES

	The main difference between sqlsrv_free_stmt(3) and sqlsrv_cancel(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_cancel(3).

PHP Documentation Group 												       SQLSRV_FREE_STMT(3)

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)