cubrid_close_prepare(3) [php man page]

CUBRID_CLOSE_PREPARE(3) 						 1						   CUBRID_CLOSE_PREPARE(3)

cubrid_close_prepare - Close the request handle

SYNOPSIS

       bool cubrid_close_prepare (resource  $req_identifier)

DESCRIPTION

	The  cubrid_close_prepare(3)  function	closes	the  request  handle given by the $req_identifier argument, and releases the memory region
       related to the handle. It is an alias of cubrid_close_request(3).

PARAMETERS

	      o $req_identifier
		-Request identifier.

RETURN VALUES

	Return TRUE on success.

EXAMPLES

       Example #1

	      cubrid_close_prepare(3) example

	      <?php
	      $con = cubrid_connect ("localhost", 33000, "demodb", "dba", "");
	      if ($con) {
		 echo "connected successfully";
		 $req = cubrid_execute ( $con, "select * from members",
					 CUBRID_INCLUDE_OID | CUBRID_ASYNC);
		 if ($req) {
		    while ( list ($id, $name) = cubrid_fetch ($req) ){
		       echo $id;
		       echo $name;
		    }
		    cubrid_close_prepare($req); // or you can use cubrid_close_request($req)
		 }
		 cubrid_disconnect($con);
	      }
	      ?>

SEE ALSO

       cubrid_close_request(3).

PHP Documentation Group 												   CUBRID_CLOSE_PREPARE(3)

CUBRID_FREE_RESULT(3)							 1						     CUBRID_FREE_RESULT(3)

cubrid_free_result - Free the memory occupied by the result data

SYNOPSIS

       bool cubrid_free_result (resource  $req_identifier)

DESCRIPTION

	This  function	frees  the memory occupied by the result data. It returns TRUE on success or FALSE on failure. Note that it can only frees
       the client fetch buffer now, and if you want free all memory, use function cubrid_close_request(3).

PARAMETERS

	      o $req_identifier
		-This is the request identifier.

RETURN VALUES

       TRUE on success.

       FALSE on failure.

EXAMPLES

       Example #1

	      cubrid_free_result(3) example

	      <?php
	      $conn = cubrid_connect("localhost", 33000, "demodb");

	      $req = cubrid_execute($conn, "SELECT * FROM history WHERE host_year=2004 ORDER BY event_code");
	      $row = cubrid_fetch_assoc($req);
	      var_dump($row);

	      cubrid_free_result($req);
	      cubrid_close_request($req);
	      cubrid_disconnect($conn);
	      ?>

	      The above example will output:

	      array(5) {
		["event_code"]=>
		string(5) "20005"
		["athlete"]=>
		string(12) "Hayes Joanna"
		["host_year"]=>
		string(4) "2004"
		["score"]=>
		string(5) "12.37"
		["unit"]=>
		string(4) "time"
	      }

PHP Documentation Group 												     CUBRID_FREE_RESULT(3)