ADOConnection Class Reference

Inheritance diagram for ADOConnection:


Public Member Functions
	ADOConnection ()
	Version ()
	ServerInfo ()
	IsConnected ()
	_findvers ($str)
	outp ($msg, $newline=true)
	Time ()
	Connect ($argHostname="", $argUsername="", $argPassword="", $argDatabaseName="", $forceNew=false)
	_nconnect ($argHostname, $argUsername, $argPassword, $argDatabaseName)
	NConnect ($argHostname="", $argUsername="", $argPassword="", $argDatabaseName="")
	PConnect ($argHostname="", $argUsername="", $argPassword="", $argDatabaseName="")
	SQLDate ($fmt, $col=false)
	Prepare ($sql)
	PrepareSP ($sql, $param=true)
	Quote ($s)
	QMagic ($s)
	q (&$s)
	ErrorNative ()
	nextId ($seq_name)
	RowLock ($table, $where)
	CommitLock ($table)
	RollbackLock ($table)
	SetFetchMode ($mode)
&	Query ($sql, $inputarr=false)
&	LimitQuery ($sql, $offset, $count, $params=false)
	Disconnect ()
	Param ($name, $type='C')
	InParameter (&$stmt, &$var, $name, $maxLen=4000, $type=false)
	OutParameter (&$stmt, &$var, $name, $maxLen=4000, $type=false)
	Parameter (&$stmt, &$var, $name, $isOutput=false, $maxLen=4000, $type=false)
	StartTrans ($errfn= 'ADODB_TransMonitor')
	CompleteTrans ($autoComplete=true)
	FailTrans ()
	HasFailedTrans ()
&	Execute ($sql, $inputarr=false)
&	_Execute ($sql, $inputarr=false)
	CreateSequence ($seqname='adodbseq', $startID=1)
	DropSequence ($seqname='adodbseq')
	GenID ($seqname='adodbseq', $startID=1)
	Insert_ID ($table='', $column='')
	PO_Insert_ID ($table="", $id="")
	Affected_Rows ()
	ErrorMsg ()
	ErrorNo ()
	MetaError ($err=false)
	MetaErrorMsg ($errno)
	MetaPrimaryKeys ($table, $owner=false)
	MetaForeignKeys ($table, $owner=false, $upper=false)
	SelectDB ($dbName)
&	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
&	SerializableRS (&$rs)
&	_rs2rs (&$rs, $nrows=-1, $offset=-1, $close=true)
&	GetAll ($sql, $inputarr=false)
&	GetAssoc ($sql, $inputarr=false, $force_array=false, $first2cols=false)
&	CacheGetAssoc ($secs2cache, $sql=false, $inputarr=false, $force_array=false, $first2cols=false)
	GetOne ($sql, $inputarr=false)
	CacheGetOne ($secs2cache, $sql=false, $inputarr=false)
	GetCol ($sql, $inputarr=false, $trim=false)
	CacheGetCol ($secs, $sql=false, $inputarr=false, $trim=false)
	OffsetDate ($dayFraction, $date=false)
&	GetArray ($sql, $inputarr=false)
&	CacheGetAll ($secs2cache, $sql=false, $inputarr=false)
&	CacheGetArray ($secs2cache, $sql=false, $inputarr=false)
&	GetRow ($sql, $inputarr=false)
&	CacheGetRow ($secs2cache, $sql=false, $inputarr=false)
	Replace ($table, $fieldArray, $keyCol, $autoQuote=false, $has_autoinc=false)
&	CacheSelectLimit ($secs2cache, $sql, $nrows=-1, $offset=-1, $inputarr=false)
	CacheFlush ($sql=false, $inputarr=false)
	_dirFlush ($dir, $kill_top_level=false)
	xCacheFlush ($sql=false, $inputarr=false)
	_gencachename ($sql, $createdir)
&	CacheExecute ($secs2cache, $sql=false, $inputarr=false)
&	AutoExecute ($table, $fields_values, $mode= 'INSERT', $where=FALSE, $forceUpdate=true, $magicq=false)
	GetUpdateSQL (&$rs, $arrFields, $forceUpdate=false, $magicq=false, $force=null)
	GetInsertSQL (&$rs, $arrFields, $magicq=false, $force=null)
	UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB')
	UpdateBlobFile ($table, $column, $path, $where, $blobtype='BLOB')
	BlobDecode ($blob)
	BlobEncode ($blob)
	SetCharSet ($charset)
	IfNull ($field, $ifNull)
	LogSQL ($enable=true)
	GetCharSet ()
	UpdateClob ($table, $column, $val, $where)
	MetaType ($t, $len=-1, $fieldobj=false)
	SetDateLocale ($locale= 'En')
&	GetActiveRecordsClass ($class, $table, $whereOrderBy=false, $bindarr=false, $primkeyArr=false)
&	GetActiveRecords ($table, $where=false, $bindarr=false, $primkeyArr=false)
	Close ()
	BeginTrans ()
	CommitTrans ($ok=true)
	RollbackTrans ()
	MetaDatabases ()
&	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	_findschema (&$table, &$schema)
&	MetaColumns ($table, $normalize=true)
&	MetaIndexes ($table, $primary=false, $owner=false)
&	MetaColumnNames ($table, $numIndexes=false)
	Concat ()
	DBDate ($d)
	DBTimeStamp ($ts)
	UnixDate ($v)
	UnixTimeStamp ($v)
	UserDate ($v, $fmt='Y-m-d', $gmt=false)
	UserTimeStamp ($v, $fmt='Y-m-d H:i:s', $gmt=false)
	escape ($s, $magic_quotes=false)
	addq ($s, $magic_quotes=false)
	qstr ($s, $magic_quotes=false)
