Connection object. For connecting to databases, and executing queries.

Located in /3rd/adodb/drivers/adodb-ibase.inc.php (line 29)

ADOConnection
   |
   --ADODB_ibase

mixed $ansiOuter = true (line 51)

---

Redefinition of:

ADOConnection::$ansiOuter

mixed $blobEncodeType = 'C' (line 54)

---

Redefinition of:

ADOConnection::$blobEncodeType

mixed $buffers = 0 (line 47)

mixed $concat_operator = '||' (line 38)

---

Redefinition of:

ADOConnection::$concat_operator

mixed $databaseType = "ibase" (line 30)

---

Redefinition of:

ADOConnection::$databaseType

---

Redefined in descendants as:

• ADODB_borland_ibase::$databaseType
• ADODB_firebird::$databaseType

mixed $dataProvider = "ibase" (line 31)

---

Redefinition of:

ADOConnection::$dataProvider

mixed $dialect = 1 (line 48)

---

Redefined in descendants as:

• ADODB_firebird::$dialect

mixed $fmtDate = "'Y-m-d'" (line 34)

---

Redefinition of:

ADOConnection::$fmtDate

mixed $fmtTimeStamp = "'Y-m-d, H:i:s'" (line 37)

---

Redefinition of:

ADOConnection::$fmtTimeStamp

mixed $hasAffectedRows = false (line 52)

---

Redefinition of:

ADOConnection::$hasAffectedRows

mixed $hasGenID = true (line 45)

---

Redefinition of:

ADOConnection::$hasGenID

mixed $ibasetrans (line 44)

mixed $ibase_datefmt = '%Y-%m-%d' (line 33)

mixed $ibase_timefmt = "%H:%M:%S" (line 36)

mixed $ibase_timestampfmt = "%Y-%m-%d %H:%M:%S" (line 35)

mixed $metaColumnsSQL = "select a.rdb\$field_name, a.rdb\$null_flag, a.rdb\$default_source, b.rdb\$field_length, b.rdb\$field_scale, b.rdb\$field_sub_type, b.rdb\$field_precision, b.rdb\$field_type from rdb\$relation_fields a, rdb\$fields b where a.rdb\$field_source = b.rdb\$field_name and a.rdb\$relation_name = '%s' order by a.rdb\$field_position asc" (line 42)

mixed $metaTablesSQL = "select rdb\$relation_name from rdb\$relations where rdb\$relation_name not like 'RDB\$%'" (line 40)

---

Redefinition of:

ADOConnection::$metaTablesSQL

mixed $poorAffectedRows = true (line 53)

---

Redefinition of:

ADOConnection::$poorAffectedRows

mixed $replaceQuote = "''" (line 32)

---

Redefinition of:

ADOConnection::$replaceQuote

mixed $role = false (line 55)

mixed $sysDate = "cast('TODAY' as timestamp)" (line 49)

---

Redefinition of:

ADOConnection::$sysDate

mixed $sysTimeStamp = "cast('NOW' as timestamp)" (line 50)

---

Redefinition of:

ADOConnection::$sysTimeStamp

---

Redefined in descendants as:

• ADODB_firebird::$sysTimeStamp

mixed $_bindInputArray = true (line 46)

---

Redefinition of:

ADOConnection::$_bindInputArray

mixed $_transactionID (line 39)

Inherited Variables

Inherited from ADOConnection

ADOConnection::$arrayClass
ADOConnection::$autoCommit
ADOConnection::$autoRollback
ADOConnection::$cacheSecs
ADOConnection::$charSet
ADOConnection::$database
ADOConnection::$debug
ADOConnection::$emptyDate
ADOConnection::$emptyTimeStamp
ADOConnection::$false
ADOConnection::$fetchMode
ADOConnection::$fnCacheExecute
ADOConnection::$fnExecute
ADOConnection::$genID
ADOConnection::$hasInsertID
ADOConnection::$hasLimit
ADOConnection::$hasMoveFirst
ADOConnection::$hasTop
ADOConnection::$hasTransactions
ADOConnection::$host
ADOConnection::$isoDates
ADOConnection::$lastInsID
ADOConnection::$leftOuter
ADOConnection::$length
ADOConnection::$maxblobsize
ADOConnection::$metaDatabasesSQL
ADOConnection::$nameQuote
ADOConnection::$noNullStrings
ADOConnection::$numCacheHits
ADOConnection::$numCacheMisses
ADOConnection::$pageExecuteCountRows
ADOConnection::$password
ADOConnection::$raiseErrorFn
ADOConnection::$random
ADOConnection::$readOnly
ADOConnection::$rightOuter
ADOConnection::$rsPrefix
ADOConnection::$substr
ADOConnection::$transCnt
ADOConnection::$transOff
ADOConnection::$true
ADOConnection::$uniqueOrderBy
ADOConnection::$uniqueSort
ADOConnection::$upperCase
ADOConnection::$user
ADOConnection::$_affected
ADOConnection::$_connectionID
ADOConnection::$_errorCode
ADOConnection::$_errorMsg
ADOConnection::$_evalAll
ADOConnection::$_isPersistentConnection
ADOConnection::$_logsql
ADOConnection::$_oldRaiseFn
ADOConnection::$_queryID
ADOConnection::$_transOK

