php man page for sqlsrv_free_stmt

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)