PHP: 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 в случае возникновения ошибки.

ibase_close

php dot planetmirror dot com at issystems dot co dot nz
22-Dec-2004 01:38


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);

02-Apr-2002 03: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);