Constructor ADODB_ibase (line 57)

ADODB_ibase ADODB_ibase ()

BeginTrans (line 136)

void BeginTrans ()

---

Redefinition of:

ADOConnection::BeginTrans()

Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().

---

Redefined in descendants as:

• ADODB_borland_ibase::BeginTrans()

BlobDecode (line 549)

void BlobDecode ( $blob)

• $blob

---

Redefinition of:

ADOConnection::BlobDecode()

BlobEncode (line 540)

void BlobEncode ( $blob)

• $blob

---

Redefinition of:

ADOConnection::BlobEncode()

CommitTrans (line 145)

void CommitTrans ([ $ok = true])

• $ok

---

Redefinition of:

ADOConnection::CommitTrans()

If database does not support transactions, always return true as data always commited

CreateSequence (line 253)

void CreateSequence ( $seqname, [ $startID = 1])

• $seqname
• $startID

---

Redefinition of:

ADOConnection::CreateSequence()

DropSequence (line 260)

void DropSequence ( $seqname)

• $seqname

---

Redefinition of:

ADOConnection::DropSequence()

ErrorMsg (line 299)

void ErrorMsg ()

---

Redefinition of:

ADOConnection::ErrorMsg()

ErrorNo (line 293)

void ErrorNo ()

---

Redefinition of:

ADOConnection::ErrorNo()

GenID (line 266)

void GenID ([ $seqname = 'adodbseq'], [ $startID = 1])

• $seqname
• $startID

---

Redefinition of:

ADOConnection::GenID()

Generates a sequence id and stores it in $this->genID; GenID is only available if $this->hasGenID = true;

MetaColumns (line 479)

void &MetaColumns ( $table)

• $table

---

Redefinition of:

ADOConnection::MetaColumns()

List columns in a database as an array of ADOFieldObjects.

MetaIndexes (line 190)

void &MetaIndexes ( $table, [ $primary = FALSE], [ $owner = false])

• $table
• $primary
• $owner

---

Redefinition of:

ADOConnection::MetaIndexes()

List indexes on a table as an array.

MetaPrimaryKeys (line 105)

void MetaPrimaryKeys ( $table, [ $owner_notused = false], [ $internalKey = false])

• $table
• $owner_notused
• $internalKey

---

Redefinition of:

ADOConnection::MetaPrimaryKeys()

OldUpdateBlob (line 633)

void OldUpdateBlob ( $table,  $column,  $val,  $where, [ $blobtype = 'BLOB'])

• $table
• $column
• $val
• $where
• $blobtype

Prepare (line 304)

void Prepare ( $sql)

• $sql

---

Redefinition of:

ADOConnection::Prepare()

Should prepare the sql statement and return the stmt resource.

RollbackTrans (line 177)

void RollbackTrans ()

---

Redefinition of:

ADOConnection::RollbackTrans()

If database does not support transactions, rollbacks always fail, so return false

RowLock (line 245)

void RowLock ( $tables,  $where,  $col)

• $tables
• $where
• $col

---

Redefinition of:

ADOConnection::RowLock()

Lock a row, will escalate and lock the table if row locking not supported will normally free the lock at the end of the transaction

SelectDB (line 283)

void SelectDB ( $dbName)

• $dbName

---

Redefinition of:

ADOConnection::SelectDB()

Choose a database to connect to. Many databases do not support this.

ServerInfo (line 121)

void ServerInfo ()

---

Redefinition of:

ADOConnection::ServerInfo()

---

Redefined in descendants as:

• ADODB_borland_ibase::ServerInfo()
• ADODB_firebird::ServerInfo()

SQLDate (line 644)

void SQLDate ( $fmt, [ $col = false])

• $fmt
• $col

---

Redefinition of:

ADOConnection::SQLDate()

UpdateBlob (line 599)

void UpdateBlob ( $table,  $column,  $val,  $where, [ $blobtype = 'BLOB'])

• $table
• $column
• $val
• $where
• $blobtype

---

Redefinition of:

ADOConnection::UpdateBlob()

Update a blob column, given a where clause. There are more sophisticated blob handling functions that we could have implemented, but all require a very complex API. Instead we have chosen something that is extremely simple to understand and use.

UpdateBlobFile (line 571)

void UpdateBlobFile ( $table,  $column,  $path,  $where, [ $blobtype = 'BLOB'])

• $table
• $column
• $path
• $where
• $blobtype

---

Redefinition of:

ADOConnection::UpdateBlobFile()

Usage: UpdateBlob('TABLE', 'COLUMN', '/path/to/file', 'ID=1');

_BlobDecode (line 559)

void _BlobDecode ( $blob)

• $blob

