Solutions Open Source

Référence de la classe ADOConnection

Graphe d'héritage de ADOConnection:

Liste de tous les membres

Fonctions membres publiques

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)

IgnoreErrors ($saveErrs=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)

& Transpose (&$rs)

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, $memcache=false)

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

SetTransactionMode ($transaction_mode)

MetaTransaction ($mode, $db)

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, $useattnum=false)

Concat ()

DBDate ($d)

BindDate ($d)

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

Attributs publics

$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

$memCache = false

cache for 1 hour

$memCacheHost

should we use memCache instead of caching in files

$memCachePort = 11211

memCache host

$memCacheCompress = false

memCache port

$sysDate = false

Use 'true' to store the item compressed (uses zlib).

$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

$null2null = 'null'

$_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

$_transmode = ''

Description détaillée

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

Documentation des fonctions membres

ADOConnection::ADOConnection ( )

Constructor

ADOConnection::Version ( )

ADOConnection::ServerInfo ( )

Get server version info...

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

Réimplémentée dans ADODB_ado, ADODB_ado, ADODB_borland_ibase, ADODB_db2, ADODB_firebird, ADODB_ibase, ADODB_ldap, ADODB_mysql, ADODB_oci8, ADODB_odbc, ADODB_ODBC_DB2, ADODB_odbc_mssql, ADODB_odbtp, ADODB_pdo_base, ADODB_pdo, ADODB_pdo_mssql, ADODB_pdo_mysql, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_SAPDB, et ADODB_sqlite.

ADOConnection::IsConnected ( )

ADOConnection::_findvers ( $ str )

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.

ADOConnection::Time ( )

Réimplémentée dans ADODB_access, ADODB_oci8, ADODB_pdo, et ADODB_vfp.

ADOConnection::Connect	(	$	argHostname = `""`,
		$	argUsername = `""`,
		$	argPassword = `""`,
		$	argDatabaseName = `""`,
		$	forceNew = `false`
	)

Connect to database

Paramètres:

	[argHostname]	Host to connect to
	[argUsername]	Userid to login
	[argPassword]	Associated password
	[argDatabaseName]	database
	[forceNew]	force new connection

Renvoie:: true or false

ADOConnection::_nconnect	(	$	argHostname,
		$	argUsername,
		$	argPassword,
		$	argDatabaseName
	)

Réimplémentée dans ADODB_mysql, ADODB_oci8, et ADODB_postgres64.

ADOConnection::NConnect	(	$	argHostname = `""`,
		$	argUsername = `""`,
		$	argPassword = `""`,
		$	argDatabaseName = `""`
	)

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

Paramètres:

	[argHostname]	Host to connect to
	[argUsername]	Userid to login
	[argPassword]	Associated password
	[argDatabaseName]	database

Renvoie:: true or false

ADOConnection::PConnect	(	$	argHostname = `""`,
		$	argUsername = `""`,
		$	argPassword = `""`,
		$	argDatabaseName = `""`
	)

Establish persistent connect to database

Paramètres:

	[argHostname]	Host to connect to
	[argUsername]	Userid to login
	[argPassword]	Associated password
	[argDatabaseName]	database

Renvoie:: return true or false

ADOConnection::SQLDate	(	$	fmt,
		$	col = `false`
	)

Réimplémentée dans ADODB_db2, ADODB_ibase, ADODB_mysql, ADODB_oci8, ADODB_ODBC_DB2, ADODB_odbc_mssql, ADODB_postgres64, ADODB_sqlite, et ADODB_sybase.

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');

Paramètres:

sql

SQL to send to database

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

Réimplémentée dans ADODB_db2, ADODB_ibase, ADODB_odbc, ADODB_odbtp, et ADODB_pdo.

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:

Paramètres:

sql

SQL to send to database

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

ADOConnection::Quote ( $ s )

PEAR DB Compat

ADOConnection::QMagic ( $ s )

Requested by "Karsten Dambekalns" <k.dambekalns@fishfarm.de>

ADOConnection::q ( &$ s )

ADOConnection::ErrorNative ( )

PEAR DB Compat - do not use internally.

ADOConnection::nextId ( $ seq_name )

PEAR DB Compat - do not use internally.

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

Paramètres:

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

ADOConnection::CommitLock ( $ table )

ADOConnection::RollbackLock ( $ table )

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

