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

Located in /3rd/adodb/drivers/adodb-mysql.inc.php (line 21)

ADOConnection
   |
   --ADODB_mysql

mixed $clientFlags = 0 (line 38)

mixed $databaseType = 'mysql' (line 22)

---

Redefinition of:

ADOConnection::$databaseType

---

Redefined in descendants as:

• ADODB_mysqlt::$databaseType

mixed $dataProvider = 'mysql' (line 23)

---

Redefinition of:

ADOConnection::$dataProvider

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

---

Redefinition of:

ADOConnection::$fmtTimeStamp

mixed $forceNewConnect = false (line 36)

mixed $hasAffectedRows = true (line 25)

---

Redefinition of:

ADOConnection::$hasAffectedRows

mixed $hasGenID = true (line 31)

---

Redefinition of:

ADOConnection::$hasGenID

mixed $hasInsertID = true (line 24)

---

Redefinition of:

ADOConnection::$hasInsertID

mixed $hasLimit = true (line 29)

---

Redefinition of:

ADOConnection::$hasLimit

mixed $hasMoveFirst = true (line 30)

---

Redefinition of:

ADOConnection::$hasMoveFirst

mixed $hasTransactions = false (line 35)

---

Redefinition of:

ADOConnection::$hasTransactions

---

Redefined in descendants as:

• ADODB_mysqlt::$hasTransactions

mixed $isoDates = true (line 32)

---

Redefinition of:

ADOConnection::$isoDates

mixed $metaColumnsSQL = "SHOW COLUMNS FROM %s" (line 27)

mixed $metaTablesSQL = "SHOW TABLES" (line 26)

---

Redefinition of:

ADOConnection::$metaTablesSQL

mixed $nameQuote = '`' (line 40)

---

Redefinition of:

ADOConnection::$nameQuote

mixed $poorAffectedRows = true (line 37)

---

Redefinition of:

ADOConnection::$poorAffectedRows

mixed $substr = "substring" (line 39)

---

Redefinition of:

ADOConnection::$substr

mixed $sysDate = 'CURDATE()' (line 33)

---

Redefinition of:

ADOConnection::$sysDate

mixed $sysTimeStamp = 'NOW()' (line 34)

---

Redefinition of:

ADOConnection::$sysTimeStamp

mixed $_dropSeqSQL = "drop table %s" (line 186)

mixed $_genIDSQL = "update %s set id=LAST_INSERT_ID(id+1);" (line 183)

mixed $_genSeq2SQL = "insert into %s values (%s)" (line 185)

mixed $_genSeqSQL = "create table %s (id int not null)" (line 184)

Inherited Variables

Inherited from ADOConnection

ADOConnection::$ansiOuter
ADOConnection::$arrayClass
ADOConnection::$autoCommit
ADOConnection::$autoRollback
ADOConnection::$blobEncodeType
ADOConnection::$cacheSecs
ADOConnection::$charSet
ADOConnection::$concat_operator
ADOConnection::$database
ADOConnection::$debug
ADOConnection::$emptyDate
ADOConnection::$emptyTimeStamp
ADOConnection::$false
ADOConnection::$fetchMode
ADOConnection::$fmtDate
ADOConnection::$fnCacheExecute
ADOConnection::$fnExecute
ADOConnection::$genID
ADOConnection::$hasTop
ADOConnection::$host
ADOConnection::$lastInsID
ADOConnection::$leftOuter
ADOConnection::$length
ADOConnection::$maxblobsize
ADOConnection::$metaDatabasesSQL
ADOConnection::$noNullStrings
ADOConnection::$numCacheHits
ADOConnection::$numCacheMisses
ADOConnection::$pageExecuteCountRows
ADOConnection::$password
ADOConnection::$raiseErrorFn
ADOConnection::$random
ADOConnection::$readOnly
ADOConnection::$replaceQuote
ADOConnection::$rightOuter
ADOConnection::$rsPrefix
ADOConnection::$transCnt
ADOConnection::$transOff
ADOConnection::$true
ADOConnection::$uniqueOrderBy
ADOConnection::$uniqueSort
ADOConnection::$upperCase
ADOConnection::$user
ADOConnection::$_affected
ADOConnection::$_bindInputArray
ADOConnection::$_connectionID
ADOConnection::$_errorCode
ADOConnection::$_errorMsg
ADOConnection::$_evalAll
ADOConnection::$_isPersistentConnection
ADOConnection::$_logsql
ADOConnection::$_oldRaiseFn
ADOConnection::$_queryID
ADOConnection::$_transOK

