Delicious Bookmark this on Delicious Share on Facebook SlashdotSlashdot It! Digg! Digg



PHP : Function Reference : Firebird/InterBase Functions : ibase_close

ibase_close

Close a connection to an InterBase database (PHP 4, PHP 5)
bool ibase_close ( [resource connection_id] )


Code Examples / Notes » ibase_close

php dot planetmirror dot com

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


Change Language


Follow Navioo On Twitter
ibase_add_user
ibase_affected_rows
ibase_backup
ibase_blob_add
ibase_blob_cancel
ibase_blob_close
ibase_blob_create
ibase_blob_echo
ibase_blob_get
ibase_blob_import
ibase_blob_info
ibase_blob_open
ibase_close
ibase_commit_ret
ibase_commit
ibase_connect
ibase_db_info
ibase_delete_user
ibase_drop_db
ibase_errcode
ibase_errmsg
ibase_execute
ibase_fetch_assoc
ibase_fetch_object
ibase_fetch_row
ibase_field_info
ibase_free_event_handler
ibase_free_query
ibase_free_result
ibase_gen_id
ibase_maintain_db
ibase_modify_user
ibase_name_result
ibase_num_fields
ibase_num_params
ibase_param_info
ibase_pconnect
ibase_prepare
ibase_query
ibase_restore
ibase_rollback_ret
ibase_rollback
ibase_server_info
ibase_service_attach
ibase_service_detach
ibase_set_event_handler
ibase_timefmt
ibase_trans
ibase_wait_event
eXTReMe Tracker