Paramètres:

mode

The fetchmode ADODB_FETCH_ASSOC or ADODB_FETCH_NUM

Renvoie:: The previous fetch mode

& ADOConnection::Query	(	$	sql,
		$	inputarr = `false`
	)

PEAR DB Compat - do not use internally.

& ADOConnection::LimitQuery	(	$	sql,
		$	offset,
		$	count,
		$	params = `false`
	)

PEAR DB Compat - do not use internally

ADOConnection::Disconnect ( )

PEAR DB Compat - do not use internally

ADOConnection::Param	(	$	name,
		$	type = `'C'`
	)

Réimplémentée dans ADODB_oci8.

ADOConnection::InParameter	(	&$	stmt,
		&$	var,
		$	name,
		$	maxLen = `4000`,
		$	type = `false`
	)

Réimplémentée dans ADODB_pdo.

ADOConnection::OutParameter	(	&$	stmt,
		&$	var,
		$	name,
		$	maxLen = `4000`,
		$	type = `false`
	)

ADOConnection::Parameter	(	&$	stmt,
		&$	var,
		$	name,
		$	isOutput = `false`,
		$	maxLen = `4000`,
		$	type = `false`
	)

Réimplémentée dans ADODB_oci8, et ADODB_odbtp.

ADOConnection::IgnoreErrors ( $ saveErrs = false )

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.

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.

Renvoie:: true on commit, false on rollback.

ADOConnection::FailTrans ( )

ADOConnection::HasFailedTrans ( )

Check if transaction has failed, only for Smart Transactions.

& ADOConnection::Execute	(	$	sql,
		$	inputarr = `false`
	)

Execute SQL

Paramètres:

	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.

Renvoie:: RecordSet or false

Réimplémentée dans ADODB_oci8.

& ADOConnection::_Execute	(	$	sql,
		$	inputarr = `false`
	)

Réimplémentée dans ADODB_csv, et ADODB_ibase.

ADOConnection::CreateSequence	(	$	seqname = `'adodbseq'`,
		$	startID = `1`
	)

Réimplémentée dans ADODB_ado_mssql, ADODB_db2, ADODB_ibase, ADODB_mysql, ADODB_odbc, ADODB_odbtp, et ADODB_sqlite.

ADOConnection::DropSequence ( $ seqname = 'adodbseq' )

Réimplémentée dans ADODB_db2, ADODB_ibase, ADODB_odbc, ADODB_odbtp, et ADODB_sqlite.

ADOConnection::GenID	(	$	seqname = `'adodbseq'`,
		$	startID = `1`
	)

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

Paramètres:

	seqname	name of sequence to use
	startID	if sequence does not exist, start at this ID

Renvoie:: 0 if not supported, otherwise a sequence id

Réimplémentée dans ADODB_ado_mssql, ADODB_db2, ADODB_ibase, ADODB_mysql, ADODB_odbc, ADODB_odbtp, et ADODB_sqlite.

ADOConnection::Insert_ID	(	$	table = `''`,
		$	column = `''`
	)

Paramètres:

	$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 ''

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

ADOConnection::PO_Insert_ID	(	$	table = `""`,
		$	id = `""`
	)

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

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

ADOConnection::Affected_Rows ( )

Renvoie:: # rows affected by UPDATE/DELETE

ADOConnection::ErrorMsg ( )

Renvoie:: the last error message

Réimplémentée dans 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, et ADODB_sybase_ase.

ADOConnection::ErrorNo ( )

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

ADOConnection::MetaError ( $ err = false )

ADOConnection::MetaErrorMsg ( $ errno )

ADOConnection::MetaPrimaryKeys	(	$	table,
		$	owner = `false`
	)

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

Réimplémentée dans ADODB_odbtp.

ADOConnection::MetaForeignKeys	(	$	table,
		$	owner = `false`,
		$	upper = `false`
	)

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

Réimplémentée dans ADODB_odbc_mssql, ADODB_odbtp, et ADODB_postgres7.

ADOConnection::SelectDB ( $ dbName )

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

Paramètres:

dbName

is the name of the database to select

Renvoie:: true or false

Réimplémentée dans ADODB_fbsql, ADODB_ibase, ADODB_ldap, ADODB_mysql, ADODB_oci8, ADODB_odbtp, et ADODB_sybase.

& 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