&	PageExecute ($sql, $nrows, $page, $inputarr=false, $secs2cache=0)
&	CachePageExecute ($secs2cache, $sql, $nrows, $page, $inputarr=false)
Public Attributes
	$dataProvider = 'native'
	$databaseType = ''
	$database = ''
	RDBMS currently in use, eg. odbc, mysql, mssql.
	$host = ''
	Name of database to be used.
	$user = ''
	The hostname of the database server.
	$password = ''
	The username which is used to connect to the database server.
	$debug = false
	Password for the username. For security, we no longer store it.
	$maxblobsize = 262144
	if set to true will output sql statements
	$concat_operator = '+'
	maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro
	$substr = 'substr'
	default concat operator -- change to \|\| for Oracle/Interbase
	$length = 'length'
	substring operator
	$random = 'rand()'
	string length ofperator
	$upperCase = 'upper'
	random function
	$fmtDate = "'Y-m-d'"
	uppercase function
	$fmtTimeStamp = "'Y-m-d, h:i:s A'"
	used by DBDate() as the default date format used by the database
	$true = '1'
	used by DBTimeStamp as the default timestamp fmt.
	$false = '0'
	string that represents TRUE for a database
	$replaceQuote = "\\'"
	string that represents FALSE for a database
	$nameQuote = '"'
	string to use to replace quotes
	$charSet = false
	string to use to quote identifiers and names
	$metaDatabasesSQL = ''
	character set to use - only for interbase, postgres and oci8
	$metaTablesSQL = ''
	$uniqueOrderBy = false
	$emptyDate = ' '
	All order by columns have to be unique.
	$emptyTimeStamp = ' '
	$lastInsID = false
	$hasInsertID = false
	$hasAffectedRows = false
	supports autoincrement ID?
	$hasTop = false
	supports affected rows for update/delete?
	$hasLimit = false
	support mssql/access SELECT TOP 10 * FROM TABLE
	$readOnly = false
	support pgsql/mysql SELECT * FROM TABLE LIMIT 10
	$hasMoveFirst = false
	this is a readonly database - used by phpLens
	$hasGenID = false
	has ability to run MoveFirst(), scrolling backwards
	$hasTransactions = true
	can generate sequences using GenID();
	$genID = 0
	has transactions
	$raiseErrorFn = false
	sequence id used by GenID();
	$isoDates = false
	error function to call
	$cacheSecs = 3600
	accepts dates in ISO format
	$sysDate = false
	cache for 1 hour
	$sysTimeStamp = false
	name of function that returns the current date
	$arrayClass = 'ADORecordSet_array'
	name of function that returns the current timestamp
	$noNullStrings = false
	name of class used to generate array recordsets, which are pre-downloaded recordsets
	$numCacheHits = 0
	oracle specific stuff - if true ensures that '' is converted to ' '
	$numCacheMisses = 0
	$pageExecuteCountRows = true
	$uniqueSort = false
	$leftOuter = false
	indicates that all fields in order by must be unique
	$rightOuter = false
	operator to use for left outer join in WHERE clause
	$ansiOuter = false
	operator to use for right outer join in WHERE clause
	$autoRollback = false
	whether ansi outer join syntax supported
	$poorAffectedRows = false
	$fnExecute = false
	$fnCacheExecute = false
	$blobEncodeType = false
	$rsPrefix = "ADORecordSet_"
	$autoCommit = true
	$transOff = 0
	do not modify this yourself - actually private
	$transCnt = 0
	temporarily disable transactions
	$fetchMode = false
	count of nested transactions
	$_oldRaiseFn = false
	$_transOK = null
	$_connectionID = false
	$_errorMsg = false
	The returned link identifier whenever a successful database connection is made.
	$_errorCode = false
	then returned by the errorMsg() function
	$_queryID = false
	Last error code, not guaranteed to be used - only by oci8.
	$_isPersistentConnection = false
	This variable keeps the last created result link identifier.
	$_bindInputArray = false
	A boolean variable to state whether its a persistent connection or normal connection. */.
	$_evalAll = false
	set to true if ADOConnection.Execute() permits binding of array parameters.
	$_affected = false
	$_logsql = false

Detailed Description

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

Definition at line 232 of file adodb.inc.php.

Constructor & Destructor Documentation

ADOConnection.ADOConnection ( )

Constructor
Definition at line 321 of file adodb.inc.php.

Member Function Documentation

ADOConnection._dirFlush ( $ dir,

$ kill_top_level = false

)

Private function to erase all of the files and subdirectories in a directory.
Just specify the directory, and tell it if you want to delete the directory or just clear it out. Note: $kill_top_level is used internally in the function to flush subdirectories.
Definition at line 1546 of file adodb.inc.php.

& ADOConnection._Execute ( $ sql,

$ inputarr = false

)

Reimplemented in ADODB_csv, and ADODB_ibase.
Definition at line 863 of file adodb.inc.php.

ADOConnection._findschema ( &$ table,

&$ schema

)

Definition at line 2121 of file adodb.inc.php.

ADOConnection._findvers ( $ str )

Definition at line 349 of file adodb.inc.php.

ADOConnection._gencachename ( $ sql,

$ createdir

)

Private function to generate filename for caching. Filename is generated based on:

sql statement
database type (oci8, ibase, ifx, etc)
database name
userid
setFetchMode (adodb 4.23)

When not in safe mode, we create 256 sub-directories in the cache directory ($ADODB_CACHE_DIR). Assuming that we can have 50,000 files per directory with good performance, then we can scale to 12.8 million unique cached recordsets. Wow!
Definition at line 1606 of file adodb.inc.php.

ADOConnection._nconnect ( $ argHostname,

$ argUsername,

$ argPassword,

$ argDatabaseName

)

Reimplemented in ADODB_mysql, ADODB_oci8, and ADODB_postgres64.
Definition at line 432 of file adodb.inc.php.

& ADOConnection._rs2rs ( &$ rs,

$ nrows = -1,

$ offset = -1,

$ close = true

)

Convert database recordset to an array recordset input recordset's cursor should be at beginning, and old $rs will be closed.

Parameters:

rs the recordset to copy

[nrows] number of rows to retrieve (optional)

[offset] offset by number of rows (optional)

Returns:
the new recordset

Definition at line 1184 of file adodb.inc.php.

ADOConnection.addq ( $ s,

$ magic_quotes = false

)

Quotes a string, without prefixing nor appending quotes.
Definition at line 2388 of file adodb.inc.php.

ADOConnection.Affected_Rows ( )

Returns:
# rows affected by UPDATE/DELETE

Definition at line 995 of file adodb.inc.php.

& ADOConnection.AutoExecute ( $ table,

$ fields_values,

$ mode = 'INSERT',

$ where = FALSE,

$ forceUpdate = true,

$ magicq = false

)

Definition at line 1732 of file adodb.inc.php.

ADOConnection.BeginTrans ( )

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

Returns:
true if succeeded or false if database does not support transactions

Reimplemented in ADODB_access, ADODB_ado, ADODB_ado, ADODB_ado_access, ADODB_borland_ibase, ADODB_db2, ADODB_ibase, ADODB_mysql, ADODB_mysqlt, ADODB_oci8, ADODB_odbc, ADODB_odbtp, ADODB_oracle, ADODB_pdo, ADODB_postgres64, ADODB_sqlite, ADODB_sybase, and ADODB_vfp.
Definition at line 2017 of file adodb.inc.php.

ADOConnection.BlobDecode ( $ blob )

Reimplemented in ADODB_ibase.
Definition at line 1856 of file adodb.inc.php.

ADOConnection.BlobEncode ( $ blob )

Reimplemented in ADODB_ibase, and ADODB_postgres64.
Definition at line 1861 of file adodb.inc.php.

& ADOConnection.CacheExecute ( $ secs2cache,

$ sql = false,

$ inputarr = false

)

Execute SQL, caching recordsets.

Parameters:

[secs2cache] seconds to cache data, set to 0 to force query. This is an optional parameter.

sql SQL statement to execute

[inputarr] holds the input data to bind to

Returns:
RecordSet or false

Definition at line 1641 of file adodb.inc.php.

ADOConnection.CacheFlush ( $ sql = false,

$ inputarr = false

)

Flush cached recordsets that match a particular $sql statement. If $sql == false, then we purge all files in the cache.
Definition at line 1512 of file adodb.inc.php.

& ADOConnection.CacheGetAll ( $ secs2cache,

$ sql = false,

$ inputarr = false

)

Definition at line 1373 of file adodb.inc.php.

& ADOConnection.CacheGetArray ( $ secs2cache,

$ sql = false,

$ inputarr = false

)

Definition at line 1378 of file adodb.inc.php.

& ADOConnection.CacheGetAssoc ( $ secs2cache,

$ sql = false,

$ inputarr = false,

$ force_array = false,

$ first2cols = false

)

Definition at line 1240 of file adodb.inc.php.

ADOConnection.CacheGetCol ( $ secs,

$ sql = false,

$ inputarr = false,

$ trim = false

)

Definition at line 1312 of file adodb.inc.php.

ADOConnection.CacheGetOne ( $ secs2cache,

$ sql = false,

$ inputarr = false

)

Definition at line 1278 of file adodb.inc.php.

& ADOConnection.CacheGetRow ( $ secs2cache,

$ sql = false,

$ inputarr = false

)

Definition at line 1428 of file adodb.inc.php.

