Class: ADOConnection

Source Location: /lodel/scripts/adodb/adodb.inc.php

Class ADOConnection

Class Overview

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

Located in /lodel/scripts/adodb/adodb.inc.php [line 237]

Properties

Methods

[ Top ]

Descendants

Child Class	Description
ADODB_informix72	Connection object. For connecting to databases, and executing queries.
ADODB_odbtp	Connection object. For connecting to databases, and executing queries.
	Connection object. For connecting to databases, and executing queries.
ADODB_mysql	Connection object. For connecting to databases, and executing queries.
ADODB_mysqli	Connection object. For connecting to databases, and executing queries.
ADODB_db2	Connection object. For connecting to databases, and executing queries.
ADODB_csv	Connection object. For connecting to databases, and executing queries.
ADODB_postgres64	Connection object. For connecting to databases, and executing queries.
ADODB_odbc	Connection object. For connecting to databases, and executing queries.
ADODB_oci8	Connection object. For connecting to databases, and executing queries.
ADODB_sqlite	Connection object. For connecting to databases, and executing queries.
ADODB_pdo	Connection object. For connecting to databases, and executing queries.
ADODB_mssql	Connection object. For connecting to databases, and executing queries.
ADODB_ldap	Connection object. For connecting to databases, and executing queries.
ADODB_ibase	Connection object. For connecting to databases, and executing queries.
ADODB_sybase	Connection object. For connecting to databases, and executing queries.
ADODB_fbsql	Connection object. For connecting to databases, and executing queries.
ADODB_oracle	Connection object. For connecting to databases, and executing queries.

[ Top ]

Property Summary

mixed	$ansiOuter
mixed	$arrayClass
mixed	$autoCommit
mixed	$autoRollback
mixed	$blobEncodeType
mixed	$cacheSecs
mixed	$charSet
mixed	$concat_operator
mixed	$database
mixed	$databaseType
mixed	$dataProvider
mixed	$debug
mixed	$emptyDate
mixed	$emptyTimeStamp
mixed	$false
mixed	$fetchMode
mixed	$fmtDate
mixed	$fmtTimeStamp
mixed	$fnCacheExecute
mixed	$fnExecute
mixed	$genID
mixed	$hasAffectedRows
mixed	$hasGenID
mixed	$hasInsertID
mixed	$hasLimit
mixed	$hasMoveFirst
mixed	$hasTop
mixed	$hasTransactions
mixed	$host
mixed	$isoDates
mixed	$lastInsID
mixed	$leftOuter
mixed	$length
mixed	$maxblobsize
mixed	$memCache
mixed	$memCacheCompress
mixed	$memCacheHost
mixed	$memCachePort
mixed	$metaDatabasesSQL
mixed	$metaTablesSQL
mixed	$nameQuote
mixed	$noNullStrings
mixed	$null2null
mixed	$numCacheHits
mixed	$numCacheMisses
mixed	$pageExecuteCountRows
mixed	$password
mixed	$poorAffectedRows
mixed	$raiseErrorFn
mixed	$random
mixed	$readOnly
mixed	$replaceQuote
mixed	$rightOuter
mixed	$rsPrefix
mixed	$substr
mixed	$sysDate
mixed	$sysTimeStamp
mixed	$transCnt
mixed	$transOff
mixed	$true
mixed	$uniqueOrderBy
mixed	$uniqueSort
mixed	$upperCase
mixed	$user
mixed	$_affected
mixed	$_bindInputArray
mixed	$_connectionID
mixed	$_errorCode
mixed	$_errorMsg
mixed	$_evalAll
mixed	$_isPersistentConnection
mixed	$_logsql
mixed	$_oldRaiseFn
mixed	$_queryID
mixed	$_transmode
mixed	$_transOK

[ Top ]

Method Summary