Paramètres:

	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

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

Réimplémentée dans 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, et ADODB_vfp.

& ADOConnection::SerializableRS ( &$ rs )

Create serializable recordset. Breaks rs link to connection.

Paramètres:

the recordset to serialize

& 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.

Paramètres:

	rs	the recordset to copy
	[nrows]	number of rows to retrieve (optional)
	[offset]	offset by number of rows (optional)

Renvoie:: the new recordset

& ADOConnection::GetAll	(	$	sql,
		$	inputarr = `false`
	)

& ADOConnection::GetAssoc	(	$	sql,
		$	inputarr = `false`,
		$	force_array = `false`,
		$	first2cols = `false`
	)

& ADOConnection::CacheGetAssoc	(	$	secs2cache,
		$	sql = `false`,
		$	inputarr = `false`,
		$	force_array = `false`,
		$	first2cols = `false`
	)

ADOConnection::GetOne	(	$	sql,
		$	inputarr = `false`
	)

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

Paramètres:

	sql	SQL statement
	[inputarr]	input bind array

Réimplémentée dans ADODB_mysql.

ADOConnection::CacheGetOne	(	$	secs2cache,
		$	sql = `false`,
		$	inputarr = `false`
	)

ADOConnection::GetCol	(	$	sql,
		$	inputarr = `false`,
		$	trim = `false`
	)

ADOConnection::CacheGetCol	(	$	secs,
		$	sql = `false`,
		$	inputarr = `false`,
		$	trim = `false`
	)

& ADOConnection::Transpose ( &$ rs )

ADOConnection::OffsetDate	(	$	dayFraction,
		$	date = `false`
	)

Réimplémentée dans ADODB_mysql, ADODB_pdo_mysql, et ADODB_postgres64.

& ADOConnection::GetArray	(	$	sql,
		$	inputarr = `false`
	)

Paramètres:

	sql	SQL statement
	[inputarr]	input bind array

& ADOConnection::CacheGetAll	(	$	secs2cache,
		$	sql = `false`,
		$	inputarr = `false`
	)

& ADOConnection::CacheGetArray	(	$	secs2cache,
		$	sql = `false`,
		$	inputarr = `false`
	)

& ADOConnection::GetRow	(	$	sql,
		$	inputarr = `false`
	)

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

Paramètres:

	sql	SQL statement
	[inputarr]	input bind array

& ADOConnection::CacheGetRow	(	$	secs2cache,
		$	sql = `false`,
		$	inputarr = `false`
	)

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

& 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