& ADOConnection.CachePageExecute ( $ secs2cache,

$ sql,

$ nrows,

$ page,

$ inputarr = false

)

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.

Parameters:

secs2cache seconds to cache data, set to 0 to force query

sql

nrows is the number of rows per page to get

page is the page number to get (1-based)

[inputarr] array of bind variables

Returns:
the recordset ($rs->databaseType == 'array')

Definition at line 2485 of file adodb.inc.php.

& ADOConnection.CacheSelectLimit ( $ secs2cache,

$ sql,

$ nrows = -1,

$ offset = -1,

$ inputarr = false

)

Will select, getting rows from $offset (1-based), for $nrows. This simulates the MySQL "select * from table limit $offset,$nrows" , and the PostgreSQL "select * from table limit $nrows offset $offset". Note that MySQL and PostgreSQL parameter ordering is the opposite of the other. eg. CacheSelectLimit(15,'select * from table',3); will return rows 1 to 3 (1-based) CacheSelectLimit(15,'select * from table',3,2); will return rows 3 to 5 (1-based)
BUG: Currently CacheSelectLimit fails with $sql with LIMIT or TOP clause already set

Parameters:

[secs2cache] seconds to cache data, set to 0 to force query. This is optional

sql

[offset] is the row to start calculations from (1-based)

[nrows] is the number of rows to get

[inputarr] array of bind variables

Returns:
the recordset ($rs->databaseType == 'array')

Definition at line 1488 of file adodb.inc.php.

ADOConnection.Close ( )

Close Connection
Definition at line 2005 of file adodb.inc.php.

ADOConnection.CommitLock ( $ table )

Definition at line 588 of file adodb.inc.php.

ADOConnection.CommitTrans ( $ ok = true )

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

Parameters:

$ok set to false to rollback transaction, true to commit

Returns:
true/false.

Reimplemented in ADODB_ado, ADODB_ado, ADODB_db2, ADODB_ibase, ADODB_mysqlt, ADODB_oci8, ADODB_odbc, ADODB_odbtp, ADODB_oracle, ADODB_pdo, ADODB_postgres64, ADODB_sqlite, and ADODB_sybase.
Definition at line 2027 of file adodb.inc.php.

ADOConnection.CompleteTrans ( $ autoComplete = true )

Used together with StartTrans() to end a transaction. Monitors connection for sql errors, and will commit or rollback as appropriate.
if true, monitor sql errors and commit and rollback as appropriate, and if set to false force rollback even if no SQL error detected.
Returns:
true on commit, false on rollback.

Definition at line 735 of file adodb.inc.php.

ADOConnection.Concat ( )

Different SQL databases used different methods to combine strings together. This function provides a wrapper.
param s variable number of string parameters
Usage: $db->Concat($str1,$str2);

Returns:
concatenated string

Reimplemented in ADODB_fbsql, and ADODB_mysql.
Definition at line 2237 of file adodb.inc.php.

ADOConnection.Connect ( $ argHostname = "",

$ argUsername = "",

$ argPassword = "",

$ argDatabaseName = "",

$ forceNew = false

)

Connect to database

Parameters:

[argHostname] Host to connect to

[argUsername] Userid to login

[argPassword] Associated password

[argDatabaseName] database

[forceNew] force new connection

Returns:
true or false

Definition at line 402 of file adodb.inc.php.

ADOConnection.CreateSequence ( $ seqname = 'adodbseq',

$ startID = 1

)

Reimplemented in ADODB_db2, ADODB_ibase, ADODB_mysql, ADODB_odbc, ADODB_odbtp, and ADODB_sqlite.
Definition at line 912 of file adodb.inc.php.

ADOConnection.DBDate ( $ d )

Converts a date "d" to a string that the database can understand.

Parameters:

d a date in Unix date time format.

Returns:
date string in database date format

Reimplemented in ADODB_oci8, and ADODB_oracle.
Definition at line 2251 of file adodb.inc.php.

ADOConnection.DBTimeStamp ( $ ts )

Converts a timestamp "ts" to a string that the database can understand.

Parameters:

ts a timestamp in Unix date time format.

Returns:
timestamp string in database timestamp format

Reimplemented in ADODB_oci8, and ADODB_oracle.
Definition at line 2272 of file adodb.inc.php.

ADOConnection.Disconnect ( )

PEAR DB Compat - do not use internally
Definition at line 645 of file adodb.inc.php.

ADOConnection.DropSequence ( $ seqname = 'adodbseq' )

Reimplemented in ADODB_db2, ADODB_ibase, ADODB_odbc, ADODB_odbtp, and ADODB_sqlite.
Definition at line 918 of file adodb.inc.php.

ADOConnection.ErrorMsg ( )

Returns:
the last error message

Reimplemented in ADODB_ado, ADODB_ado, ADODB_csv, ADODB_db2, ADODB_fbsql, ADODB_ibase, ADODB_mysql, ADODB_oci8, ADODB_odbc, ADODB_odbtp, ADODB_oracle, ADODB_pdo, ADODB_postgres64, ADODB_sqlite, ADODB_sybase, and ADODB_sybase_ase.
Definition at line 1013 of file adodb.inc.php.

ADOConnection.ErrorNative ( )

PEAR DB Compat - do not use internally.
Definition at line 562 of file adodb.inc.php.

ADOConnection.ErrorNo ( )

Returns:
the last error number. Normally 0 means no error.

Reimplemented in ADODB_ado, ADODB_ado, ADODB_csv, ADODB_db2, ADODB_fbsql, ADODB_ibase, ADODB_mysql, ADODB_oci8, ADODB_odbc, ADODB_odbtp, ADODB_oracle, ADODB_pdo, ADODB_postgres64, and ADODB_sqlite.
Definition at line 1023 of file adodb.inc.php.

ADOConnection.escape ( $ s,

$ magic_quotes = false

)

Definition at line 2380 of file adodb.inc.php.

& ADOConnection.Execute ( $ sql,

$ inputarr = false

)

Execute SQL

Parameters:

sql SQL statement to execute, or possibly an array holding prepared statement ($sql[0] will hold sql text)

[inputarr] holds the input data to bind to. Null elements will be set to null.

Returns:
RecordSet or false

Reimplemented in ADODB_oci8.
Definition at line 790 of file adodb.inc.php.

ADOConnection.FailTrans ( )

Definition at line 762 of file adodb.inc.php.

ADOConnection.GenID ( $ seqname = 'adodbseq',

$ startID = 1

)

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

Parameters:

seqname name of sequence to use

startID if sequence does not exist, start at this ID

Returns:
0 if not supported, otherwise a sequence id

Reimplemented in ADODB_db2, ADODB_ibase, ADODB_mysql, ADODB_odbc, ADODB_odbtp, and ADODB_sqlite.
Definition at line 932 of file adodb.inc.php.

& ADOConnection.GetActiveRecords ( $ table,

$ where = false,

$ bindarr = false,

$ primkeyArr = false

)

Definition at line 1996 of file adodb.inc.php.

& ADOConnection.GetActiveRecordsClass ( $ class,

$ table,

$ whereOrderBy = false,

$ bindarr = false,

$ primkeyArr = false

)

Definition at line 1959 of file adodb.inc.php.

& ADOConnection.GetAll ( $ sql,

$ inputarr = false

)

Definition at line 1223 of file adodb.inc.php.

& ADOConnection.GetArray ( $ sql,

$ inputarr = false

)

Parameters:

sql SQL statement

[inputarr] input bind array

Definition at line 1352 of file adodb.inc.php.

