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

Extend this topic - Post a comment