Paramètres:

	[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

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

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. Flush cached recordsets that match a particular $sql statement. If $sql == false, then we purge all files in the cache.

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.

ADOConnection::xCacheFlush	(	$	sql = `false`,
		$	inputarr = `false`
	)

ADOConnection::_gencachename	(	$	sql,
		$	createdir,
		$	memcache = `false`
	)

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!

& ADOConnection::CacheExecute	(	$	secs2cache,
		$	sql = `false`,
		$	inputarr = `false`
	)

Execute SQL, caching recordsets.

Paramètres:

	[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

Renvoie:: RecordSet or false

& ADOConnection::AutoExecute	(	$	table,
		$	fields_values,
		$	mode = `'INSERT'`,
		$	where = `FALSE`,
		$	forceUpdate = `true`,
		$	magicq = `false`
	)

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>

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.

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');

Réimplémentée dans ADODB_db2, ADODB_ibase, ADODB_oci8, ADODB_odbc, ADODB_odbtp, et ADODB_postgres64.

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');

Réimplémentée dans ADODB_ibase, ADODB_oci8, et ADODB_postgres64.

ADOConnection::BlobDecode ( $ blob )

Réimplémentée dans ADODB_ibase.

ADOConnection::BlobEncode ( $ blob )

Réimplémentée dans ADODB_ibase, et ADODB_postgres64.

ADOConnection::SetCharSet ( $ charset )

Réimplémentée dans ADODB_postgres7.

ADOConnection::IfNull	(	$	field,
		$	ifNull
	)

Réimplémentée dans ADODB_access, ADODB_mysql, ADODB_oci8, ADODB_ODBC_DB2, ADODB_odbc_mssql, ADODB_odbtp, et ADODB_postgres64.

ADOConnection::LogSQL ( $ enable = true )

ADOConnection::GetCharSet ( )

Réimplémentée dans ADODB_postgres7.

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');

ADOConnection::MetaType	(	$	t,
		$	len = `-1`,
		$	fieldobj = `false`
	)

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.

& ADOConnection::GetActiveRecordsClass	(	$	class,
		$	table,
		$	whereOrderBy = `false`,
		$	bindarr = `false`,
		$	primkeyArr = `false`
	)

& ADOConnection::GetActiveRecords	(	$	table,
		$	where = `false`,
		$	bindarr = `false`,
		$	primkeyArr = `false`
	)

ADOConnection::Close ( )

Close Connection

ADOConnection::BeginTrans ( )

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

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

Réimplémentée dans 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, et ADODB_vfp.

ADOConnection::SetTransactionMode ( $ transaction_mode )

Réimplémentée dans ADODB_ado_mssql, ADODB_mysqlt, ADODB_odbc_mssql, ADODB_pdo_mssql, et ADODB_pdo_mysql.

ADOConnection::MetaTransaction	(	$	mode,
		$	db
	)

ADOConnection::CommitTrans ( $ ok = true )

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

Paramètres:

$ok

set to false to rollback transaction, true to commit

Renvoie:: true/false.

Réimplémentée dans ADODB_ado, ADODB_ado, ADODB_db2, ADODB_ibase, ADODB_mysqlt, ADODB_oci8, ADODB_odbc, ADODB_odbtp, ADODB_oracle, ADODB_pdo, ADODB_postgres64, ADODB_sqlite, et ADODB_sybase.

ADOConnection::RollbackTrans ( )

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

Renvoie:: true/false.

Réimplémentée dans 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, et ADODB_sybase.

ADOConnection::MetaDatabases ( )

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

Renvoie:: an array of database names.

Réimplémentée dans ADODB_csv, ADODB_fbsql, ADODB_mysql, et ADODB_sybase_ase.

& ADOConnection::MetaTables	(	$	ttype = `false`,
		$	showSchema = `false`,
		$	mask = `false`
	)

Paramètres:

	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

Renvoie:: array of tables for current database.

Réimplémentée dans ADODB_mysql, ADODB_oci8, ADODB_odbc_mssql, ADODB_odbtp, ADODB_pdo, ADODB_pdo_mysql, ADODB_pdo_oci, ADODB_pdo_pgsql, ADODB_postgres64, et ADODB_sybase_ase.

ADOConnection::_findschema	(	&$	table,
		&$	schema
	)

& ADOConnection::MetaColumns	(	$	table,
		$	normalize = `true`
	)

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

Paramètres:

	$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.

Renvoie:: array of ADOFieldObjects for current table.

Réimplémentée dans ADODB_netezza, ADODB_odbtp, ADODB_pdo, ADODB_pdo_pgsql, ADODB_postgres64, et ADODB_sybase_ase.

& ADOConnection::MetaIndexes	(	$	table,
		$	primary = `false`,
		$	owner = `false`
	)

List indexes on a table as an array.

Paramètres:

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

Renvoie:: 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 ) )

Réimplémentée dans ADODB_ibase, ADODB_mysql, ADODB_oci8, ADODB_ODBC_DB2, et ADODB_sqlite.

& ADOConnection::MetaColumnNames	(	$	table,
		$	numIndexes = `false`,
		$	useattnum = `false`
	)

List columns names in a table as an array.

Paramètres:

table

table name to query

Renvoie:: array of column names for current table.

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

Renvoie:: concatenated string

Réimplémentée dans ADODB_fbsql, et ADODB_mysql.

ADOConnection::DBDate ( $ d )

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

Paramètres:

a date in Unix date time format.

Renvoie:: date string in database date format

Réimplémentée dans ADODB_oci8, et ADODB_oracle.

ADOConnection::BindDate ( $ d )

Réimplémentée dans ADODB_oci8, et ADODB_oracle.

ADOConnection::BindTimeStamp ( $ d )

Réimplémentée dans ADODB_oci8, et ADODB_oracle.

ADOConnection::DBTimeStamp ( $ ts )

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

Paramètres:

a timestamp in Unix date time format.

Renvoie:: timestamp string in database timestamp format

Réimplémentée dans ADODB_db2, ADODB_oci8, et ADODB_oracle.

ADOConnection::UnixDate ( $ v )