& ADOConnection.GetAssoc ( $ sql,

$ inputarr = false,

$ force_array = false,

$ first2cols = false

)

Definition at line 1229 of file adodb.inc.php.

ADOConnection.GetCharSet ( )

Reimplemented in ADODB_postgres7.
Definition at line 1889 of file adodb.inc.php.

ADOConnection.GetCol ( $ sql,

$ inputarr = false,

$ trim = false

)

Definition at line 1290 of file adodb.inc.php.

ADOConnection.GetInsertSQL ( &$ rs,

$ arrFields,

$ magicq = false,

$ force = null

)

Generates an Insert Query based on an existing recordset. $arrFields is an associative array of fields with the value that should be assigned.
Note: This function should only be used on a recordset that is run against a single table.
Definition at line 1801 of file adodb.inc.php.

ADOConnection.GetOne ( $ sql,

$ inputarr = false

)

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

Parameters:

sql SQL statement

[inputarr] input bind array

Reimplemented in ADODB_mysql.
Definition at line 1262 of file adodb.inc.php.

& ADOConnection.GetRow ( $ sql,

$ inputarr = false

)

Return one row of sql statement. Recordset is disposed for you.

Parameters:

sql SQL statement

[inputarr] input bind array

Definition at line 1408 of file adodb.inc.php.

ADOConnection.GetUpdateSQL ( &$ rs,

$ arrFields,

$ forceUpdate = false,

$ magicq = false,

$ force = null

)

Generates an Update Query based on an existing recordset. $arrFields is an associative array of fields with the value that should be assigned.
Note: This function should only be used on a recordset that is run against a single table and sql should only be a simple select stmt with no groupby/orderby/limit
"Jonathan Younger" <jyounger@unilab.com>
Definition at line 1776 of file adodb.inc.php.

ADOConnection.HasFailedTrans ( )

Check if transaction has failed, only for Smart Transactions.
Definition at line 777 of file adodb.inc.php.

ADOConnection.IfNull ( $ field,

$ ifNull

)

Reimplemented in ADODB_access, ADODB_mysql, ADODB_oci8, ADODB_DB2, ADODB_odbc_mssql, ADODB_odbtp, and ADODB_postgres64.
Definition at line 1871 of file adodb.inc.php.

ADOConnection.InParameter ( &$ stmt,

&$ var,

$ name,

$ maxLen = 4000,

$ type = false

)

Reimplemented in ADODB_pdo.
Definition at line 667 of file adodb.inc.php.

ADOConnection.Insert_ID ( $ table = '',

$ column = ''

)

Parameters:

$table string name of the table, not needed by all databases (eg. mysql), default ''

$column string name of the column, not needed by all databases (eg. mysql), default ''

Returns:
the last inserted ID. Not all databases support this.

Definition at line 965 of file adodb.inc.php.

ADOConnection.IsConnected ( )

Definition at line 344 of file adodb.inc.php.

& ADOConnection.LimitQuery ( $ sql,

$ offset,

$ count,

$ params = false

)

PEAR DB Compat - do not use internally
Definition at line 634 of file adodb.inc.php.

ADOConnection.LogSQL ( $ enable = true )

Definition at line 1876 of file adodb.inc.php.

& ADOConnection.MetaColumnNames ( $ table,

$ numIndexes = false

)

List columns names in a table as an array.
Parameters:

table table name to query

Returns:
array of column names for current table.

Definition at line 2210 of file adodb.inc.php.

& ADOConnection.MetaColumns ( $ table,

$ normalize = true

)

List columns in a database as an array of ADOFieldObjects. See top of file for definition of object.

Parameters:

$table table name to query

$normalize makes table name case-insensitive (required by some databases) is optional database schema to use - not supported by all databases.

Returns:
array of ADOFieldObjects for current table.

Reimplemented in ADODB_netezza, ADODB_odbtp, ADODB_pdo, ADODB_pdo_pgsql, and ADODB_sybase_ase.
Definition at line 2139 of file adodb.inc.php.

ADOConnection.MetaDatabases ( )

return the databases that the driver can connect to. Some databases will return an empty array.

Returns:
an array of database names.

Reimplemented in ADODB_csv, ADODB_fbsql, ADODB_mysql, and ADODB_sybase_ase.
Definition at line 2046 of file adodb.inc.php.

ADOConnection.MetaError ( $ err = false )

Definition at line 1028 of file adodb.inc.php.

ADOConnection.MetaErrorMsg ( $ errno )

Definition at line 1035 of file adodb.inc.php.

ADOConnection.MetaForeignKeys ( $ table,

$ owner = false,

$ upper = false

)

Returns:
assoc array where keys are tables, and values are foreign keys

Reimplemented in ADODB_odbc_mssql, ADODB_odbtp, and ADODB_postgres7.
Definition at line 1064 of file adodb.inc.php.

& ADOConnection.MetaIndexes ( $ table,

$ primary = false,

$ owner = false

)

List indexes on a table as an array.
Parameters:

table table name to query

primary true to only show primary keys. Not actually used for most databases

