In the preceding note,
$sth = ibase_query($dbh, $stmt);
^^^^ this is a query (or statement handle)
while ($row = ibase_fetch_object($sth)) {
^^^^ this is a result
So the end is wrong, because $sth isn't a result
ibase_free_result($sth); // <-------
ibase_close($dbh);
It should really read as follows:
ibase_free_result($row);
ibase_free_query($sth);
ibase_close($dbh);
ibase_close
Description
bool ibase_close ( [resource connection_id] )Closes the link to an InterBase database that's associated with a connection id returned from ibase_connect(). If the connection id is omitted, the last opened link is assumed. Default transaction on link is committed, other transactions are rolled back. 如果成功则返回 TRUE，失败则返回 FALSE。
See also ibase_connect() and ibase_pconnect().
add a note
User Contributed Notes
php dot planetmirror dot com at issystems dot co dot nz
23-Dec-2004 05:38
23-Dec-2004 05:38
02-Apr-2002 07:18
Before close the connection remember to free your query results too...
$dbh = ibase_connect($host, $username, $password);
$stmt = 'SELECT * FROM tblname';
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {
.............
}
ibase_free_result($sth); // <-------
ibase_close($dbh);