Also in ADORecordSet.

Paramètres:

is a date string in YYYY-MM-DD format

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

Réimplémentée dans ADODB_sybase.

ADOConnection::UnixTimeStamp ( $ v )

Also in ADORecordSet.

Paramètres:

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

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

Réimplémentée dans ADODB_sybase.

ADOConnection::UserDate	(	$	v,
		$	fmt = `'Y-m-d'`,
		$	gmt = `false`
	)

Also in ADORecordSet.

Format database date based on user defined format.

Paramètres:

	v	is the character date in YYYY-MM-DD format, returned by database
	fmt	is the format to apply to it, using date()

Renvoie:: a date formated as user desires

ADOConnection::UserTimeStamp	(	$	v,
		$	fmt = `'Y-m-d H:i:s'`,
		$	gmt = `false`
	)

Paramètres:

	v	is the character timestamp in YYYY-MM-DD hh:mm:ss format
	fmt	is the format to apply to it, using date()

Renvoie:: a timestamp formated as user desires

ADOConnection::escape	(	$	s,
		$	magic_quotes = `false`
	)

ADOConnection::addq	(	$	s,
		$	magic_quotes = `false`
	)

Quotes a string, without prefixing nor appending quotes.

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

Paramètres:

	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.

Renvoie:: quoted string to be sent back to database

Réimplémentée dans ADODB_mysql, ADODB_oci8, ADODB_postgres64, et ADODB_vfp.

& 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.

Paramètres:

	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

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

NOTE: phpLens uses a different algorithm and does not use PageExecute().

& ADOConnection::CachePageExecute	(	$	secs2cache,
		$	sql,
		$	nrows,
		$	page,
		$	inputarr = `false`
	)

Paramètres:

	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

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

Documentation des données membres

ADOConnection::$dataProvider = 'native'

Réimplémentée dans ADODB_ado, ADODB_db2, ADODB_ibase, ADODB_ldap, ADODB_mysql, ADODB_netezza, ADODB_oci8, ADODB_oci8po, ADODB_odbc, ADODB_odbtp, ADODB_pdo, ADODB_postgres64, et ADODB_sybase.

ADOConnection::$databaseType = ''

ADOConnection::$database = ''

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

ADOConnection::$host = ''

Name of database to be used.

ADOConnection::$user = ''

The hostname of the database server.

ADOConnection::$password = ''

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

Réimplémentée dans ADODB_ldap.

ADOConnection::$debug = false

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

ADOConnection::$maxblobsize = 262144

if set to true will output sql statements

ADOConnection::$concat_operator = '+'

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

Réimplémentée dans ADODB_db2, ADODB_ibase, ADODB_netezza, ADODB_oci8, ADODB_ODBC_DB2, ADODB_odbc_oracle, ADODB_oracle, ADODB_pdo_oci, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_SAPDB, ADODB_sqlite, et ADODB_sybase.

ADOConnection::$substr = 'substr'

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

Réimplémentée dans ADODB_ado_mssql, ADODB_mysql, et ADODB_odbc_mssql.

ADOConnection::$length = 'length'

substring operator

Réimplémentée dans ADODB_ado_mssql, et ADODB_odbc_mssql.

ADOConnection::$random = 'rand()'

string length ofperator

Réimplémentée dans ADODB_netezza, ADODB_oci8, ADODB_pdo_oci, ADODB_pdo_pgsql, et ADODB_postgres64.

ADOConnection::$upperCase = 'upper'

random function

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

uppercase function

Réimplémentée dans 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, et ADODB_vfp.

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

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

Réimplémentée dans ADODB_access, ADODB_ado, ADODB_ado_access, ADODB_csv, ADODB_db2, ADODB_fbsql, ADODB_ibase, ADODB_mysql, ADODB_netezza, ADODB_odbc, ADODB_ODBC_DB2, ADODB_odbc_mssql, ADODB_odbc_oracle, ADODB_odbtp, ADODB_pdo, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_SAPDB, ADODB_sqlite, ADODB_sybase, et ADODB_vfp.

ADOConnection::$true = '1'

used by DBTimeStamp as the default timestamp fmt.

Réimplémentée dans ADODB_netezza, ADODB_pdo_pgsql, ADODB_postgres64, et ADODB_vfp.

ADOConnection::$false = '0'

string that represents TRUE for a database