Returns:
array of indexes on current table. Each element represents an index, and is itself an associative array.
Array ( [name_of_index] => Array ( [unique] => true or false [columns] => Array ( [0] => firstname [1] => lastname ) )
Reimplemented in ADODB_ibase, ADODB_mysql, ADODB_oci8, ADODB_DB2, and ADODB_sqlite.
Definition at line 2198 of file adodb.inc.php.

ADOConnection.MetaPrimaryKeys ( $ table,

$ owner = false

)

Returns:
an array with the primary key columns in it.

Reimplemented in ADODB_odbtp.
Definition at line 1044 of file adodb.inc.php.

& ADOConnection.MetaTables ( $ ttype = false,

$ showSchema = false,

$ mask = false

)

Parameters:

ttype can either be 'VIEW' or 'TABLE' or false. If false, both views and tables are returned. "VIEW" returns only views "TABLE" returns only tables

showSchema returns the schema/user with the table name, eg. USER.TABLE

mask is the input mask - only supported by oci8 and postgresql

Returns:
array of tables for current database.

Reimplemented in ADODB_mysql, ADODB_oci8, ADODB_odbc_mssql, ADODB_odbtp, ADODB_pdo, ADODB_pdo_mysql, ADODB_pdo_oci, ADODB_pdo_pgsql, ADODB_postgres64, and ADODB_sybase_ase.
Definition at line 2077 of file adodb.inc.php.

ADOConnection.MetaType ( $ t,

$ len = -1,

$ fieldobj = false

)

Definition at line 1908 of file adodb.inc.php.

ADOConnection.NConnect ( $ argHostname = "",

$ argUsername = "",

$ argPassword = "",

$ argDatabaseName = ""

)

Always force a new connection to database - currently only works with oracle

Parameters:

[argHostname] Host to connect to

[argUsername] Userid to login

[argPassword] Associated password

[argDatabaseName] database

Returns:
true or false

Definition at line 448 of file adodb.inc.php.

ADOConnection.nextId ( $ seq_name )

PEAR DB Compat - do not use internally.
Definition at line 571 of file adodb.inc.php.

ADOConnection.OffsetDate ( $ dayFraction,

$ date = false

)

Reimplemented in ADODB_mysql.
Definition at line 1340 of file adodb.inc.php.

ADOConnection.outp ( $ msg,

$ newline = true

)

All error messages go through this bottleneck function. You can define your own handler by defining the function name in ADODB_OUTP.
Definition at line 359 of file adodb.inc.php.

ADOConnection.OutParameter ( &$ stmt,

&$ var,

$ name,

$ maxLen = 4000,

$ type = false

)

Definition at line 674 of file adodb.inc.php.

& ADOConnection.PageExecute ( $ sql,

$ nrows,

$ page,

$ inputarr = false,

$ secs2cache = 0

)

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.
See readme.htm.ex8 for an example of usage.

Parameters:

sql

nrows is the number of rows per page to get

page is the page number to get (1-based)

[inputarr] array of bind variables

[secs2cache] is a private parameter only used by jlim

Returns:
the recordset ($rs->databaseType == 'array')
NOTE: phpLens uses a different algorithm and does not use PageExecute().
Definition at line 2463 of file adodb.inc.php.

ADOConnection.Param ( $ name,

$ type = 'C'

)

Reimplemented in ADODB_oci8.
Definition at line 659 of file adodb.inc.php.

ADOConnection.Parameter ( &$ stmt,

&$ var,

$ name,

$ isOutput = false,

$ maxLen = 4000,

$ type = false

)

Reimplemented in ADODB_oci8, and ADODB_odbtp.
Definition at line 695 of file adodb.inc.php.

ADOConnection.PConnect ( $ argHostname = "",

$ argUsername = "",

$ argPassword = "",

$ argDatabaseName = ""

)

Establish persistent connect to database

Parameters:

[argHostname] Host to connect to

[argUsername] Userid to login

[argPassword] Associated password

[argDatabaseName] database

Returns:
return true or false

Definition at line 463 of file adodb.inc.php.

ADOConnection.PO_Insert_ID ( $ table = "",

$ id = ""

)

Portable Insert ID. Pablo Roca <pabloroca.mvps.org>

Returns:
the last inserted ID. All databases support this. But aware possible problems in multiuser environments. Heavy test this before deploying.

Definition at line 983 of file adodb.inc.php.

ADOConnection.Prepare ( $ sql )

Should prepare the sql statement and return the stmt resource. For databases that do not support this, we return the $sql. To ensure compatibility with databases that do not support prepare:
$stmt = $db->Prepare("insert into table (id, name) values (?,?)"); $db->Execute($stmt,array(1,'Jill')) or die('insert failed'); $db->Execute($stmt,array(2,'Joe')) or die('insert failed');

Parameters:

sql SQL to send to database

Returns:
return FALSE, or the prepared statement, or the original sql if if the database does not support prepare.

Reimplemented in ADODB_db2, ADODB_ibase, ADODB_odbc, ADODB_odbtp, and ADODB_pdo.
Definition at line 514 of file adodb.inc.php.

ADOConnection.PrepareSP ( $ sql,

$ param = true

)

Some databases, eg. mssql require a different function for preparing stored procedures. So we cannot use Prepare().
Should prepare the stored procedure and return the stmt resource. For databases that do not support this, we return the $sql. To ensure compatibility with databases that do not support prepare:

Parameters:

sql SQL to send to database

Returns:
return FALSE, or the prepared statement, or the original sql if if the database does not support prepare.

Definition at line 533 of file adodb.inc.php.

ADOConnection.q ( &$ s )

Definition at line 554 of file adodb.inc.php.

ADOConnection.QMagic ( $ s )

Requested by "Karsten Dambekalns" <k.dambekalns@fishfarm.de>
Definition at line 549 of file adodb.inc.php.

ADOConnection.qstr ( $ s,

$ magic_quotes = false

)

Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes. An example is $db->qstr("Don't bother",magic_quotes_runtime());

Parameters:

s the string to quote

[magic_quotes] if $s is GET/POST var, set to get_magic_quotes_gpc(). This undoes the stupidity of magic quotes for GPC.

Returns:
quoted string to be sent back to database

Reimplemented in ADODB_mysql, ADODB_oci8, ADODB_postgres64, and ADODB_vfp.
Definition at line 2422 of file adodb.inc.php.

& ADOConnection.Query ( $ sql,

$ inputarr = false

)

PEAR DB Compat - do not use internally.
Definition at line 623 of file adodb.inc.php.

ADOConnection.Quote ( $ s )

PEAR DB Compat
Definition at line 541 of file adodb.inc.php.

ADOConnection.Replace ( $ table,

$ fieldArray,

$ keyCol,

$ autoQuote = false,

$ has_autoinc = false

)

Insert or replace a single record. Note: this is not the same as MySQL's replace. ADOdb's Replace() uses update-insert semantics, not insert-delete-duplicates of MySQL. Also note that no table locking is done currently, so it is possible that the record be inserted twice by two programs...
$this->Replace('products', array('prodname' =>"'Nails'","price" => 3.99), 'prodname');
$table table name $fieldArray associative array of data (you must quote strings yourself). $keyCol the primary key field name or if compound key, array of field names autoQuote set to true to use a hueristic to quote strings. Works with nulls and numbers but does not work with dates nor SQL functions. has_autoinc the primary key is an auto-inc field, so skip in insert.
Currently blob replace not supported
returns 0 = fail, 1 = update, 2 = insert
Definition at line 1461 of file adodb.inc.php.

ADOConnection.RollbackLock ( $ table )

Definition at line 593 of file adodb.inc.php.

ADOConnection.RollbackTrans ( )

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

Returns:
true/false.

Reimplemented in ADODB_ado, ADODB_ado, ADODB_ado_access, ADODB_db2, ADODB_ibase, ADODB_mysqlt, ADODB_oci8, ADODB_odbc, ADODB_odbtp, ADODB_oracle, ADODB_pdo, ADODB_postgres64, ADODB_sqlite, and ADODB_sybase.
Definition at line 2036 of file adodb.inc.php.

ADOConnection.RowLock ( $ table,

$ where

)

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

Parameters:

$table name of table to lock

$where where clause to use, eg: "WHERE row=12". If left empty, will escalate to table lock

Definition at line 583 of file adodb.inc.php.

ADOConnection.SelectDB ( $ dbName )

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

Parameters:

dbName is the name of the database to select

Returns:
true or false

Reimplemented in ADODB_fbsql, ADODB_ibase, ADODB_ldap, ADODB_mysql, ADODB_oci8, ADODB_odbtp, and ADODB_sybase.
Definition at line 1074 of file adodb.inc.php.

& ADOConnection.SelectLimit ( $ sql,

$ nrows = -1,

$ offset = -1,

$ inputarr = false,

$ secs2cache = 0

)

Will select, getting rows from $offset (1-based), for $nrows. This simulates the MySQL "select * from table limit $offset,$nrows" , and the PostgreSQL "select * from table limit $nrows offset $offset". Note that MySQL and PostgreSQL parameter ordering is the opposite of the other. eg. SelectLimit('select * from table',3); will return rows 1 to 3 (1-based) SelectLimit('select * from table',3,2); will return rows 3 to 5 (1-based)
Uses SELECT TOP for Microsoft databases (when $this->hasTop is set) BUG: Currently SelectLimit fails with $sql with LIMIT or TOP clause already set

Parameters:

sql

[offset] is the row to start calculations from (1-based)

[nrows] is the number of rows to get

[inputarr] array of bind variables

[secs2cache] is a private parameter only used by jlim

Returns:
the recordset ($rs->databaseType == 'array')

Reimplemented in ADODB_borland_ibase, ADODB_firebird, ADODB_mysql, ADODB_oci8, ADODB_oci805, ADODB_odbc_mssql, ADODB_odbtp, ADODB_pdo_base, ADODB_pdo, ADODB_pdo_mssql, ADODB_pdo_mysql, ADODB_pdo_pgsql, ADODB_postgres7, ADODB_sqlite, ADODB_sybase, and ADODB_vfp.
Definition at line 1097 of file adodb.inc.php.

& ADOConnection.SerializableRS ( &$ rs )

Create serializable recordset. Breaks rs link to connection.

Parameters:

rs the recordset to serialize

Definition at line 1165 of file adodb.inc.php.

ADOConnection.ServerInfo ( )

Get server version info...

Returns:
An array with 2 elements: $arr['string'] is the description string, and $arr[version] is the version (also a string).

Reimplemented in ADODB_ado, ADODB_ado, ADODB_borland_ibase, ADODB_db2, ADODB_firebird, ADODB_ibase, ADODB_ldap, ADODB_mysql, ADODB_oci8, ADODB_odbc, ADODB_DB2, ADODB_odbc_mssql, ADODB_odbtp, ADODB_pdo_base, ADODB_pdo, ADODB_pdo_mssql, ADODB_pdo_mysql, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_SAPDB, and ADODB_sqlite.
Definition at line 339 of file adodb.inc.php.

ADOConnection.SetCharSet ( $ charset )

Reimplemented in ADODB_postgres7.
Definition at line 1866 of file adodb.inc.php.

ADOConnection.SetDateLocale ( $ locale = 'En' )

Change the SQL connection locale to a specified locale. This is used to get the date formats written depending on the client locale.
Definition at line 1924 of file adodb.inc.php.

ADOConnection.SetFetchMode ( $ mode )

PEAR DB Compat - do not use internally.
The fetch modes for NUMERIC and ASSOC for PEAR DB and ADODB are identical for easy porting :-)