_close (line 375)

void _close ()

_connect (line 64)

void _connect ( $argHostname,  $argUsername,  $argPassword,  $argDatabasename, [ $persist = false])

• $argHostname
• $argUsername
• $argPassword
• $argDatabasename
• $persist

_ConvertFieldType (line 382)

void _ConvertFieldType ( &$fld,  $ftype,  $flen,  $fscale,  $fsubtype,  $fprecision,  $dialect3)

• &$fld
• $ftype
• $flen
• $fscale
• $fsubtype
• $fprecision
• $dialect3

_Execute (line 162)

void &_Execute ( $sql, [ $inputarr = false])

• $sql
• $inputarr

---

Redefinition of:

ADOConnection::_Execute()

_handleerror (line 288)

void _handleerror ()

_pconnect (line 99)

void _pconnect ( $argHostname,  $argUsername,  $argPassword,  $argDatabasename)

• $argHostname
• $argUsername
• $argPassword
• $argDatabasename

_query (line 313)

void _query ( $sql, [ $iarr = false])

• $sql
• $iarr

Inherited Methods

Inherited From ADOConnection

ADOConnection::ADOConnection()
ADOConnection::addq()
ADOConnection::Affected_Rows()
ADOConnection::AutoExecute()
ADOConnection::BeginTrans()
ADOConnection::BlobDecode()
ADOConnection::BlobEncode()
ADOConnection::CacheExecute()
ADOConnection::CacheFlush()
ADOConnection::CacheGetAll()
ADOConnection::CacheGetArray()
ADOConnection::CacheGetAssoc()
ADOConnection::CacheGetCol()
ADOConnection::CacheGetOne()
ADOConnection::CacheGetRow()
ADOConnection::CachePageExecute()
ADOConnection::CacheSelectLimit()
ADOConnection::Close()
ADOConnection::CommitLock()
ADOConnection::CommitTrans()
ADOConnection::CompleteTrans()
ADOConnection::Concat()
ADOConnection::Connect()
ADOConnection::CreateSequence()
ADOConnection::DBDate()
ADOConnection::DBTimeStamp()
ADOConnection::Disconnect()
ADOConnection::DropSequence()
ADOConnection::ErrorMsg()
ADOConnection::ErrorNative()
ADOConnection::ErrorNo()
ADOConnection::escape()
ADOConnection::Execute()
ADOConnection::FailTrans()
ADOConnection::GenID()
ADOConnection::GetAll()
ADOConnection::GetArray()
ADOConnection::GetAssoc()
ADOConnection::GetCharSet()
ADOConnection::GetCol()
ADOConnection::GetInsertSQL()
ADOConnection::GetOne()
ADOConnection::GetRow()
ADOConnection::GetUpdateSQL()
ADOConnection::HasFailedTrans()
ADOConnection::IfNull()
ADOConnection::InParameter()
ADOConnection::Insert_ID()
ADOConnection::IsConnected()
ADOConnection::LimitQuery()
ADOConnection::LogSQL()
ADOConnection::MetaColumnNames()
ADOConnection::MetaColumns()
ADOConnection::MetaDatabases()
ADOConnection::MetaError()
ADOConnection::MetaErrorMsg()
ADOConnection::MetaForeignKeys()
ADOConnection::MetaIndexes()
ADOConnection::MetaPrimaryKeys()
ADOConnection::MetaTables()
ADOConnection::MetaType()
ADOConnection::NConnect()
ADOConnection::nextId()
ADOConnection::OffsetDate()
ADOConnection::outp()
ADOConnection::OutParameter()
ADOConnection::PageExecute()
ADOConnection::Param()
ADOConnection::Parameter()
ADOConnection::PConnect()
ADOConnection::PO_Insert_ID()
ADOConnection::Prepare()
ADOConnection::PrepareSP()
ADOConnection::q()
ADOConnection::QMagic()
ADOConnection::qstr()
ADOConnection::Query()
ADOConnection::Quote()
ADOConnection::Replace()
ADOConnection::RollbackLock()
ADOConnection::RollbackTrans()
ADOConnection::RowLock()
ADOConnection::SelectDB()
ADOConnection::SelectLimit()
ADOConnection::SerializableRS()
ADOConnection::ServerInfo()
ADOConnection::SetCharSet()
ADOConnection::SetDateLocale()
ADOConnection::SetFetchMode()
ADOConnection::SQLDate()
ADOConnection::StartTrans()
ADOConnection::Time()
ADOConnection::UnixDate()
ADOConnection::UnixTimeStamp()
ADOConnection::UpdateBlob()
ADOConnection::UpdateBlobFile()
ADOConnection::UpdateClob()
ADOConnection::UserDate()
ADOConnection::UserTimeStamp()
ADOConnection::Version()
ADOConnection::_Execute()
ADOConnection::_findschema()
ADOConnection::_findvers()
ADOConnection::_gencachename()
ADOConnection::_nconnect()
ADOConnection::_rs2rs()