Réimplémentée dans ADODB_netezza, ADODB_pdo_pgsql, ADODB_postgres64, et ADODB_vfp.

ADOConnection::$replaceQuote = "\\'"

string that represents FALSE for a database

Réimplémentée dans 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, et ADODB_vfp.

ADOConnection::$nameQuote = '"'

string to use to replace quotes

Réimplémentée dans ADODB_mysql, et ADODB_pdo_mysql.

ADOConnection::$charSet = false

string to use to quote identifiers and names

Réimplémentée dans ADODB_postgres7.

ADOConnection::$metaDatabasesSQL = ''

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

Réimplémentée dans ADODB_netezza, ADODB_oci8, ADODB_pdo_pgsql, ADODB_postgres64, et ADODB_sybase_ase.

ADOConnection::$metaTablesSQL = ''

Réimplémentée dans 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, et ADODB_sybase_ase.

ADOConnection::$uniqueOrderBy = false

ADOConnection::$emptyDate = ' '

All order by columns have to be unique.

ADOConnection::$emptyTimeStamp = ' '

ADOConnection::$lastInsID = false

ADOConnection::$hasInsertID = false

Réimplémentée dans ADODB_ado_mssql, ADODB_csv, ADODB_db2, ADODB_fbsql, ADODB_mysql, ADODB_netezza, ADODB_ODBC_DB2, ADODB_odbc_mssql, ADODB_odbtp, ADODB_postgres64, ADODB_sqlanywhere, ADODB_sqlite, et ADODB_sybase.

ADOConnection::$hasAffectedRows = false

supports autoincrement ID?

Réimplémentée dans 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, et ADODB_sybase.

ADOConnection::$hasTop = false

supports affected rows for update/delete?

Réimplémentée dans ADODB_access, ADODB_ado_access, ADODB_ado_mssql, ADODB_odbc_mssql, ADODB_pdo_mssql, et ADODB_vfp.

ADOConnection::$hasLimit = false

support mssql/access SELECT TOP 10 * FROM TABLE

Réimplémentée dans ADODB_fbsql, ADODB_mysql, ADODB_netezza, ADODB_pdo_pgsql, ADODB_postgres64, ADODB_postgres7, et ADODB_sqlite.

ADOConnection::$readOnly = false

support pgsql/mysql SELECT * FROM TABLE LIMIT 10

ADOConnection::$hasMoveFirst = false

this is a readonly database - used by phpLens

Réimplémentée dans ADODB_mysql, ADODB_odbtp, ADODB_pdo_pgsql, et ADODB_postgres64.

ADOConnection::$hasGenID = false

has ability to run MoveFirst(), scrolling backwards

Réimplémentée dans ADODB_ibase, ADODB_mysql, ADODB_oci8, ADODB_odbtp, ADODB_pdo_pgsql, et ADODB_postgres64.

ADOConnection::$hasTransactions = true

can generate sequences using GenID();

Réimplémentée dans ADODB_access, ADODB_ado_access, ADODB_csv, ADODB_mysql, ADODB_mysqlt, et ADODB_vfp.

ADOConnection::$genID = 0

has transactions

ADOConnection::$raiseErrorFn = false

sequence id used by GenID();

ADOConnection::$isoDates = false

error function to call

Réimplémentée dans ADODB_mysql, ADODB_netezza, ADODB_pdo_pgsql, et ADODB_postgres64.

ADOConnection::$cacheSecs = 3600

accepts dates in ISO format

ADOConnection::$memCache = false

cache for 1 hour

ADOConnection::$memCacheHost

should we use memCache instead of caching in files

ADOConnection::$memCachePort = 11211

memCache host

ADOConnection::$memCacheCompress = false

memCache port

ADOConnection::$sysDate = false

Use 'true' to store the item compressed (uses zlib).

Réimplémentée dans ADODB_access, ADODB_ado_access, ADODB_ado_mssql, ADODB_db2, ADODB_ibase, ADODB_mysql, ADODB_netezza, ADODB_oci8, ADODB_ODBC_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, et ADODB_vfp.

ADOConnection::$sysTimeStamp = false

name of function that returns the current date

Réimplémentée dans ADODB_access, ADODB_ado_access, ADODB_ado_mssql, ADODB_db2, ADODB_firebird, ADODB_ibase, ADODB_mysql, ADODB_netezza, ADODB_oci8, ADODB_ODBC_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, et ADODB_vfp.

