mssql_free_statement(3) [php man page]

MSSQL_FREE_STATEMENT(3) 												   MSSQL_FREE_STATEMENT(3)

mssql_free_statement - Free statement memory

SYNOPSIS

       bool mssql_free_statement (resource  $stmt)

DESCRIPTION

       mssql_free_statement(3)	only needs to be called if you are worried about using too much memory while your script is running. All statement
       memory will automatically be freed when the script ends. You may call mssql_free_statement(3) with the statement identifier as an  argument
       and the associated statement memory will be freed.

PARAMETERS

	      o $stmt
		- Statement resource, obtained with mssql_init(3).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      mssql_free_statement(3) example

	      <?php
	      // Create a new statement
	      $stmt = mssql_init('test');

	      // Bind values here and execute the statement

	      // once we're done, we clear it from the memory
	      // using mssql_free_statement like so:
	      mssql_free_statement($stmt);
	      ?>

SEE ALSO

       mssql_bind(3), mssql_execute(3), mssql_init(3), mssql_free_result(3).

PHP Documentation Group 												   MSSQL_FREE_STATEMENT(3)

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)