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
(PHP 4, PHP 5)
ibase_close — Close a connection to an InterBase database
说明
bool ibase_close
([ resource $connection_id
] )
Closes the link to an InterBase database that's associated with a connection id returned from ibase_connect(). Default transaction on link is committed, other transactions are rolled back.
参数
- connection_id
-
An InterBase link identifier returned from ibase_connect(). If omitted, the last opened link is assumed.
返回值
如果成功则返回 TRUE,失败则返回 FALSE。
ibase_close
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);