ADOConnection::$arrayClass = 'ADORecordSet_array'

name of function that returns the current timestamp

Réimplémentée dans ADODB_sybase.

ADOConnection::$noNullStrings = false

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

Réimplémentée dans ADODB_oci8.

ADOConnection::$numCacheHits = 0

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

ADOConnection::$numCacheMisses = 0

ADOConnection::$pageExecuteCountRows = true

ADOConnection::$uniqueSort = false

ADOConnection::$leftOuter = false

indicates that all fields in order by must be unique

Réimplémentée dans ADODB_ado_mssql, ADODB_oci8, ADODB_odbc_mssql, et ADODB_sybase.

ADOConnection::$rightOuter = false

operator to use for left outer join in WHERE clause

Réimplémentée dans ADODB_ado_mssql, ADODB_odbc_mssql, et ADODB_sybase.

ADOConnection::$ansiOuter = false

operator to use for right outer join in WHERE clause

Réimplémentée dans ADODB_ado_mssql, ADODB_ibase, ADODB_mysqlt, ADODB_netezza, ADODB_ODBC_DB2, ADODB_odbc_mssql, ADODB_postgres7, et ADODB_vfp.

ADOConnection::$autoRollback = false

whether ansi outer join syntax supported

Réimplémentée dans ADODB_mysqlt, ADODB_netezza, et ADODB_postgres64.

ADOConnection::$poorAffectedRows = false

Réimplémentée dans ADODB_ado, ADODB_ibase, et ADODB_mysql.

ADOConnection::$fnExecute = false

ADOConnection::$fnCacheExecute = false

ADOConnection::$blobEncodeType = false

Réimplémentée dans ADODB_ibase, ADODB_netezza, ADODB_pdo_pgsql, et ADODB_postgres64.

ADOConnection::$rsPrefix = "ADORecordSet_"

Réimplémentée dans ADODB_ODBC_DB2.

ADOConnection::$autoCommit = true

ADOConnection::$transOff = 0

do not modify this yourself - actually private

ADOConnection::$transCnt = 0

temporarily disable transactions

ADOConnection::$fetchMode = false

count of nested transactions

ADOConnection::$null2null = 'null'

ADOConnection::$_oldRaiseFn = false

ADOConnection::$_transOK = null

ADOConnection::$_connectionID = false

ADOConnection::$_errorMsg = false

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

ADOConnection::$_errorCode = false

then returned by the errorMsg() function

A variable which was used to keep the returned last error message. The value will

ADOConnection::$_queryID = false

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

ADOConnection::$_isPersistentConnection = false

This variable keeps the last created result link identifier.

ADOConnection::$_bindInputArray = false

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

Réimplémentée dans ADODB_access, ADODB_ado, ADODB_db2, ADODB_ibase, ADODB_oci8, ADODB_odbc, ADODB_ODBC_DB2, ADODB_odbc_mssql, ADODB_odbtp, ADODB_pdo, ADODB_postgres64, ADODB_SAPDB, et ADODB_vfp.

ADOConnection::$_evalAll = false

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

ADOConnection::$_affected = false

ADOConnection::$_logsql = false

ADOConnection::$_transmode = ''

La documentation de cette classe a été générée à partir du fichier suivant :

Z:/doxygen/typo3_src-4.1.2/typo3/sysext/adodb/adodb/adodb.inc.php

Généré le Fri Aug 31 11:39:24 2007 pour OBLADY - Typo3 API v4.1.2 par

1.5.3


Fonctions membres publiques
	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)
	IgnoreErrors ($saveErrs=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)
&	Transpose (&$rs)
	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, $memcache=false)
&	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 ()
	SetTransactionMode ($transaction_mode)
	MetaTransaction ($mode, $db)
	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, $useattnum=false)
	Concat ()
	DBDate ($d)
	BindDate ($d)
	BindTimeStamp ($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)
Attributs publics
	$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
	$memCache = false
	cache for 1 hour
	$memCacheHost
	should we use memCache instead of caching in files
	$memCachePort = 11211
	memCache host
	$memCacheCompress = false
	memCache port
	$sysDate = false
	Use 'true' to store the item compressed (uses zlib).
	$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
	$null2null = 'null'
	$_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
	$_transmode = ''