Parameters:

mode The fetchmode ADODB_FETCH_ASSOC or ADODB_FETCH_NUM

Returns:
The previous fetch mode

Definition at line 607 of file adodb.inc.php.

ADOConnection.SQLDate ( $ fmt,

$ col = false

)

Reimplemented in ADODB_ibase, ADODB_mysql, ADODB_oci8, ADODB_DB2, ADODB_odbc_mssql, ADODB_postgres64, ADODB_sqlite, and ADODB_sybase.
Definition at line 493 of file adodb.inc.php.

ADOConnection.StartTrans ( $ errfn = 'ADODB_TransMonitor' )

Improved method of initiating a transaction. Used together with CompleteTrans(). Advantages include:
a. StartTrans/CompleteTrans is nestable, unlike BeginTrans/CommitTrans/RollbackTrans. Only the outermost block is treated as a transaction.
b. CompleteTrans auto-detects SQL errors, and will rollback on errors, commit otherwise.
c. All BeginTrans/CommitTrans/RollbackTrans inside a StartTrans/CompleteTrans block are disabled, making it backward compatible.
Definition at line 710 of file adodb.inc.php.

ADOConnection.Time ( )

Reimplemented in ADODB_access, ADODB_oci8, ADODB_pdo, and ADODB_vfp.
Definition at line 383 of file adodb.inc.php.

ADOConnection.UnixDate ( $ v )

Also in ADORecordSet.
Parameters:

$v is a date string in YYYY-MM-DD format

Returns:
date in unix timestamp format, or 0 if before TIMESTAMP_FIRST_YEAR, or false if invalid date format

Reimplemented in ADODB_sybase.
Definition at line 2293 of file adodb.inc.php.

ADOConnection.UnixTimeStamp ( $ v )

Also in ADORecordSet.
Parameters:

$v is a timestamp string in YYYY-MM-DD HH-NN-SS format

Returns:
date in unix timestamp format, or 0 if before TIMESTAMP_FIRST_YEAR, or false if invalid date format

Reimplemented in ADODB_sybase.
Definition at line 2317 of file adodb.inc.php.

ADOConnection.UpdateBlob ( $ table,

$ column,

$ val,

$ where,

$ blobtype = 'BLOB'

)

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.
Note: $blobtype supports 'BLOB' and 'CLOB', default is BLOB of course.
Usage to update a $blobvalue which has a primary key blob_id=1 into a field blobtable.blobcolumn:
UpdateBlob('blobtable', 'blobcolumn', $blobvalue, 'blob_id=1');
Insert example:
$conn->Execute('INSERT INTO blobtable (id, blobcol) VALUES (1, null)'); $conn->UpdateBlob('blobtable','blobcol',$blob,'id=1');
Reimplemented in ADODB_db2, ADODB_ibase, ADODB_oci8, ADODB_odbc, and ADODB_odbtp.
Definition at line 1833 of file adodb.inc.php.

ADOConnection.UpdateBlobFile ( $ table,

$ column,

$ path,

$ where,

$ blobtype = 'BLOB'

)

Usage: UpdateBlob('TABLE', 'COLUMN', '/path/to/file', 'ID=1');
$blobtype supports 'BLOB' and 'CLOB'
$conn->Execute('INSERT INTO blobtable (id, blobcol) VALUES (1, null)'); $conn->UpdateBlob('blobtable','blobcol',$blobpath,'id=1');
Reimplemented in ADODB_ibase, ADODB_oci8, and ADODB_postgres64.
Definition at line 1847 of file adodb.inc.php.

ADOConnection.UpdateClob ( $ table,

$ column,

$ val,

$ where

)

Usage: UpdateClob('TABLE', 'COLUMN', $var, 'ID=1', 'CLOB');
$conn->Execute('INSERT INTO clobtable (id, clobcol) VALUES (1, null)'); $conn->UpdateClob('clobtable','clobcol',$clob,'id=1');
Definition at line 1901 of file adodb.inc.php.

ADOConnection.UserDate ( $ v,

$ fmt = 'Y-m-d',

$ gmt = false

)

Also in ADORecordSet.
Format database date based on user defined format.

Parameters:

v is the character date in YYYY-MM-DD format, returned by database

fmt is the format to apply to it, using date()

Returns:
a date formated as user desires

Definition at line 2347 of file adodb.inc.php.

ADOConnection.UserTimeStamp ( $ v,

$ fmt = 'Y-m-d H:i:s',

$ gmt = false

)

Parameters:

v is the character timestamp in YYYY-MM-DD hh:mm:ss format

fmt is the format to apply to it, using date()

Returns:
a timestamp formated as user desires

Definition at line 2368 of file adodb.inc.php.

ADOConnection.Version ( )

Definition at line 326 of file adodb.inc.php.

ADOConnection.xCacheFlush ( $ sql = false,

$ inputarr = false

)

Definition at line 1562 of file adodb.inc.php.

Member Data Documentation

ADOConnection.$_affected = false

Definition at line 315 of file adodb.inc.php.

ADOConnection.$_bindInputArray = false

A boolean variable to state whether its a persistent connection or normal connection. */.

Reimplemented in ADODB_access, ADODB_ado, ADODB_db2, ADODB_ibase, ADODB_oci8, ADODB_odbc, ADODB_DB2, ADODB_odbc_mssql, ADODB_odbtp, ADODB_pdo, ADODB_pdo_mysql, ADODB_postgres64, ADODB_SAPDB, and ADODB_vfp.
Definition at line 313 of file adodb.inc.php.

ADOConnection.$_connectionID = false

Definition at line 306 of file adodb.inc.php.

ADOConnection.$_errorCode = false

then returned by the errorMsg() function
A variable which was used to keep the returned last error message. The value will
Definition at line 309 of file adodb.inc.php.

ADOConnection.$_errorMsg = false

The returned link identifier whenever a successful database connection is made.

Definition at line 307 of file adodb.inc.php.

ADOConnection.$_evalAll = false

set to true if ADOConnection.Execute() permits binding of array parameters.

Definition at line 314 of file adodb.inc.php.

