sqlsrv_has_rows(3) [php man page]

SQLSRV_HAS_ROWS(3)														SQLSRV_HAS_ROWS(3)

sqlsrv_has_rows - Indicates whether the specified statement has rows

SYNOPSIS

       bool sqlsrv_has_rows (resource  $stmt)

DESCRIPTION

	Indicates whether the specified statement has rows.

PARAMETERS

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

RETURN VALUES

	Returns TRUE if the specified statement has rows and FALSE if the statement does not have rows or if an error occurred.

EXAMPLES

       Example #1

	      sqlsrv_has_rows(3) example

	      <?php
	      $server = "serverNamesqlexpress";
	      $connectionInfo = array( "Database"=>"dbName", "UID"=>"username", "PWD"=>"password" )
	      $conn = sqlsrv_connect( $server, $connectionInfo );

	      $stmt = sqlsrv_query( $conn, "SELECT * FROM Table_1");

	      if ($stmt) {
		 $rows = sqlsrv_has_rows( $stmt );
		 if ($rows === true)
		    echo "There are rows. <br />";
		 else
		    echo "There are no rows. <br />";
	      }
	      ?>

SEE ALSO

       sqlsrv_num_rows(3), sqlsrv_query(3).

PHP Documentation Group 													SQLSRV_HAS_ROWS(3)

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)