Firebird 2.0
PHP5 Programming
Manual

FBIRD_FREE_QUERY

Purpose

Use the fbird_free_query function to release the resouces related to a prepared query.

Syntax

<free_query> ::=
   fbird_free_query( qry_hndl )


Element 
Type
Description
qry_hndl
resource
A valid query handle
<return>
bool
True on success, False on failure

Semantics

The fbird_free_query function releases the resources used by a prepared query returned from fbird_prepare. After a query has been released it can no longer be used by fbird_execute.

This function returns True on success or False on failure

Example

The below example prepares an update query and excutes it three times, using differet parameters on each invocation:

$conn = fbird_connect($host, $username, $password);
$updates = array(1001 => 'Eric', 1005 => 'Filip', 1007 => 'Larry');
$qry = fbird_prepare($conn, "UPDATE STAFF SET name=? WHERE id=?");
foreach ($updates as $id => $name) {
   fbird_execute($qry, $id, $name);
}
fbird_free_query( $qry);



See also

fbird_prepare, fbird_execute


previous page goto index next page

Legal information