ADOConnection.$_isPersistentConnection = false

This variable keeps the last created result link identifier.

Definition at line 312 of file adodb.inc.php.

ADOConnection.$_logsql = false

Definition at line 316 of file adodb.inc.php.

ADOConnection.$_oldRaiseFn = false

Definition at line 304 of file adodb.inc.php.

ADOConnection.$_queryID = false

Last error code, not guaranteed to be used - only by oci8.

Definition at line 310 of file adodb.inc.php.

ADOConnection.$_transOK = null

Definition at line 305 of file adodb.inc.php.

ADOConnection.$ansiOuter = false

operator to use for right outer join in WHERE clause

Reimplemented in ADODB_ado_mssql, ADODB_ibase, ADODB_mysqlt, ADODB_netezza, ADODB_DB2, ADODB_odbc_mssql, ADODB_postgres7, and ADODB_vfp.
Definition at line 287 of file adodb.inc.php.

ADOConnection.$arrayClass = 'ADORecordSet_array'

name of function that returns the current timestamp

Reimplemented in ADODB_sybase.
Definition at line 278 of file adodb.inc.php.

ADOConnection.$autoCommit = true

Definition at line 296 of file adodb.inc.php.

ADOConnection.$autoRollback = false

whether ansi outer join syntax supported

Reimplemented in ADODB_mysqlt, ADODB_netezza, and ADODB_postgres64.
Definition at line 288 of file adodb.inc.php.

ADOConnection.$blobEncodeType = false

Reimplemented in ADODB_ibase, ADODB_netezza, ADODB_pdo_pgsql, and ADODB_postgres64.
Definition at line 293 of file adodb.inc.php.

ADOConnection.$cacheSecs = 3600

accepts dates in ISO format

Definition at line 275 of file adodb.inc.php.

ADOConnection.$charSet = false

string to use to quote identifiers and names

Reimplemented in ADODB_postgres7.
Definition at line 255 of file adodb.inc.php.

ADOConnection.$concat_operator = '+'

maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro

Reimplemented in ADODB_ibase, ADODB_netezza, ADODB_oci8, ADODB_DB2, ADODB_odbc_oracle, ADODB_oracle, ADODB_pdo_oci, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_SAPDB, ADODB_sqlite, and ADODB_sybase.
Definition at line 244 of file adodb.inc.php.

ADOConnection.$database = ''

RDBMS currently in use, eg. odbc, mysql, mssql.

Definition at line 238 of file adodb.inc.php.

ADOConnection.$databaseType = ''

Reimplemented in ADODB_access, ADODB_ado, ADODB_ado_access, ADODB_ado_mssql, ADODB_borland_ibase, ADODB_csv, ADODB_db2, ADODB_fbsql, ADODB_firebird, ADODB_ibase, ADODB_ldap, ADODB_mysql, ADODB_mysqlt, ADODB_netezza, ADODB_oci8, ADODB_oci805, ADODB_oci8po, ADODB_odbc, ADODB_DB2, ADODB_odbc_mssql, ADODB_odbc_oracle, ADODB_odbtp, ADODB_odbtp_unicode, ADODB_oracle, ADODB_pdo, ADODB_postgres64, ADODB_postgres7, ADODB_proxy, ADODB_SAPDB, ADODB_sqlanywhere, ADODB_sqlite, ADODB_sqlitepo, ADODB_sybase, ADODB_sybase_ase, and ADODB_vfp.
Definition at line 237 of file adodb.inc.php.

ADOConnection.$dataProvider = 'native'

Reimplemented in ADODB_ado, ADODB_db2, ADODB_ibase, ADODB_ldap, ADODB_mysql, ADODB_netezza, ADODB_oci8, ADODB_oci8po, ADODB_odbc, ADODB_odbtp, ADODB_pdo, ADODB_postgres64, and ADODB_sybase.
Definition at line 236 of file adodb.inc.php.

ADOConnection.$debug = false

Password for the username. For security, we no longer store it.

Definition at line 242 of file adodb.inc.php.

ADOConnection.$emptyDate = ' '

All order by columns have to be unique.

Definition at line 259 of file adodb.inc.php.

ADOConnection.$emptyTimeStamp = ' '

Definition at line 260 of file adodb.inc.php.

ADOConnection.$false = '0'

string that represents TRUE for a database

Reimplemented in ADODB_netezza, ADODB_pdo_pgsql, ADODB_postgres64, and ADODB_vfp.
Definition at line 252 of file adodb.inc.php.

ADOConnection.$fetchMode = false

count of nested transactions

Definition at line 300 of file adodb.inc.php.

ADOConnection.$fmtDate = "'Y-m-d'"

uppercase function

Reimplemented in ADODB_access, ADODB_ado, ADODB_ado_access, ADODB_db2, ADODB_ibase, ADODB_netezza, ADODB_odbc, ADODB_odbc_mssql, ADODB_odbc_oracle, ADODB_odbtp, ADODB_pdo, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_SAPDB, ADODB_sybase, and ADODB_vfp.
Definition at line 249 of file adodb.inc.php.

ADOConnection.$fmtTimeStamp = "'Y-m-d, h:i:s A'"

used by DBDate() as the default date format used by the database

Reimplemented in ADODB_access, ADODB_ado, ADODB_ado_access, ADODB_csv, ADODB_db2, ADODB_fbsql, ADODB_ibase, ADODB_mysql, ADODB_netezza, ADODB_odbc, ADODB_DB2, ADODB_odbc_mssql, ADODB_odbc_oracle, ADODB_odbtp, ADODB_pdo, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_SAPDB, ADODB_sqlite, ADODB_sybase, and ADODB_vfp.
Definition at line 250 of file adodb.inc.php.

ADOConnection.$fnCacheExecute = false

Definition at line 292 of file adodb.inc.php.

ADOConnection.$fnExecute = false

Definition at line 291 of file adodb.inc.php.

ADOConnection.$genID = 0

has transactions

Definition at line 272 of file adodb.inc.php.

ADOConnection.$hasAffectedRows = false

supports autoincrement ID?

Reimplemented in ADODB_ado, ADODB_csv, ADODB_db2, ADODB_fbsql, ADODB_ibase, ADODB_mysql, ADODB_netezza, ADODB_oci8, ADODB_odbc, ADODB_odbtp, ADODB_pdo, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_sqlite, and ADODB_sybase.
Definition at line 264 of file adodb.inc.php.

ADOConnection.$hasGenID = false

has ability to run MoveFirst(), scrolling backwards

Reimplemented in ADODB_ibase, ADODB_mysql, ADODB_oci8, ADODB_odbtp, ADODB_pdo_pgsql, and ADODB_postgres64.
Definition at line 269 of file adodb.inc.php.

ADOConnection.$hasInsertID = false

Reimplemented in ADODB_ado_mssql, ADODB_csv, ADODB_fbsql, ADODB_mysql, ADODB_netezza, ADODB_DB2, ADODB_odbc_mssql, ADODB_odbtp, ADODB_postgres64, ADODB_sqlanywhere, ADODB_sqlite, and ADODB_sybase.
Definition at line 263 of file adodb.inc.php.

ADOConnection.$hasLimit = false

support mssql/access SELECT TOP 10 * FROM TABLE

Reimplemented in ADODB_fbsql, ADODB_mysql, ADODB_netezza, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_postgres7, and ADODB_sqlite.
Definition at line 266 of file adodb.inc.php.

ADOConnection.$hasMoveFirst = false

this is a readonly database - used by phpLens

