Helping ordinary people create extraordinary websites!


PEAR Manual
PrevNext

DB_common::freePrepared()

DB_common::freePrepared() -- Releases resources associated with a prepared SQL statement

Synopsis

boolean freePrepared (resource $stmt [, boolean $free_resource = true])

Description

Removes the memory occupied by the internal notations that keep track of prepared SQL statements. Does not delete the DB_result object itself.

Parameter

resource $stmt

statement resource identifier returned from prepare()

boolean $free_resource

should the PHP resource be freed too? Use false if you need to get data from the result set later.

Parameter available since Release 1.7.0.

Return value

boolean - Returns TRUE on success, FALSE on failure.

Note

This function can not be called statically.

Example

Example 39-1. Using freePrepared()

<?php
// Once you have a valid DB object named $db...
$sth = $db->prepare('INSERT INTO numbers (number) VALUES (?)');
$db->execute($sth, 1);
$db->freePrepared($sth);
?>

See

prepare(), autoPrepare(), free()

PrevHomeNext
DB_common::executeMultiple()UpDB_common::getAll()