ADOConnection	ADOConnection()	Constructor
void	addq()	Quotes a string, without prefixing nor appending quotes.
#	Affected_Rows()
void	&AutoExecute()
true	BeginTrans()	Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().
void	BindDate()
void	BindTimeStamp()
void	BlobDecode()
void	BlobEncode()
RecordSet	&CacheExecute()	Execute SQL, caching recordsets.
void	CacheFlush()	Flush cached recordsets that match a particular $sql statement.
void	&CacheGetAll()
void	&CacheGetArray()
void	&CacheGetAssoc()
void	CacheGetCol()
void	CacheGetOne()
void	&CacheGetRow()
the	&CachePageExecute()	Will select the supplied $page number from a recordset, given that it is paginated in pages of $nrows rows per page. It also saves two boolean values saying if the given page is the first and/or last one of the recordset. Added by Iván Oliva to provide recordset pagination.
the	&CacheSelectLimit()	Will select, getting rows from $offset (1-based), for $nrows.
void	Close()	Close Connection
void	CommitLock()
true/false.	CommitTrans()	If database does not support transactions, always return true as data always commited
void	CompleteTrans()
concatenated	Concat()	Different SQL databases used different methods to combine strings together.
true	Connect()	Connect to database
void	CreateSequence()
date	DBDate()	Converts a date "d" to a string that the database can understand.
timestamp	DBTimeStamp()	Converts a timestamp "ts" to a string that the database can understand.
void	Disconnect()	PEAR DB Compat - do not use internally
void	DropSequence()
the	ErrorMsg()
void	ErrorNative()	PEAR DB Compat - do not use internally.
the	ErrorNo()
void	escape()
RecordSet	&Execute()	Execute SQL
void	FailTrans()
GenID()	Generates a sequence id and stores it in $this->genID; GenID is only available if $this->hasGenID = true;
void	&GetActiveRecords()
void	&GetActiveRecordsClass()
void	&GetAll()
void	&GetArray()
void	&GetAssoc()
void	GetCharSet()
void	GetCol()
void	GetInsertSQL()	Generates an Insert Query based on an existing recordset.
void	GetOne()	Return first element of first row of sql statement. Recordset is disposed for you.
void	&GetRow()	Return one row of sql statement. Recordset is disposed for you.
void	GetUpdateSQL()	Generates an Update Query based on an existing recordset.
void	HasFailedTrans()
void	IfNull()
void	IgnoreErrors()
void	InParameter()
the	Insert_ID()
void	IsConnected()
void	&LimitQuery()	PEAR DB Compat - do not use internally
void	LogSQL()
array	&MetaColumnNames()	List columns names in a table as an array.
array	&MetaColumns()	List columns in a database as an array of ADOFieldObjects.
an	MetaDatabases()	return the databases that the driver can connect to.
void	MetaError()
void	MetaErrorMsg()
assoc	MetaForeignKeys()
array	&MetaIndexes()	List indexes on a table as an array.
an	MetaPrimaryKeys()
array	&MetaTables()
void	MetaTransaction()
void	MetaType()
true	NConnect()	Always force a new connection to database - currently only works with oracle
void	nextId()	PEAR DB Compat - do not use internally.
void	OffsetDate()
void	outp()	All error messages go through this bottleneck function.
void	OutParameter()
the	&PageExecute()	Will select the supplied $page number from a recordset, given that it is paginated in pages of $nrows rows per page. It also saves two boolean values saying if the given page is the first and/or last one of the recordset. Added by Iván Oliva to provide recordset pagination.
void	Param()
void	Parameter()
return	PConnect()	Establish persistent connect to database
the	PO_Insert_ID()	Portable Insert ID. Pablo Roca <pabloroca#mvps.org>
return	Prepare()	Should prepare the sql statement and return the stmt resource.
return	PrepareSP()	Some databases, eg. mssql require a different function for preparing stored procedures. So we cannot use Prepare().
void	q()
void	QMagic()
quoted	qstr()	Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes.
void	&Query()	PEAR DB Compat - do not use internally.
void	Quote()	PEAR DB Compat
void	Replace()	Insert or replace a single record. Note: this is not the same as MySQL's replace.
void	RollbackLock()
true/false.	RollbackTrans()	If database does not support transactions, rollbacks always fail, so return false
void	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
true	SelectDB()	Choose a database to connect to. Many databases do not support this.
the	&SelectLimit()	Will select, getting rows from $offset (1-based), for $nrows.
void	&SerializableRS()	Create serializable recordset. Breaks rs link to connection.
void	ServerInfo()
void	SetCharSet()
void	SetDateLocale()	Change the SQL connection locale to a specified locale.
The	SetFetchMode()	PEAR DB Compat - do not use internally.
void	SetTransactionMode()
void	SQLDate()
void	StartTrans()
void	Time()
void	&Transpose()
date	UnixDate()	Also in ADORecordSet.
date	UnixTimeStamp()	Also in ADORecordSet.
void	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.
void	UpdateBlobFile()	Usage: UpdateBlob('TABLE', 'COLUMN', '/path/to/file', 'ID=1');
void	UpdateClob()	Usage: UpdateClob('TABLE', 'COLUMN', $var, 'ID=1', 'CLOB');
a	UserDate()	Also in ADORecordSet.
a	UserTimeStamp()
void	Version()
void	xCacheFlush()
void	_dirFlush()	Private function to erase all of the files and subdirectories in a directory.
void	&_Execute()
void	_findschema()
void	_findvers()
void	_gencachename()	Private function to generate filename for caching.
void	_nconnect()
the	&_rs2rs()	Convert database recordset to an array recordset input recordset's cursor should be at beginning, and old $rs will be closed.

[ Top ]

Properties

mixed $ansiOuter = false [line 299]

Redefined in descendants as:

[ Top ]

mixed $arrayClass = 'ADORecordSet_array' [line 290]

Redefined in descendants as:

[ Top ]

mixed $autoCommit = true [line 308]

[ Top ]

mixed $autoRollback = false [line 300]

Redefined in descendants as:

[ Top ]

mixed $blobEncodeType = false [line 305]

Redefined in descendants as:

[ Top ]

mixed $cacheSecs = 3600 [line 280]

	default

[ class tree: default ] [ index: default ] [ all elements ]