Reimplemented in ADODB_mysql, ADODB_odbtp, ADODB_pdo_pgsql, and ADODB_postgres64.
Definition at line 268 of file adodb.inc.php.

ADOConnection.$hasTop = false

supports affected rows for update/delete?

Reimplemented in ADODB_access, ADODB_ado_access, ADODB_ado_mssql, ADODB_odbc_mssql, ADODB_pdo_mssql, and ADODB_vfp.
Definition at line 265 of file adodb.inc.php.

ADOConnection.$hasTransactions = true

can generate sequences using GenID();

Reimplemented in ADODB_access, ADODB_ado_access, ADODB_csv, ADODB_mysql, ADODB_mysqlt, and ADODB_vfp.
Definition at line 270 of file adodb.inc.php.

ADOConnection.$host = ''

Name of database to be used.

Definition at line 239 of file adodb.inc.php.

ADOConnection.$isoDates = false

error function to call

Reimplemented in ADODB_mysql, ADODB_netezza, ADODB_pdo_pgsql, and ADODB_postgres64.
Definition at line 274 of file adodb.inc.php.

ADOConnection.$lastInsID = false

Definition at line 261 of file adodb.inc.php.

ADOConnection.$leftOuter = false

indicates that all fields in order by must be unique

Reimplemented in ADODB_ado_mssql, ADODB_oci8, ADODB_odbc_mssql, and ADODB_sybase.
Definition at line 285 of file adodb.inc.php.

ADOConnection.$length = 'length'

substring operator

Reimplemented in ADODB_ado_mssql, and ADODB_odbc_mssql.
Definition at line 246 of file adodb.inc.php.

ADOConnection.$maxblobsize = 262144

if set to true will output sql statements

Definition at line 243 of file adodb.inc.php.

ADOConnection.$metaDatabasesSQL = ''

character set to use - only for interbase, postgres and oci8

Reimplemented in ADODB_netezza, ADODB_oci8, ADODB_pdo_pgsql, ADODB_postgres64, and ADODB_sybase_ase.
Definition at line 256 of file adodb.inc.php.

ADOConnection.$metaTablesSQL = ''

Reimplemented in ADODB_fbsql, ADODB_ibase, ADODB_mysql, ADODB_netezza, ADODB_oci8, ADODB_oci8po, ADODB_odbc_mssql, ADODB_odbc_oracle, ADODB_oracle, ADODB_pdo_mysql, ADODB_pdo_oci, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_sqlite, ADODB_sybase, and ADODB_sybase_ase.
Definition at line 257 of file adodb.inc.php.

ADOConnection.$nameQuote = '"'

string to use to replace quotes

Reimplemented in ADODB_mysql.
Definition at line 254 of file adodb.inc.php.

ADOConnection.$noNullStrings = false

name of class used to generate array recordsets, which are pre-downloaded recordsets

Reimplemented in ADODB_oci8.
Definition at line 280 of file adodb.inc.php.

ADOConnection.$numCacheHits = 0

oracle specific stuff - if true ensures that '' is converted to ' '

Definition at line 281 of file adodb.inc.php.

ADOConnection.$numCacheMisses = 0

Definition at line 282 of file adodb.inc.php.

ADOConnection.$pageExecuteCountRows = true

Definition at line 283 of file adodb.inc.php.

ADOConnection.$password = ''

The username which is used to connect to the database server.

Reimplemented in ADODB_ldap.
Definition at line 241 of file adodb.inc.php.

ADOConnection.$poorAffectedRows = false

Reimplemented in ADODB_ado, ADODB_ibase, and ADODB_mysql.
Definition at line 289 of file adodb.inc.php.

ADOConnection.$raiseErrorFn = false

sequence id used by GenID();

Definition at line 273 of file adodb.inc.php.

ADOConnection.$random = 'rand()'

string length ofperator

Reimplemented in ADODB_netezza, ADODB_oci8, ADODB_pdo_oci, ADODB_pdo_pgsql, and ADODB_postgres64.
Definition at line 247 of file adodb.inc.php.

ADOConnection.$readOnly = false

support pgsql/mysql SELECT * FROM TABLE LIMIT 10

Definition at line 267 of file adodb.inc.php.

ADOConnection.$replaceQuote = "\\'"

string that represents FALSE for a database

Reimplemented in ADODB_ado, ADODB_csv, ADODB_db2, ADODB_ibase, ADODB_oci8, ADODB_odbc, ADODB_odbc_oracle, ADODB_odbtp, ADODB_oracle, ADODB_pdo, ADODB_sqlite, ADODB_sybase, and ADODB_vfp.
Definition at line 253 of file adodb.inc.php.

ADOConnection.$rightOuter = false

operator to use for left outer join in WHERE clause

Reimplemented in ADODB_ado_mssql, ADODB_odbc_mssql, and ADODB_sybase.
Definition at line 286 of file adodb.inc.php.

ADOConnection.$rsPrefix = "ADORecordSet_"

Definition at line 294 of file adodb.inc.php.

ADOConnection.$substr = 'substr'

default concat operator -- change to || for Oracle/Interbase

Reimplemented in ADODB_ado_mssql, ADODB_mysql, and ADODB_odbc_mssql.
Definition at line 245 of file adodb.inc.php.

ADOConnection.$sysDate = false

cache for 1 hour

Reimplemented in ADODB_access, ADODB_ado_access, ADODB_ado_mssql, ADODB_ibase, ADODB_mysql, ADODB_netezza, ADODB_oci8, ADODB_DB2, ADODB_odbc_mssql, ADODB_odbc_oracle, ADODB_oracle, ADODB_pdo_base, ADODB_pdo_mssql, ADODB_pdo_mysql, ADODB_pdo_oci, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_SAPDB, ADODB_sqlite, ADODB_sybase, and ADODB_vfp.
Definition at line 276 of file adodb.inc.php.

ADOConnection.$sysTimeStamp = false

name of function that returns the current date

Reimplemented in ADODB_access, ADODB_ado_access, ADODB_ado_mssql, ADODB_firebird, ADODB_ibase, ADODB_mysql, ADODB_netezza, ADODB_oci8, ADODB_DB2, ADODB_odbc_mssql, ADODB_odbc_oracle, ADODB_oracle, ADODB_pdo_base, ADODB_pdo_mssql, ADODB_pdo_mysql, ADODB_pdo_oci, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_SAPDB, ADODB_sqlite, and ADODB_vfp.
Definition at line 277 of file adodb.inc.php.

ADOConnection.$transCnt = 0

temporarily disable transactions

Definition at line 298 of file adodb.inc.php.

ADOConnection.$transOff = 0

do not modify this yourself - actually private

Definition at line 297 of file adodb.inc.php.

ADOConnection.$true = '1'

used by DBTimeStamp as the default timestamp fmt.

Reimplemented in ADODB_netezza, ADODB_pdo_pgsql, ADODB_postgres64, and ADODB_vfp.
Definition at line 251 of file adodb.inc.php.

ADOConnection.$uniqueOrderBy = false

Definition at line 258 of file adodb.inc.php.

ADOConnection.$uniqueSort = false

Definition at line 284 of file adodb.inc.php.

ADOConnection.$upperCase = 'upper'

random function

Definition at line 248 of file adodb.inc.php.

ADOConnection.$user = ''

The hostname of the database server.

Definition at line 240 of file adodb.inc.php.

The documentation for this class was generated from the following file:

typo3/sysext/adodb/adodb/adodb.inc.php

Generated on Fri Apr 7 10:48:43 2006 for TYPO3 by

1.4.6

ADOConnection Class Reference

Public Member Functions

Public Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Member Data Documentation