Constructor ADODB_mysql (line 42)

ADODB_mysql ADODB_mysql ()

BeginTrans (line 171)

void BeginTrans ()

---

Redefinition of:

ADOConnection::BeginTrans()

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

---

Redefined in descendants as:

• ADODB_mysqlt::BeginTrans()

CharMax (line 521)

void CharMax ()

Concat (line 324)

void Concat ()

---

Redefinition of:

ADOConnection::Concat()

Different SQL databases used different methods to combine strings together.

CreateSequence (line 188)

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

• $seqname
• $startID

---

Redefinition of:

ADOConnection::CreateSequence()

ErrorMsg (line 493)

void ErrorMsg ()

---

Redefinition of:

ADOConnection::ErrorMsg()

ErrorNo (line 503)

void ErrorNo ()

---

Redefinition of:

ADOConnection::ErrorNo()

GenID (line 199)

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;

GetOne (line 156)

void GetOne ( $sql, [ $inputarr = false])

• $sql
• $inputarr

---

Redefinition of:

ADOConnection::GetOne()

Return first element of first row of sql statement. Recordset is disposed for you.

IfNull (line 54)

void IfNull ( $field,  $ifNull)

• $field
• $ifNull

---

Redefinition of:

ADOConnection::IfNull()

MetaColumns (line 381)

void &MetaColumns ( $table)

• $table

---

Redefinition of:

ADOConnection::MetaColumns()

List columns in a database as an array of ADOFieldObjects.

MetaDatabases (line 224)

void &MetaDatabases ()

---

Redefinition of:

ADOConnection::MetaDatabases()

return the databases that the driver can connect to.

MetaForeignKeys (line 535)

void MetaForeignKeys ( $table, [ $owner = FALSE], [ $upper = FALSE], [ $asociative = FALSE])

• $table
• $owner
• $upper
• $asociative

---

Redefinition of:

ADOConnection::MetaForeignKeys()

MetaIndexes (line 77)

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

• $table
• $primary
• $owner

---

Redefinition of:

ADOConnection::MetaIndexes()

List indexes on a table as an array.

MetaTables (line 59)

void &MetaTables ([ $ttype = false], [ $showSchema = false], [ $mask = false])

• $ttype
• $showSchema
• $mask

---

Redefinition of:

ADOConnection::MetaTables()

OffsetDate (line 335)

void OffsetDate ( $dayFraction, [ $date = false])

• $dayFraction
• $date

---

Redefinition of:

ADOConnection::OffsetDate()

qstr (line 131)

void qstr ( $s, [ $magic_quotes = false])

• $s
• $magic_quotes

---

Redefinition of:

ADOConnection::qstr()

Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes.

SelectDB (line 460)

void SelectDB ( $dbName)

• $dbName

---

Redefinition of:

ADOConnection::SelectDB()

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

SelectLimit (line 470)

void &SelectLimit ( $sql, [ $nrows = -1], [ $offset = -1], [ $inputarr = false], [ $secs = 0])

• $sql
• $nrows
• $offset
• $inputarr
• $secs

---

Redefinition of:

ADOConnection::SelectLimit()

Will select, getting rows from $offset (1-based), for $nrows.

ServerInfo (line 47)

void ServerInfo ()

---

Redefinition of:

ADOConnection::ServerInfo()

SQLDate (line 240)

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

• $fmt
• $col

---

Redefinition of:

ADOConnection::SQLDate()

TextMax (line 529)

void TextMax ()

_affectedrows (line 176)

void _affectedrows ()

_close (line 511)

void _close ()

_connect (line 342)

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

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

_insertid (line 150)

void _insertid ()

_nconnect (line 375)

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

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

---

Redefinition of:

ADOConnection::_nconnect()

_pconnect (line 361)

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

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

_query (line 484)

void _query ( $sql,  $inputarr)

• $sql
• $inputarr

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