PHP ibase_close函数代码示例

 /**
  * Close sql connection
  * @access: private
  */
 function _sql_close()
 {
     return @ibase_close($this->db_connect_id);
 }

 /**
  *@package db_firebird
  *@method close()
  *@desc Close Firebird/Interbase connection
  *@since v0.3.1
  * */
 public function close()
 {
     if (self::$is_connected) {
         ibase_close();
         self::$is_connected = false;
     }
 }

 /**
  * Disconnect
  *
  * @return  bool success
  */
 public function close()
 {
     if ($this->handle && ($r = ibase_close($this->handle))) {
         $this->handle = NULL;
         return $r;
     }
     return FALSE;
 }

 function Close()
 {
     if ($this->connection != 0) {
         if (!$this->auto_commit && $this->transaction_id) {
             ibase_rollback($this->transaction_id);
             $this->transaction_id = 0;
         }
         ibase_close($this->connection);
         $this->connection = 0;
         $this->affected_rows = -1;
     }
 }

 function sql_close()
 {
     if (!$this->db_connect_id) {
         return false;
     }
     if ($this->transaction) {
         @ibase_commit($this->db_connect_id);
     }
     if (sizeof($this->open_queries)) {
         foreach ($this->open_queries as $i_query_id => $query_id) {
             @ibase_free_query($query_id);
         }
     }
     return @ibase_close($this->db_connect_id);
 }

 function DBAQuery(&$db, $database_file, $query)
 {
     if (!function_exists("ibase_connect")) {
         return $db->SetError("DBA query", "Interbase support is not available in this PHP configuration");
     }
     if (!isset($db->options[$option = "DBAUser"]) || !isset($db->options[$option = "DBAPassword"])) {
         return $db->SetError("DBA query", "it was not specified the Interbase {$option} option");
     }
     $database = $db->host . (strcmp($database_file, "") ? ":" . $database_file : "");
     if (($connection = @ibase_connect($database, $db->options["DBAUser"], $db->options["DBAPassword"])) <= 0) {
         return $db->SetError("DBA query", "Could not connect to Interbase server ({$database}): " . ibase_errmsg());
     }
     if (!($success = @ibase_query($connection, $query))) {
         $db->SetError("DBA query", "Could not execute query ({$query}): " . ibase_errmsg());
     }
     ibase_close($connection);
     return $success;
 }

<?php

$host = 'localhost:/path/to/your.gdb';
$dbh = ibase_connect($host, $username, $password);
$stmt = 'SELECT * FROM tblname';
$sth = ibase_query($dbh, $stmt);
while ($row = ibase_fetch_object($sth)) {
    echo $row->email, "\n";
}
ibase_free_result($sth);
ibase_close($dbh);

 /**
  * Disconnects from a database.
  * @return void
  */
 public function disconnect()
 {
     ibase_close($this->connection);
 }

function sql_logout($id)
{
    global $dbtype;
    switch ($dbtype) {
        case "MySQL":
            $dbi = @mysql_close($id);
            return $dbi;
            break;
        case "mSQL":
            $dbi = @msql_close($id);
            return $dbi;
            break;
        case "postgres":
        case "postgres_local":
            $dbi = @pg_close($id);
            return $dbi;
            break;
        case "ODBC":
        case "ODBC_Adabas":
            $dbi = @odbc_close($id);
            return $dbi;
            break;
        case "Interbase":
            $dbi = @ibase_close($id);
            return $dbi;
            break;
        case "Sybase":
            $dbi = @sybase_close($id);
            return $dbi;
            break;
        default:
            break;
    }
}

 public function disconnect()
 {
     if (is_resource($this->lnk)) {
         ibase_close($this->lnk);
     }
 }

 /**
  * Close sql connection
  * @access private
  */
 function _sql_close()
 {
     if ($this->service_handle !== false) {
         @ibase_service_detach($this->service_handle);
     }
     return @ibase_close($this->db_connect_id);
 }

 /**
  * Close DB Connection
  *
  * @param	resource
  * @return	void
  */
 protected function _close($conn_id)
 {
     @ibase_close($conn_id);
 }

 /**
  * @see ILumine_Connection::close()
  */
 public function close()
 {
     $this->dispatchEvent(new Lumine_ConnectionEvent(Lumine_Event::PRE_CLOSE, $this));
     if ($this->conn_id && $this->state != self::CLOSED) {
         Lumine_Log::debug('Liberando resultados todos os resultados');
         Lumine_Dialect_Factory::getByName('Firebird')->freeAllResults();
         $this->state = self::CLOSED;
         Lumine_Log::debug('Fechando conexao com ' . $this->getDatabase());
         ibase_close($this->conn_id);
     }
     $this->dispatchEvent(new Lumine_ConnectionEvent(Lumine_Event::POS_CLOSE, $this));
 }

 /**
  * Force the connection to close.
  *
  * @return void
  */
 public function closeConnection()
 {
     if (is_resource($this->_transResource)) {
         ibase_rollback($this->_transResource);
     }
     $this->_transResource = null;
     if (is_resource($this->_connection)) {
         ibase_close($this->_connection);
     }
     $this->_connection = null;
 }

 /**
 +----------------------------------------------------------
 * 关闭数据库
 +----------------------------------------------------------
 * @access public
 +----------------------------------------------------------
 */
 public function close()
 {
     if ($this->_linkID) {
         ibase_close($this->_linkID);
     }
     $this->_linkID = null;
 }