ADOdb

Classes
class	ADOConnection
	Connection object. More...
class	ADODB2_access
class	ADODB2_db2
class	ADODB2_generic
class	ADODB2_ibase
class	ADODB2_informix
class	ADODB2_mssql
class	ADODB2_mysql
class	ADODB2_oci8
class	ADODB2_sapdb
class	ADODB2_sqlite
class	ADODB2_sybase
class	ADODB_Active_DB
class	ADODB_Active_Record
class	ADODB_Active_Table
class	ADODB_ado
class	ADODB_ado_access
class	ADODB_ado_mssql
class	ADODB_ads
class	ADODB_borland_ibase
class	ADODB_Cache_File
	Class ADODB_Cache_File. More...
class	ADODB_Cache_MemCache
class	ADODB_DataDict
class	ADODB_db2
class	ADODB_Exception
class	ADODB_informix
class	ADODB_informix72
class	ADODB_Iterator
	Class ADODB_Iterator. More...
class	ADODB_Iterator_empty
	Class ADODB_Iterator_empty. More...
class	ADODB_ldap
class	ADODB_mssql
class	ADODB_mssql_n
class	ADODB_mssqlnative
class	ADODB_mssqlpo
class	ADODB_netezza
class	ADODB_oci8
class	ADODB_oci805
class	ADODB_oci8po
class	ADODB_oci8quercus
class	ADODB_odbc
class	ADODB_odbc_mssql
class	ADODB_odbc_mssql2012
class	ADODB_odbc_oracle
class	ADODB_odbtp
class	ADODB_odbtp_unicode
class	ADODB_oracle
class	ADODB_pdo
class	ADODB_pdo_base
	Base class for Database-specific PDO drivers. More...
class	adodb_perf
class	ADODB_postgres64
class	ADODB_postgres7
class	ADODB_postgres8
class	ADODB_postgres9
class	ADODB_sqlite
class	ADODB_sqlitepo
class	ADODB_sybase
class	ADODB_sybase_ase
class	ADOdbLoadBalancerConnection
	Class ADOdbLoadBalancerConnection. More...
class	ADOFetchObj
	Internal placeholder for record objects. More...
class	ADOFieldObject
	Helper class for FetchFields – holds info on a column. More...
class	ADOPDOStatement
class	ADORecordSet
	RecordSet class that represents the dataset returned by the database. More...
class	ADORecordSet_ado
class	ADORecordSet_ado_access
class	ADORecordSet_ado_mssql
class	ADORecordSet_ads
class	ADORecordSet_array
	This class encapsulates the concept of a recordset created in memory as an array. More...
class	ADORecordSet_array_mssql
class	ADORecordSet_array_mssqlnative
class	ADORecordSet_array_pdo
class	ADORecordSet_array_pdo_firebird
	Class ADORecordSet_array_pdo_firebird. More...
class	ADORecordSet_array_pdo_sqlsrv
class	ADORecordSet_array_sybase
class	ADORecordSet_assoc_postgres7
class	ADORecordSet_assoc_postgres8
class	ADORecordSet_assoc_postgres9
class	ADORecordSet_borland_ibase
class	ADORecordSet_db2
class	ADORecordSet_empty
	Lightweight recordset when there are no records to be returned. More...
class	ADORecordSet_ext_oci8
class	ADORecordset_firebird
	Class ADORecordset_firebird. More...
class	ADORecordset_informix
class	ADORecordset_informix72
class	ADORecordSet_ldap
class	ADORecordset_mssql
class	ADORecordset_mssql_n
class	ADORecordset_mssqlnative
class	ADORecordset_mssqlpo
class	ADORecordSet_netezza
class	ADORecordset_oci8
class	ADORecordset_oci805
class	ADORecordset_oci8po
class	ADORecordset_oci8quercus
class	ADORecordSet_odbc
class	ADORecordSet_odbc_mssql
class	ADORecordSet_odbc_mssql2012
class	ADORecordSet_odbc_oracle
class	ADORecordSet_odbtp
class	ADORecordSet_odbtp_access
class	ADORecordSet_odbtp_mssql
class	ADORecordSet_odbtp_oci8
class	ADORecordSet_odbtp_sybase
class	ADORecordSet_odbtp_vfp
class	ADORecordset_oracle
class	ADORecordSet_pdo
class	ADORecordSet_pdo_firebird
	Class ADORecordSet_pdo_firebird. More...
class	ADORecordSet_pdo_sqlsrv
class	ADORecordSet_postgres64
class	ADORecordSet_postgres7
class	ADORecordSet_postgres8
class	ADORecordSet_postgres9
class	ADORecordset_sqlite
class	ADORecordset_sqlitepo
class	ADORecordset_sybase
class	adorecordset_sybase_ase
class	adoSchema
	Loads and parses an XML file, creating an array of "ready-to-run" SQL statements. More...
class	DB
	The main "DB" class is simply a container class with some static methods for creating DB objects as well as some utility functions common to all parts of DB. More...
class	perf_db2
class	perf_informix
class	perf_mssql
class	perf_mssqlnative
class	perf_mysql
class	perf_oci8
class	perf_postgres

Typedefs
using	equiv

Functions
	__call ($method, $args)
	Magic method to intercept method and callback to the proper ADODB object for write/readonly connections.
	__construct (&$db, $sql, $id='adodb', $showPageLinks=false)
	__get ($property)
	Magic method to proxy property getter calls back to the proper ADODB object currently in use.
	__set ($property, $value)
	Magic method to proxy property setter calls back to the proper ADODB object currently in use.
	_adodb_backtrace ($printOrArr=true, $maximumDepth=9999, $elementsToIgnore=0, $ishtml=null)
	Pretty print the debug_backtrace function.
	_adodb_column_sql (&$zthis, $action, $type, $fname, $fnameq, $arrFields, $recurse=true)
	_adodb_column_sql_oci8 (&$zthis, $action, $type, $fname, $fnameq, $arrFields)
	This private method is used to help construct the update/sql which is generated by GetInsertSQL and GetUpdateSQL.
	_adodb_debug_execute ($zthis, $sql, $inputarr)
	Replaces standard _execute when debug mode is enabled.
	_adodb_export (&$rs, $sep, $sepreplace, $fp=false, $addtitles=true, $quote='"',$escquote = '"', $replaceNewLine=' ')
	_adodb_getcount ($zthis, $sql, $inputarr=false, $secs2cache=0)
	_adodb_getdate ($origd=false, $fast=false, $is_gmt=false)
	Low-level function that returns the getdate() array.
	_adodb_getdriver ($provider, $drivername, $perf=false)
	_adodb_getinsertsql (&$zthis, $rs, $arrFields, $force=2)
	There is a special case of this function for the oci8 driver.
	_adodb_getmenu ($zthis, $name, $defstr='', $blank1stItem=true, $multiple=false, $size=0, $selectAttr='', $compareFields0=true)
	_adodb_getmenu_gp ($zthis, $name, $defstr='', $blank1stItem=true, $multiple=false, $size=0, $selectAttr='', $compareFields0=true)
	_adodb_getmenu_option ($defstr, $compare, $value, $display)
	Print the OPTION tags for getmenu functions.
	_adodb_getmenu_select ($name, $defstr='', $blank1stItem=true, $multiple=false, $size=0, $selectAttr='')
	Generate the opening SELECT tag for getmenu functions.
	_adodb_getupdatesql (&$zthis, $rs, $arrFields, $forceUpdate=false, $force=2)
	_adodb_is_leap_year ($year)
	Checks for leap year, returns true if it is.
	_adodb_pageexecute_all_rows ($zthis, $sql, $nrows, $page, $inputarr=false, $secs2cache=0)
	Execute query with pagination including record count.
	_adodb_pageexecute_no_last_page ($zthis, $sql, $nrows, $page, $inputarr=false, $secs2cache=0)
	Execute query with pagination without last page information.
	_adodb_quote_fieldname ($zthis, $fieldName)
	Performs case conversion and quoting of the given field name.
	_adodb_replace ($zthis, $table, $fieldArray, $keyCol, $autoQuote, $has_autoinc)
	_adodb_safedate ($s)
	Parse date string to prevent injection attack.
	_adodb_safedateq ($s)
	Parse date string to prevent injection attack.
	_affectedrows ()
	_blobDecode ($blob)
	Auto function called on read of blob to decode.
	_close ()
	_ConvertFieldType (&$fld, $ftype, $flen, $fscale, $fsubtype, $fprecision, $dialect3)
	_handleError ()
	_init ($parentDriver)
	_init (ADODB_pdo $parentDriver)
	_pconnect ($argHostname, $argUsername, $argPassword, $argDatabasename)
	Connect to a database with a persistent connection.
	_query ($sql, $inputarr=false)
	Execute a query.
	_rs2serialize (&$rs, $conn=false, $sql='')
	Convert a recordset into special format.
	addConnection ($obj)
	Adds a new database connection to the pool, but no actual connection is made until its needed.
	adodb_backtrace ($printOrArr=true, $levels=9999, $ishtml=null)
	Perform a stack-crawl and pretty print it.
	adodb_date ($fmt, $d=false, $is_gmt=false)
	Return formatted date based on timestamp $d.
	adodb_date2 ($fmt, $d=false, $is_gmt=false)
	adodb_date_test ()
	Test Suite.
	adodb_date_test_date ($y1, $m, $d=13)
	adodb_date_test_strftime ($fmt)
	adodb_dow ($year, $month, $day)
	Returns day of week, 0 = Sunday,... 6=Saturday.
	adodb_error ($provider, $dbType, $errno)
	ADODB_Error_Handler ($dbms, $fn, $errno, $errmsg, $p1, $p2, &$thisConnection)
	Default Error Handler.
	adodb_error_ibase ()
	adodb_error_ifx ()
	adodb_error_mssql ()
	adodb_error_mysql ()
	adodb_error_oci8 ()
	adodb_error_odbc ()
	ADODB_Error_PEAR ($dbms, $fn, $errno, $errmsg, $p1=false, $p2=false)
	Error Handler with PEAR support.
	adodb_error_pg ($errormsg)
	adodb_error_sqlite ()
if(!defined("DB_ERROR_SYNTAX"))	adodb_errormsg ($value)
	adodb_get_gmt_diff ($y, $m, $d)
	get local time zone offset from GMT.
	adodb_get_gmt_diff_ts ($ts)
	adodb_GetActiveRecordsClass (&$db, $class, $table, $whereOrderBy, $bindarr, $primkeyArr, $extra)
	adodb_GetActiveRecordsClass (&$db, $class, $tableObj, $whereOrderBy, $bindarr, $primkeyArr, $extra, $relations)
	adodb_getdate ($d=false, $fast=false)
	Returns an array with date info.
	adodb_getmem ()
	adodb_gmdate ($fmt, $d=false)
	adodb_gmmktime ($hr, $min, $sec, $mon=false, $day=false, $year=false, $is_dst=false)
	Returns a timestamp given a GMT/UTC time.
	adodb_gmstrftime ($fmt, $ts=false)
	adodb_is_leap_year ($year)
	checks for leap year, returns true if it is.
	adodb_key_exists ($key, $arr, $force=2)
	adodb_last_date_status ()
	Returns the status of the last date calculation and whether it exceeds the limit of ADODB_FUTURE_DATE_CUTOFF_YEARS.
	adodb_log_sql (&$connx, $sql, $inputarr)
	adodb_microtime ()
	adodb_mktime ($hr, $min, $sec, $mon=false, $day=false, $year=false, $is_dst=false, $is_gmt=false)
	Return a timestamp given a local time.
	adodb_pdo_type ($t)
	ADODB_PEAR_Error ()
	Returns last PEAR_Error object.
	adodb_pr ($var, $as_string=false)
	Perform a print_r, with pre tags for better formatting.
	adodb_probetypes ($array, &$types, $probe=8)
	adodb_round ($n, $prec)
	ADODB_SetDatabaseAdapter (&$db)
	ADODB_SetDatabaseAdapter (&$db, $index=false)
	ADODB_Setup ()
	adodb_strftime ($fmt, $ts=false, $is_gmt=false)
	adodb_strip_order_by ($sql)
	Strip the ORDER BY clause from the outer SELECT.
	adodb_throw ($dbms, $fn, $errno, $errmsg, $p1, $p2, $thisConnection)
	Default Error Handler.
	adodb_time ()
	ADODB_TransMonitor ($dbms, $fn, $errno, $errmsg, $p1, $p2, &$thisConnection)
	For transaction handling.
	adodb_transpose (&$arr, &$newarr, &$hdr, $fobjs)
	adodb_tz_offset ($gmt, $ignored=true)
	Compute timezone offset.
	adodb_validdate ($y, $m, $d)
	adodb_write_file ($filename, $contents, $debug=false)
	Save a file $filename and its $contents (normally for caching) with file locking Returns true if ok, false if fopen/fwrite error, 0 if rename error (eg.
	adodb_year_digit_check ($y)
	Fix 2-digit years.
	ADOLoadCode ($dbType)
	Load the code for a specific database driver.
	ADOLoadDB ($dbType)
	Synonym for ADOLoadCode.
	ADONewConnection ($db='')
	Instantiate a new Connection class for a specific database driver.
	arr2html (&$arr, $ztabhtml='', $zheaderarray='')
	BeginTrans ()
	beginTrans ()
	Begin a Transaction.
	blobDecode ($blob)
	Manually decode a blob.
	blobEncode ( $blob)
	Encodes a blob, then assigns an id ready to be used.
	CheckMemory ()
	clearsql ()
	clusterExecute ( $sql, $inputarr=false, $return_all_results=false, $existing_connections_only=true)
	Executes the same SQL QUERY on the entire cluster of connections.
	CommitTrans ($ok=true)
	commitTrans ($ok=true)
	Commits a transaction.
	Concat ()
	CreateSequence ($seqname='adodbseq', $start=1)
	createSequence ($seqname='adodbseq', $startID=1)
	Creates a sequence in the database.
	csv2rs ($url, &$err, $timeout=0, $rsclass='ADORecordSet_array')
	Open CSV file and convert it into Data.
	dropSequence ($seqname='adodbseq')
	DynMemoryUsage ()
	errorMsg ()
	errorNo ()
	execute ($sql, $inputarr=false)
	Use this instead of __call() as it significantly reduces the overhead of call_user_func_array().
	ExpensiveSQL ($numsql=10)
	Explain ($sql, $partial=false)
	FlashUsage ()
	GenID ($seqname='adodbseq', $startID=1)
	genID ($seqname='adodbseq', $startID=1)
	A portable method of creating sequence numbers.
	genId ($seqname='adodbseq', $startID=1)
	getConnection ($type='write', $pin_connection=null)
	Returns the ADODB connection object by database type.
	getConnectionById ($connection_id)
	Returns the ADODB connection object by connection_id.
	getConnectionByWeight ($type)
	Returns a database connection of the specified type.
	getLoadBalancedConnection ($type)
	Returns the proper database connection when taking into account sticky sessions and load balancing.
	ifx_props ($coltype, $collength)
	!Eos Auxiliary function to Parse coltype,collength.
	isReadOnlyQuery ($sql)
	Determines if a SQL query is read-only or not.
if(!function_exists( 'ctype_alnum'))	lens_ParseArgs ($args, $endstmtchar=',', $tokenchars='_.-')
	Parse arguments, treat "text" (text) and 'text' as quotation marks.
	lens_ParseTest ()
	Test script for parser.
	MetaColumns ($table, $normalize=true)
	metaColumns ($table, $normalize=true)
	Return an array of information about a table's columns.
	metaIndexes ($table, $primary=false, $owner=false)
	Get a list of indexes on the specified table.
	metaPrimaryKeys ($table, $owner_notused=false, $internalKey=false)
	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	metaTables ($ttype=false, $showSchema=false, $mask=false)
	Retrieves a list of tables based on given criteria.
	NewADOConnection ($db='')
	Synonym for ADONewConnection for people like me who cannot remember the correct name.
	newDataDictionary (&$conn, $drivername='')
	Get a new Data Dictionary object for the connection.
	NewPerfMonitor (&$conn)
	oci_lob_desc ($type)
	OffsetDate ($dayFraction, $date=false)
	offsetDate ($dayFraction, $date=false)
	Creates a portable date offset field, for use in SQL statements.
	param ($name, $type='C')
	Returns a driver-specific format for a bind parameter.
	PGA ()
	PGA_Advice ()
	prepare ($sql)
	Prepares an SQL statement and returns a handle to use.
	removeConnection ($i)
	Removes a database connection from the pool.
	Render ($rows=10)
	Render_First ($anchor=true)
	render_last ($anchor=true)
	render_next ($anchor=true)
	render_pagelinks ()
	render_prev ($anchor=true)
	RenderGrid ()
	RenderLayout ($header, $grid, $footer, $attributes='border=1 bgcolor=beige')
	RenderNav ()
	RenderPageCount ()
	RMAN ()
	RollbackTrans ()
	rollbackTrans ()
	Rollback a smart transaction.
	rowLock ($table, $where, $col=false)
	Lock a table row for a duration of a transaction.
	rs2csvfile (&$rs, $fp, $addtitles=true)
	rs2csvout (&$rs, $addtitles=true)
	rs2html (&$rs, $ztabhtml=false, $zheaderarray=false, $htmlspecialchars=true, $echo=true)
	rs2tab (&$rs, $addtitles=true)
	rs2tabfile (&$rs, $fp, $addtitles=true)
	rs2tabout (&$rs, $addtitles=true)
	SelectDB ($dbName)
	selectDB ($dbName)
	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	selectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	Executes a provided SQL statement and returns a handle to the result, with the ability to supply a starting offset and record count.
	ServerInfo ()
	serverInfo ()
	Get information about the current Firebird server.
	SetAutoCommit ($auto_commit)
	setSessionInitSQL ($sql)
	Defines SQL queries that are executed each time a new database connection is established.
	setSessionVariable ($name, $value, $execute_immediately=true)
	Allow setting session variables that are maintained across connections.
	SetTransactionMode ( $transaction_mode)
	setTransactionMode ( $transaction_mode)
	SQLDate ($fmt, $col=false)
	sqlDate ($fmt, $col=false)
	Returns a portably-formatted date string from a timestamp database column.
	SuspiciousSQL ($numsql=10)
	TableSpace ()
	tohtml (&$rs, $type)
	TopHistoricalWaits ()
	updateBlob ($table, $column, $val, $where, $blobtype='BLOB')
	Insert blob data into a database column.
	updateBlobFile ($table, $column, $path, $where, $blobtype='BLOB')
	Insert blob data into a database column directly from file.
	WarnIndexCost ($val)
	WarnPageCost ($val)

Variables
global	$_ADODB_ACTIVE_DBS = array()
global	$_ADODB_ACTIVE_DBS = array()
	$_dropSeqSQL = "drop table %s"
	$_dropSeqSQL = "DROP SEQUENCE %s"
	$_dropSeqSQL = 'DROP TABLE %s'
	$_genIDSQL = "UPDATE %s SET id=LAST_INSERT_ID(id+1);"
	$_genIDSQL = "SELECT NEXTVAL('%s')"
	$_genIDSQL = "UPDATE %s SET id=id+1 WHERE id=%s"
	$_genSeq2SQL = "INSERT INTO %s VALUES (%s)"
	$_genSeq2SQL = 'INSERT INTO %s VALUES(%s)'
	$_genSeqCountSQL = "SELECT count(*) FROM %s"
	$_genSeqCountSQL = 'SELECT COUNT(*) FROM %s'
	$_genSeqSQL = "CREATE TABLE if NOT EXISTS %s (id int not null)"
	$_genSeqSQL = "CREATE SEQUENCE %s START %s"
	$_genSeqSQL = "CREATE TABLE %s (id integer)"
	$_hasdual = true
	$_initdate = true
	$_month_table_leaf = array("",31,29,31,30,31,30,31,31,30,31,30,31)
	$_month_table_normal = array("",31,28,31,30,31,30,31,31,30,31,30,31)
global	$ACTIVE_RECORD_SAFETY = true
global	$ACTIVE_RECORD_SAFETY = true
global	$ADODB_ACTIVE_CACHESECS = 0
global	$ADODB_ACTIVE_CACHESECS
global	$ADODB_ACTIVE_DEFVALS = false
global	$ADODB_ACTIVE_DEFVALS = false
if(defined( 'ADODB_EXTENSION')) if(!defined('ADODB_DIR')) GLOBAL	$ADODB_CACHE
if(defined( 'ADODB_EXTENSION')) if(!defined('ADODB_DIR')) GLOBAL	$ADODB_CACHE_CLASS
if(defined( 'ADODB_EXTENSION')) if(!defined('ADODB_DIR')) GLOBAL	$ADODB_CACHE_DIR
if(defined( 'ADODB_EXTENSION')) if(!defined('ADODB_DIR')) GLOBAL	$ADODB_COMPAT_FETCH
if(defined( 'ADODB_EXTENSION')) if(!defined('ADODB_DIR')) GLOBAL	$ADODB_COUNTRECS
if(defined( 'ADODB_EXTENSION')) if(!defined('ADODB_DIR')) GLOBAL	$ADODB_FETCH_MODE
if(defined( 'ADODB_EXTENSION')) if(!defined('ADODB_DIR')) GLOBAL	$ADODB_GETONE_EOF
global	$ADODB_INCLUDED_CSV = 1
global	$ADODB_INCLUDED_CSV
global	$ADODB_INCLUDED_LIB = 1
global	$ADODB_INCLUDED_MEMCACHE = 1
global	$ADODB_Last_PEAR_Error = false
global	$ADODB_PERF_MIN = 0.05
if(defined( 'ADODB_EXTENSION')) if(!defined('ADODB_DIR')) GLOBAL	$ADODB_QUOTE_FIELDNAMES
	$ADODB_ROUND =4
global	$ADODB_sybase_mths
if(defined( 'ADODB_EXTENSION')) if(!defined('ADODB_DIR')) GLOBAL	$ADODB_vers
	Set ADODB_DIR to the directory where this file resides... This constant was formerly called $ADODB_RootPath.
	$arrayClass = 'ADORecordSet_array_pdo_firebird'
	$arrayClass = 'ADORecordSet_array_pdo_sqlsrv'
	$blobEncodeType = 'C'
	$cache = 0
	$concat_operator ='||'
	random function
	$concat_operator = '||'
bool array	$connections = []
	All connections to each database.
bool array	$connections_readonly = []
	Just connections to the readonly database.
bool array	$connections_write = []
	Just connections to the write capable database.
	$curr_page
	$db
**TO A FILE *	$f = fopen($path,'w')
	$false = 'f'
	$first = '<code>|&lt;</code>'
	$fmtDate = "'Y-m-d'"
	$fmtTimeStamp = "'Y-m-d H:i:s'"
	$fmtTimeStamp = "'Y-m-d G:i:s'"
	$fn = ($persist) ? 'fbird_pconnect':'fbird_connect'
	$gridAttributes = 'width=100% border=1 bgcolor=white'
	$gridHeader = false
	$gSQLBlockRows =20
	$gSQLMaxRows = 1000
	$hasAffectedRows = true
	$hasGenID = true
	$hasGenID = true
	$hasGenID = true
	$hasLimit = false
	$hasMoveFirst = true
else	$hidecnt = false
	$htmlSpecialChars = true
	$iif = strpos($db->databaseType,'access') !== false
	$isoDates = true
	$last = '<code>>|</code>'
array	$last_connection_id = array('write' => false, 'readonly' => false, 'all' => false)
	Last connection_id for each database type.
	$linkSelectedColor = 'red'
	$linksPerPage =10
	$metaColumnsSQL = "SELECT c.NAME, OBJECT_NAME(c.id) as tbl_name, c.length, c.isnullable, c.status, ( CASE WHEN c.xusertype=61 THEN 0 ELSE c.xprec END), ( CASE WHEN c.xusertype=61 THEN 0 ELSE c.xscale END), ISNULL(i.is_primary_key, 0) as primary_key FROM syscolumns c INNER JOIN systypes t ON t.xusertype=c.xusertype INNER JOIN sysobjects o ON o.id=c.id LEFT JOIN sys.index_columns ic ON ic.object_id = c.id AND c.colid = ic.column_id LEFT JOIN sys.indexes i ON i.object_id = ic.object_id AND i.index_id = ic.index_id WHERE c.id = OBJECT_ID('%s') ORDER by c.colid"
	$metaColumnsSQL = "select lower(a.rdb\$field_name), a.rdb\$null_flag, a.rdb\$default_source, b.rdb\$field_length, b.rdb\$field_scale, b.rdb\$field_sub_type, b.rdb\$field_precision, b.rdb\$field_type from rdb\$relation_fields a, rdb\$fields b where a.rdb\$field_source = b.rdb\$field_name and a.rdb\$relation_name = '%s' order by a.rdb\$field_position asc"
	$metaColumnsSQL = "SHOW COLUMNS FROM `%s`"
	$metaColumnsSQL = "select cname,coltype,width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='%s' order by colno"
	$metaColumnsSQL
	$metaColumnsSQL1
	$metaDatabasesSQL = "select name from sysdatabases where name <> 'master'"
	$metaDefaultsSQL = "SELECT d.adnum as num, d.adsrc as def from pg_attrdef d, pg_class c where d.adrelid=c.oid and c.relname='%s' order by d.adnum"
	$metaKeySQL
	$metaTablesSQL ="select name,case when type='U' then 'T' else 'V' end from sysobjects where (type='U' or type='V') and (name not in ('sysallocations','syscolumns','syscomments','sysdepends','sysfilegroups','sysfiles','sysfiles1','sysforeignkeys','sysfulltextcatalogs','sysindexes','sysindexkeys','sysmembers','sysobjects','syspermissions','sysprotects','sysreferences','systypes','sysusers','sysalternates','sysconstraints','syssegments','REFERENTIAL_CONSTRAINTS','CHECK_CONSTRAINTS','CONSTRAINT_TABLE_USAGE','CONSTRAINT_COLUMN_USAGE','VIEWS','VIEW_TABLE_USAGE','VIEW_COLUMN_USAGE','SCHEMATA','TABLES','TABLE_CONSTRAINTS','TABLE_PRIVILEGES','COLUMNS','COLUMN_DOMAIN_USAGE','COLUMN_PRIVILEGES','DOMAINS','DOMAIN_CONSTRAINTS','KEY_COLUMN_USAGE','dtproperties'))"
	$metaTablesSQL = "select lower(rdb\$relation_name) from rdb\$relations where rdb\$relation_name not like 'RDB\$%'"
	$metaTablesSQL = "select table_name,table_type from cat where table_type in ('TABLE','VIEW')"
	$metaTablesSQL
	$moreLinks = '...'
	$nameQuote = '`'
	$nameQuote = '`'
	$next = '<code>>></code>'
	$NLS_DATE_FORMAT = 'YYYY-MM-DD'
	$page = 'Page'
	$pdoDriver = false
bool	$pinned_connection_id = false
	When in transactions, always use this connection.
	$prev = '<code>&lt;&lt;</code>'
	$random = "abs(mod(DBMS_RANDOM.RANDOM,10000001)/10000000)"
	$random = 'random()'
	$random ='abs(random())'
	$replaceQuote = "''"
	$rowfields = preg_replace('/ AS (\w+)/i', '', $rowfields)
	$rows
	$rows = $rs->RecordCount()
	$rs
	$rs = $rs->connection->_rs2rs($rs)
*AS VARIABLE *	$s = rs2csv($rs)
	$sel = "$rowfields, "
bool	$session_variables = []
	Session variables that must be maintained across all connections, ie: SET TIME ZONE.
	$showPageLinks
	$sql
	$sql = "SELECT $sel nFROM $tables $where nGROUP BY $rowfields"
	$startLinks = '...'
	$sysDate = 'convert(datetime,convert(char,GetDate(),102),102)'
	$sysDate = 'convert(datetime,convert(char,GetDate(),102),102)'
	$sysDate = 'CURDATE()'
	$sysDate = "TRUNC(SYSDATE)"
	$sysDate = "CURRENT_DATE"
	$sysDate = 'current_date'
	$sysDate = 'convert(datetime,convert(char,GetDate(),102),102)'
	$sysTimeStamp = 'GetDate()'
	$sysTimeStamp = 'GetDate()'
	$sysTimeStamp = 'NOW()'
	$sysTimeStamp = 'SYSDATE'
	$sysTimeStamp = "CURRENT_TIMESTAMP"
	$sysTimeStamp = 'current_timestamp'
	$sysTimeStamp = 'GetDate()'
array	$total_connection_weights = array('all' => 0, 'write' => 0, 'readonly' => 0)
	Weights of all connections for each type.
array	$total_connections = array('all' => 0, 'write' => 0, 'readonly' => 0)
	Counts of all connections and their types.
	$true = 't'
bool	$user_defined_session_init_sql = []
	Called immediately after connecting to any DB.
const	_ADODB_ADO_LAYER 1
const	_ADODB_ADO_LAYER 1
const	_ADODB_ADS_LAYER 2
const	_ADODB_DB2_LAYER 2
const	_ADODB_ODBC_LAYER 2
const	_ADODB_ODBTP_LAYER 2
else $this	_connectionID
*This file is part of	ADOdb
*This is to support WORK and LAZY mode **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*Less commonly used functions are placed here to reduce size of adodb inc php **This file is part of	ADOdb
*ADOdbLoadBalancer is a class that allows the user to do read write splitting *and load balancing across multiple servers It can handle and load balance *any number of write capable *(AKA:master) or readonly(AKA including dealing with connection failures and retrying queries on a different *connection instead **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*FileDescription **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*Requires ODBC Works only on Microsoft Windows **This file is part of	ADOdb
*Requires ADO Works only on MS Windows **This file is part of	ADOdb
*Requires ADO Works only on MS Windows **This file is part of	ADOdb
*Requires ADO and ODBC Works only on MS Windows **This file is part of	ADOdb
*Requires ADO and MSSQL client Works only on MS Windows **This file is part of	ADOdb
*Support Borland Interbase and later **This file is part of	ADOdb
*Currently MetaTables and *and also inputarr in Execute *Native types have been converted to MetaTypes *Transactions not supported yet **Limitation of url length For see MaxClientRequestBuffer registry value **This file is part of	ADOdb
*This driver provides undocumented bind variable mapping from ibm to oracle *The functionality appears to overlap the db2_oci driver **deprecated **This file is part of	ADOdb
*This file is part of	ADOdb
*Requires firebird client Works on Windows and Unix **This file is part of	ADOdb
*Requires interbase client Works on Windows and Unix **This file is part of	ADOdb
*Supports SELECT FIRST **deprecated **This file is part of	ADOdb
*deprecated **This file is part of	ADOdb
*Provides a subset of ADOdb allowing read only access to an LDAP database **This file is part of	ADOdb
*Requires mssql client Works on Windows **This file is part of	ADOdb
*Intended to be used with MSSQL drivers that are sending UCS data to MSSQL *FreeTDS and ODBTP in order to get true cross db compatibility from the *application point of view **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*deprecated will be removed in ADOdb version **This file is part of	ADOdb
*deprecated Use oci8 driver instead **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This version has only been tested on Firebird and PHP **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
this file is no longer and the *driver is remapped to the latest available postgres version Maintaining *multiple postgres drivers is no easy so hopefully this will ensure *greater consistency and fewer bugs **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*deprecated **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*Make it more similar to other database drivers The main differences are *When selecting(joining) multiple tables in assoc mode the table *names are included in the assoc keys in the driver *In the table names are stripped from the returned *column names When this results in a the first field gets *preference **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*deprecated **This file is part of	ADOdb
*deprecated **This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
*This file is part of	ADOdb
**This file is part of	ADOdb
*Convert a recordset to a html table Multiple tables are generated *if the number of rows is $gSQLBlockRows This is because *web browsers so we break the output into several faster rendering tables **This file is part of	ADOdb
const	ADODB_ASSOC_CASE_LOWER 0
	Associative array case constants.
const	ADODB_ASSOC_CASE_NATIVE 2
const	ADODB_ASSOC_CASE_UPPER 1
const	ADODB_BAD_RS '<p>Bad $rs in %s. Connection or SQL invalid. Try using $connection->debug=true;</p>'
const	ADODB_ERROR_HANDLER 'adodb_throw'
const	ADODB_FETCH_ASSOC 2
const	ADODB_FETCH_BOTH 3
const	ADODB_FETCH_DEFAULT (!defined('ADODB_PREFETCH_ROWS')) 0
	Fetch mode.
const	ADODB_FETCH_NUM 1
const	ADODB_FORCE_EMPTY 2
const	ADODB_FORCE_IGNORE 0
const	ADODB_FORCE_NULL 1
const	ADODB_FORCE_NULL_AND_ZERO 4
const	ADODB_FORCE_VALUE 3
const	ADODB_LAZY_AR 0x03
const	ADODB_OPT_HIGH 2
const	ADODB_OPT_LOW 1
const	ADODB_STRINGMAX_NOLIMIT -2
const	ADODB_STRINGMAX_NOTSET -1
	Constants for returned values from the charMax and textMax methods.
const	ADODB_TABLE_REGEX '([]0-9a-z_\:\"\`\.\@\[-]*)'
const	ADODB_WORK_AR 0x02
*Provides a subset of ADOdb	commands
*Make it more similar to other database drivers The main differences are *When selecting(joining) multiple tables in assoc mode the table *names are included in the assoc keys in the driver *In the table names are stripped from the returned *column names When this results in a	conflict
const	DB_AUTOQUERY_INSERT (!defined('TIMESTAMP_FIRST_YEAR')) 1
	AutoExecute constants (moved from adodb-pear.inc.php since they are only used in here)
const	DB_AUTOQUERY_UPDATE 2
*Originally DB2 drivers were dependent on an ODBC	driver
*This file is part of a Database Abstraction Layer library for PHP **Portable version of oci8	driver
*Make it more similar to other database drivers The main differences are *When selecting(joining) multiple tables in assoc mode the table *names are included in the assoc keys in the driver *In	driver
if(is_array($colfield))	else
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This is to support WORK and LAZY mode **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This is used by the csv proxy driver and is the CacheExecute() *serialization format. **This file is part of ADOdb a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Adapted from the PEAR DB error handling code *Portions(c) 1997-2002 The PHP Group **This file is part of ADOdb a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Less commonly used functions are placed here to reduce size of adodb inc php **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*ADOdbLoadBalancer is a class that allows the user to do read write splitting *and load balancing across multiple servers It can handle and load balance *any number of write capable *(AKA:master) or readonly(AKA including dealing with connection failures and retrying queries on a different *connection instead **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*The following code is modelled on PEAR DB code by Stig Bakken< ssb @fast.no > *and Tomas V V Cox< cox @idecnet.com > Portions(c) 1997-2002 The PHP Group. **This file is part of ADOdb a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*FileDescription **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Requires ODBC Works only on Microsoft Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Requires ADO Works only on MS Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Requires ADO Works only on MS Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Requires ADO and ODBC Works only on MS Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Requires ADO and MSSQL client Works only on MS Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
which *can be downloaded for free a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Support Borland Interbase and later **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Currently MetaTables and *and also inputarr in Execute *Native types have been converted to MetaTypes *Transactions not supported yet **Limitation of url length For see MaxClientRequestBuffer registry value **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This driver re maps a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This driver provides undocumented bind variable mapping from ibm to oracle *The functionality appears to overlap the db2_oci driver **deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Requires firebird client Works on Windows and Unix **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Requires interbase client Works on Windows and Unix **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Supports SELECT FIRST **deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Provides a subset of ADOdb allowing read only access to an LDAP database **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Requires mssql client Works on Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Intended to be used with MSSQL drivers that are sending UCS data to MSSQL *FreeTDS and ODBTP in order to get true cross db compatibility from the *application point of view **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Requires mssql client Works on Windows *	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*deprecated **Optimizes selectLimit() performance with FIRST_ROWS hint. **This file is part of ADOdb a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*deprecated will be removed in ADOdb version **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*deprecated Use oci8 driver instead **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This version has only been tested on Firebird and PHP **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
this file is no longer and the *driver is remapped to the latest available postgres version Maintaining *multiple postgres drivers is no easy so hopefully this will ensure *greater consistency and fewer bugs **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*externalurl	https
*externalurl	https
*Make it more similar to other database drivers The main differences are *When selecting(joining) multiple tables in assoc mode the table *names are included in the assoc keys in the driver *In the table names are stripped from the returned *column names When this results in a the first field gets *preference **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
**This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*Convert a recordset to a html table Multiple tables are generated *if the number of rows is $gSQLBlockRows This is because *web browsers so we break the output into several faster rendering tables **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl	https
*This driver re maps	ibm
	if (!defined( 'ADODB_ALLOW_NEGATIVE_TS')) define( 'ADODB_NO_NEGATIVE_TS'
	if (!defined( 'ADODB_DEFAULT_METATYPE')) define( 'ADODB_DEFAULT_METATYPE'
	if (!defined( 'ADODB_ERROR_HANDLER')) define( 'ADODB_ERROR_HANDLER'
	if (!defined( 'ADODB_ERROR_HANDLER')) define( 'ADODB_ERROR_HANDLER'
	if (!defined( 'IFX_SCROLL')) define( 'IFX_SCROLL'
	if (!defined( 'SINGLEQUOTE')) define( 'SINGLEQUOTE'
*Currently MetaTables and *and also inputarr in Execute *Native types have been converted to MetaTypes *Transactions not supported yet **Limitation of url length For	IIS
this file is no longer and the *driver is remapped to the latest available postgres version Maintaining *multiple postgres drivers is no easy	job
*This is to support	JOIN
*Currently MetaTables and	MetaColumns
*externalurl	MetaTablesSQL
*Convert a recordset to a html table Multiple tables are generated *if the number of rows is $gSQLBlockRows This is because *web browsers	normally
*	NOTE
*	NOTE
*externalurl MetaColumnsSQL *	Note
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This is to support WORK and LAZY mode **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This is used by the csv proxy driver and is the CacheExecute() *serialization format. **This file is part of ADOdb a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Adapted from the PEAR DB error handling code *Portions(c) 1997-2002 The PHP Group **This file is part of ADOdb a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Less commonly used functions are placed here to reduce size of adodb inc php **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*ADOdbLoadBalancer is a class that allows the user to do read write splitting *and load balancing across multiple servers It can handle and load balance *any number of write capable *(AKA:master) or readonly(AKA including dealing with connection failures and retrying queries on a different *connection instead **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at you	option )
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*The following code is modelled on PEAR DB code by Stig Bakken< ssb @fast.no > *and Tomas V V Cox< cox @idecnet.com > Portions(c) 1997-2002 The PHP Group. **This file is part of ADOdb a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*FileDescription **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Requires ODBC Works only on Microsoft Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Requires ADO Works only on MS Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Requires ADO Works only on MS Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Requires ADO and ODBC Works only on MS Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Requires ADO and MSSQL client Works only on MS Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
which *can be downloaded for free a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Support Borland Interbase and later **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Currently MetaTables and *and also inputarr in Execute *Native types have been converted to MetaTypes *Transactions not supported yet **Limitation of url length For see MaxClientRequestBuffer registry value **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This driver re maps a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This driver provides undocumented bind variable mapping from ibm to oracle *The functionality appears to overlap the db2_oci driver **deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Requires firebird client Works on Windows and Unix **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Requires interbase client Works on Windows and Unix **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Supports SELECT FIRST **deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Provides a subset of ADOdb allowing read only access to an LDAP database **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Requires mssql client Works on Windows **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Intended to be used with MSSQL drivers that are sending UCS data to MSSQL *FreeTDS and ODBTP in order to get true cross db compatibility from the *application point of view **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Requires mssql client Works on Windows a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*externalurl MetaColumnsSQL as Netezza doesn s web site and documentation *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*deprecated **Optimizes selectLimit() performance with FIRST_ROWS hint. **This file is part of ADOdb a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*deprecated will be removed in ADOdb version **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*deprecated Use oci8 driver instead **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This version has only been tested on Firebird and PHP **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
this file is no longer and the *driver is remapped to the latest available postgres version Maintaining *multiple postgres drivers is no easy so hopefully this will ensure *greater consistency and fewer bugs **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*externalurl a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*externalurl a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Make it more similar to other database drivers The main differences are *When selecting(joining) multiple tables in assoc mode the table *names are included in the assoc keys in the driver *In the table names are stripped from the returned *column names When this results in a the first field gets *preference **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*deprecated **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
**This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Convert a recordset to a html table Multiple tables are generated *if the number of rows is $gSQLBlockRows This is because *web browsers so we break the output into several faster rendering tables **This file is part of a Database Abstraction Layer library for PHP **ingroup ADOdb *externalurl released under both the BSD Clause *and the GNU Lesser General Public Licence(LGPL) v2.1 or at your	option
*Convert a recordset to a html table Multiple tables are generated *if the number of rows is $gSQLBlockRows This is because *web browsers so we break the output into several *	smaller
return	true
*Currently	unsupported
this file is no longer	used
which *can be downloaded for free	via

Detailed Description

Typedef Documentation

equiv

using equiv

Initial value:

"Content-Type" content="text/html; charset=utf-8">
 * Also, all SQL query strings must be submitted as UTF-8 encoded text.
 *
 * This file is part of ADOdb, a Database Abstraction Layer library for PHP.
 *
 * @ingroup ADOdb
 * @externalurl https:
 * @externalurl https:
 *
 * The ADOdb Library is dual-licensed, released under both the BSD 3-Clause
 * and the GNU Lesser General Public Licence (LGPL) v2.1 or, at your option,
 * any later version. This means you can use it in proprietary products.
 * See the LICENSE.md file distributed with this source code for details.
 * @license BSD-3-Clause
 * @license LGPL-2.1-or-later
 *
 * @copyright 2000-2013 John Lim
 * @copyright 2014 Damien Regad, Mark Newnham and the ADOdb community
 * @author Robert Twitty <rtwitty@neutron.ushmm.org>
 */
 
 
if (!defined('ADODB_DIR')) die()

Function Documentation

__call()

__call	(		$method,
			$args )

Magic method to intercept method and callback to the proper ADODB object for write/readonly connections.

Parameters

string	$method	ADODB method to call.
array	$args	Arguments to the ADODB method.

Return values

bool|mixed

Exceptions

Exception

__get()

__get

(

$property

)

Magic method to proxy property getter calls back to the proper ADODB object currently in use.

Parameters

$property

Return values

mixed

Exceptions

Exception

__set()

__set	(		$property,
			$value )

Magic method to proxy property setter calls back to the proper ADODB object currently in use.

Parameters

$property
$value

Return values

mixed

Exceptions

Exception

_adodb_backtrace()

_adodb_backtrace	(		$printOrArr = true,
			$maximumDepth = 9999,
			$elementsToIgnore = 0,
			$ishtml = null )

Pretty print the debug_backtrace function.

Parameters

string[] | bool	$printOrArr	Whether to print the result directly or return the result
int	$maximumDepth	The maximum depth of the array to traverse
int	$elementsToIgnore	The backtrace array indexes to ignore
null | bool	$ishtml	True if we are in a CGI environment, false for CLI, null to auto detect

Return values

string

Formatted backtrace

_adodb_column_sql_oci8()

_adodb_column_sql_oci8	(	&	$zthis,
			$action,
			$type,
			$fname,
			$fnameq,
			$arrFields )

This private method is used to help construct the update/sql which is generated by GetInsertSQL and GetUpdateSQL.

It handles the string construction of 1 column -> sql string based on the column type. We want to do 'safe' handling of BLOBs

Parameters

string	the type of sql we are trying to create 'I' or 'U'.
string	column data type from the db\MetaType() method
string	the column name
array	the column value

Return values

string

_adodb_debug_execute()

_adodb_debug_execute	(		$zthis,
			$sql,
			$inputarr )

Replaces standard _execute when debug mode is enabled.

Parameters

ADOConnection	$zthis	An ADOConnection object
string | string[]	$sql	A string or array of SQL statements
string[] | null	$inputarr	An optional array of bind parameters

Return values

handle|void

A handle to the executed query

_adodb_getdate()

_adodb_getdate	(		$origd = false,
			$fast = false,
			$is_gmt = false )

Low-level function that returns the getdate() array.

We have a special $fast flag, which if set to true, will return fewer array values, and is much faster as it does not calculate dow, etc.

_adodb_getinsertsql()

_adodb_getinsertsql	(	&	$zthis,
			$rs,
			$arrFields,
			$force = 2 )

There is a special case of this function for the oci8 driver.

The proper way to handle an insert w/ a blob in oracle requires a returning clause with bind variables and a descriptor blob.

_adodb_getmenu_option()

_adodb_getmenu_option	(		$defstr,
			$compare,
			$value,
			$display )

Print the OPTION tags for getmenu functions.

ADOdb internal function, used by _adodb_getmenu() and _adodb_getmenu_gp().

Parameters

string	$defstr	Default values
string	$compare	Value to compare against defaults
string	$value	Ready-to-print value="xxx" (or empty) string
string	$display	Display value

Return values

string

HTML

_adodb_getmenu_select()

_adodb_getmenu_select	(		$name,
			$defstr = '',
			$blank1stItem = true,
			$multiple = false,
			$size = 0,
			$selectAttr = '' )

Generate the opening SELECT tag for getmenu functions.

ADOdb internal function, used by _adodb_getmenu() and _adodb_getmenu_gp().

Parameters

string	$name
string	$defstr
bool	$blank1stItem
bool	$multiple
int	$size
string	$selectAttr

Return values

string

HTML

_adodb_is_leap_year()

_adodb_is_leap_year

(

$year

)

Checks for leap year, returns true if it is.

No 2-digit year check. Also handles julian calendar correctly.

_adodb_pageexecute_all_rows()

_adodb_pageexecute_all_rows	(		$zthis,
			$sql,
			$nrows,
			$page,
			$inputarr = false,
			$secs2cache = 0 )

Execute query with pagination including record count.

This code might not work with SQL that has UNION in it. Also if you are using cachePageExecute(), there is a strong possibility that data will get out of sync. cachePageExecute() should only be used with tables that rarely change.

Parameters

ADOConnection	$zthis	Connection
string	$sql	Query to execute
int	$nrows	Number of rows per page
int	$page	Page number to retrieve (1-based)
array	$inputarr	Array of bind variables
int	$secs2cache	Time-to-live of the cache (in seconds), 0 to force query execution

Return values

ADORecordSet|bool

Author

Cornel G conyg.nosp@m.@fx..nosp@m.ro

_adodb_pageexecute_no_last_page()

_adodb_pageexecute_no_last_page	(		$zthis,
			$sql,
			$nrows,
			$page,
			$inputarr = false,
			$secs2cache = 0 )

Execute query with pagination without last page information.

This code might not work with SQL that has UNION in it. Also if you are using cachePageExecute(), there is a strong possibility that data will get out of sync. cachePageExecute() should only be used with tables that rarely change.

Parameters

ADOConnection	$zthis	Connection
string	$sql	Query to execute
int	$nrows	Number of rows per page
int	$page	Page number to retrieve (1-based)
array	$inputarr	Array of bind variables
int	$secs2cache	Time-to-live of the cache (in seconds), 0 to force query execution

Return values

ADORecordSet|bool

Author

Iván Oliva

_adodb_quote_fieldname()

_adodb_quote_fieldname	(		$zthis,
			$fieldName )

Performs case conversion and quoting of the given field name.

See Global variable $ADODB_QUOTE_FIELDNAMES.

Parameters

ADOConnection	$zthis
string	$fieldName

Return values

string

Quoted field name

_adodb_safedate()

_adodb_safedate

(

$s

)

Parse date string to prevent injection attack.

Parameters

string

$s

Return values

string

_adodb_safedateq()

_adodb_safedateq

(

$s

)

Parse date string to prevent injection attack.

Date string will have one quote at beginning e.g. '3434343'

Parameters

string

$s

Return values

string

_blobDecode()

_blobDecode

(

$blob

)

Auto function called on read of blob to decode.

Parameters

string

$blob

Value to decode

Return values

string

Decoded blob

_pconnect()

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

Connect to a database with a persistent connection.

Parameters

string | null	$argHostname	The host to connect to.
string | null	$argUsername	The username to connect as.
string | null	$argPassword	The password to connect with.
string | null	$argDatabasename	The name of the database to start in when connected.

Return values

bool|null

True if connected successfully, false if connection failed, or null if the mysqli extension isn't currently loaded.

_query()

_query	(		$sql,
			$inputarr = false )

Execute a query.

Parameters

string | array	$sql	Query to execute.
array	$inputarr	An optional array of parameters.

Return values

object|bool

Query identifier or true if execution successful, false if failed.

_rs2serialize()

_rs2serialize	(	&	$rs,
			$conn = false,
			$sql = '' )

Convert a recordset into special format.

Parameters

ADORecordSet	$rs	the recordset
ADOConnection	$conn
string	$sql

Return values

string

the CSV formatted data

addConnection()

addConnection

(

$obj

)

Adds a new database connection to the pool, but no actual connection is made until its needed.

Parameters

$obj

Return values

bool

Exceptions

Exception

adodb_backtrace()

adodb_backtrace	(		$printOrArr = true,
			$levels = 9999,
			$ishtml = null )

Perform a stack-crawl and pretty print it.

Parameters

bool	$printOrArr	Pass in a boolean to indicate print, or an $exception->trace array (assumes that print is true then).
int	$levels	Number of levels to display
mixed	$ishtml

Return values

string

adodb_dow()

adodb_dow	(		$year,
			$month,
			$day )

Returns day of week, 0 = Sunday,... 6=Saturday.

Algorithm from PEAR\Date_Calc

ADODB_Error_Handler()

ADODB_Error_Handler	(		$dbms,
			$fn,
			$errno,
			$errmsg,
			$p1,
			$p2,
		&	$thisConnection )

Default Error Handler.

This will be called with the following params

Parameters

$dbms	the RDBMS you are connecting to
$fn	the name of the calling function (in uppercase)
$errno	the native error number from the database
$errmsg	the native error msg from the database
$p1	$fn specific parameter - see below
$p2	$fn specific parameter - see below
$thisConn	$current connection object - can be false if no connection object created

ADODB_Error_PEAR()

ADODB_Error_PEAR	(		$dbms,
			$fn,
			$errno,
			$errmsg,
			$p1 = false,
			$p2 = false )

Error Handler with PEAR support.

This will be called with the following params

Parameters

$dbms	the RDBMS you are connecting to
$fn	the name of the calling function (in uppercase)
$errno	the native error number from the database
$errmsg	the native error msg from the database
$p1	$fn specific parameter - see below
$P2	$fn specific parameter - see below

adodb_get_gmt_diff()

adodb_get_gmt_diff	(		$y,
			$m,
			$d )

get local time zone offset from GMT.

Does not handle historical timezones before 1970.

adodb_gmmktime()

adodb_gmmktime	(		$hr,
			$min,
			$sec,
			$mon = false,
			$day = false,
			$year = false,
			$is_dst = false )

Returns a timestamp given a GMT/UTC time.

Note that $is_dst is not implemented and is ignored.

adodb_is_leap_year()

adodb_is_leap_year

(

$year

)

checks for leap year, returns true if it is.

Has 2-digit year check

adodb_last_date_status()

adodb_last_date_status

(

)

Returns the status of the last date calculation and whether it exceeds the limit of ADODB_FUTURE_DATE_CUTOFF_YEARS.

Return values

boolean

adodb_mktime()

adodb_mktime	(		$hr,
			$min,
			$sec,
			$mon = false,
			$day = false,
			$year = false,
			$is_dst = false,
			$is_gmt = false )

Return a timestamp given a local time.

Originally by jackbbs. Note that $is_dst is not implemented and is ignored.

Not a very fast algorithm - O(n) operation. Could be optimized to O(1).

ADODB_PEAR_Error()

ADODB_PEAR_Error

(

)

Returns last PEAR_Error object.

This error might be for an error that occurred several sql statements ago.

adodb_strip_order_by()

adodb_strip_order_by

(

$sql

)

Strip the ORDER BY clause from the outer SELECT.

Parameters

string

$sql

Return values

string

adodb_throw()

adodb_throw	(		$dbms,
			$fn,
			$errno,
			$errmsg,
			$p1,
			$p2,
			$thisConnection )

Default Error Handler.

Parameters

string	$dbms	the RDBMS you are connecting to
string	$fn	the name of the calling function (in uppercase)
int	$errno	the native error number from the database
string	$errmsg	the native error msg from the database
mixed	$p1	$fn specific parameter - see below
mixed	$p2	$fn specific parameter - see below

ADODB_TransMonitor()

ADODB_TransMonitor	(		$dbms,
			$fn,
			$errno,
			$errmsg,
			$p1,
			$p2,
		&	$thisConnection )

For transaction handling.

Parameters

$dbms
$fn
$errno
$errmsg
$p1
$p2
$thisConnection

adodb_tz_offset()

adodb_tz_offset	(		$gmt,
			$ignored = true )

Compute timezone offset.

Parameters

int	$gmt	Time offset from GMT, in seconds
bool	$ignored	Param leftover from removed PHP4-compatibility code kept to avoid altering function signature.

Return values

string

adodb_write_file()

adodb_write_file	(		$filename,
			$contents,
			$debug = false )

Save a file $filename and its $contents (normally for caching) with file locking Returns true if ok, false if fopen/fwrite error, 0 if rename error (eg.

file is locked)

adodb_year_digit_check()

adodb_year_digit_check

(

$y

)

Fix 2-digit years.

Works for any century. Assumes that if 2-digit is more than 30 years in future, then previous century.

ADOLoadCode()

ADOLoadCode

(

$dbType

)

Load the code for a specific database driver.

Private function. Do not use.

ADOLoadDB()

ADOLoadDB

(

$dbType

)

Synonym for ADOLoadCode.

Private function. Do not use.

Deprecated

ADONewConnection()

ADONewConnection

(

$db = ''

)

Instantiate a new Connection class for a specific database driver.

Parameters

string

$db

Database Connection object to create. If undefined, use the last database driver that was loaded by ADOLoadCode().

Return values

ADOConnection|false

The freshly created instance of the Connection class or false in case of error.

beginTrans()

beginTrans

(

)

Begin a Transaction.

Must be followed by CommitTrans() or RollbackTrans().

Return values

bool	true if succeeded or false if database does not support transactions

blobDecode()

blobDecode

(

$blob

)

Manually decode a blob.

since we auto-decode all blob's since 2.42, BlobDecode should not do any transforms

Parameters

string

$blob

Return values

string

the same blob

blobEncode()

blobEncode

(

$blob

)

Encodes a blob, then assigns an id ready to be used.

Parameters

string

$blob

The blob to be encoded

Return values

bool

success

clusterExecute()

clusterExecute	(		$sql,
			$inputarr = false,
			$return_all_results = false,
			$existing_connections_only = true )

Executes the same SQL QUERY on the entire cluster of connections.

Would be used for things like SET SESSION TIME ZONE calls and such.

Parameters

	$sql
bool	$inputarr
bool	$return_all_results
bool	$existing_connections_only

Return values

array|bool|mixed

Exceptions

Exception

commitTrans()

commitTrans

(

$ok = true

)

Commits a transaction.

Parameters

bool

$ok

false to rollback transaction, true to commit

Return values

bool

createSequence()

createSequence	(		$seqname = 'adodbseq',
			$startID = 1 )

Creates a sequence in the database.

@externalurl https://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:createsequence

Parameters

string	$seqname	The sequence name.
int	$startID	The start id.

Return values

ADORecordSet|bool

A record set if executed successfully, otherwise false.

csv2rs()

csv2rs	(		$url,
		&	$err,
			$timeout = 0,
			$rsclass = 'ADORecordSet_array' )

Open CSV file and convert it into Data.

Parameters

string	$url	file/ftp/http url
string	&$err	returns the error message
int	$timeout	dispose if recordset has been alive for $timeout secs
string	$rsclass	RecordSet class to return

Return values

ADORecordSet|false

recordset, or false if error occurred. If no error occurred in sql INSERT/UPDATE/DELETE, empty recordset is returned.

execute()

execute	(		$sql,
			$inputarr = false )

Use this instead of __call() as it significantly reduces the overhead of call_user_func_array().

Parameters

	$sql
bool	$inputarr

Return values

array|bool|mixed

Exceptions

Exception

genID()

genID	(		$seqname = 'adodbseq',
			$startID = 1 )

A portable method of creating sequence numbers.

@externalurl https://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:genid

Parameters

string	$seqname	(Optional) The name of the sequence to use.
int	$startID	(Optional) The point to start at in the sequence.

Return values

int

getConnection()

getConnection	(		$type = 'write',
			$pin_connection = null )

Returns the ADODB connection object by database type.

Ensures that it's connected and the session variables are executed.

Parameters

string	$type
null	$pin_connection

Return values

ADOConnection|bool

Exceptions

Exception

getConnectionById()

getConnectionById

(

$connection_id

)

Returns the ADODB connection object by connection_id.

Ensures that it's connected and the session variables are executed.

Parameters

$connection_id

Return values

bool|ADOConnection

Exceptions

Exception

getConnectionByWeight()

getConnectionByWeight

(

$type

)

Returns a database connection of the specified type.

Takes into account the connection weight for load balancing.

Parameters

string

$type

Type of database connection, either: 'write' capable or 'readonly'

Return values

bool|int|string

getLoadBalancedConnection()

getLoadBalancedConnection

(

$type

)

Returns the proper database connection when taking into account sticky sessions and load balancing.

Parameters

$type

Return values

bool|int|mixed|string

ifx_props()

ifx_props	(		$coltype,
			$collength )

!Eos Auxiliary function to Parse coltype,collength.

Used by Metacolumns return: array ($mtype,$length,$precision,$nullable) (similar to ifx_fieldpropierties)

isReadOnlyQuery()

isReadOnlyQuery

(

$sql

)

Determines if a SQL query is read-only or not.

Parameters

string

$sql

SQL Query to test.

Return values

bool

lens_ParseArgs()

if(!function_exists('ctype_alnum')) lens_ParseArgs	(		$args,
			$endstmtchar = ',',
			$tokenchars = '_.-' )

Parse arguments, treat "text" (text) and 'text' as quotation marks.

To escape, use "" or '' or ))

Will read in "abc def" sans quotes, as: abc def Same with 'abc def'. However if abc def, then will read in as abc def

Parameters

endstmtchar	Character that indicates end of statement
tokenchars	Include the following characters in tokens apart from A-Z and 0-9

Returns

2 dimensional array containing parsed tokens.

metaColumns()

metaColumns	(		$table,
			$normalize = true )

Return an array of information about a table's columns.

Parameters

string	$table	The name of the table to get the column info for.
bool	$normalize	(Optional) Unused.

Return values

ADOFieldObject[]|bool

An array of info for each column, or false if it could not determine the info.

metaIndexes()

metaIndexes	(		$table,
			$primary = false,
			$owner = false )

Get a list of indexes on the specified table.

Parameters

string	$table	The name of the table to get indexes for.
bool	$primary	(Optional) Whether or not to include the primary key.
bool	$owner	(Optional) Unused.

Return values

array|bool

An array of the indexes, or false if the query to get the indexes failed.

metaTables()

metaTables	(		$ttype = false,
			$showSchema = false,
			$mask = false )

Retrieves a list of tables based on given criteria.

Returns the tables in the database.

Parameters

string | bool	$ttype	(Optional) Table type = 'TABLE', 'VIEW' or false=both (default)
string | bool	$showSchema	(Optional) schema name, false = current schema (default)
string | bool	$mask	(Optional) filters the table by name

Return values

array

list of tables

Parameters

mixed	$ttype
bool	$showSchema
mixed	$mask

Return values

string[]

NewADOConnection()

NewADOConnection

(

$db = ''

)

Synonym for ADONewConnection for people like me who cannot remember the correct name.

Parameters

string

[$db]

Return values

ADOConnection|false

newDataDictionary()

newDataDictionary	(	&	$conn,
			$drivername = '' )

Get a new Data Dictionary object for the connection.

Parameters

ADOConnection	$conn
string	$drivername

Return values

ADODB_DataDict|false

offsetDate()

offsetDate	(		$dayFraction,
			$date = false )

Creates a portable date offset field, for use in SQL statements.

@externalurl https://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:offsetdate

Parameters

float	$dayFraction	A day in floating point
string | bool	$date	(Optional) The date to offset. If false, uses CURDATE()

Return values

string

param()

param	(		$name,
			$type = 'C' )

Returns a driver-specific format for a bind parameter.

Parameters

string	$name
string	$type	(ignored in driver)

Return values

string

Unlike the native driver, we use :name parameters instead of offsets

Parameters

string	$name
string	$type	(ignored in driver)

Return values

string

prepare()

prepare

(

$sql

)

Prepares an SQL statement and returns a handle to use.

This is not used by bound parameters anymore

@externalurl https://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:prepare

Todo

update this function to handle prepared statements correctly

Parameters

string

$sql

The SQL to prepare.

Return values

bool|array

The SQL that was provided and the prepared parameters, or false if the preparation fails

removeConnection()

removeConnection

(

$i

)

Removes a database connection from the pool.

Parameters

$i

Return values

bool

rollbackTrans()

rollbackTrans

(

)

Rollback a smart transaction.

@externalurl https://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:rollbacktrans

Return values

bool

rowLock()

rowLock	(		$table,
			$where,
			$col = false )

Lock a table row for a duration of a transaction.

@externalurl https://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:rowlock @externalurl https://firebirdsql.org/refdocs/langrefupd21-notes-withlock.html

Parameters

string	$table	The table(s) to lock rows for.
string	$where	(Optional) The WHERE clause to use to determine which rows to lock.
string	$col	(Optional) The columns to select.

Return values

bool	True if the locking SQL statement executed successfully, otherwise false.

selectLimit()

selectLimit	(		$sql,
			$nrows = -1,
			$offset = -1,
			$inputarr = false,
			$secs2cache = 0 )

Executes a provided SQL statement and returns a handle to the result, with the ability to supply a starting offset and record count.

@externalurl https://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:selectlimit

Parameters

string	$sql	The SQL to execute.
int	$nrows	(Optional) The limit for the number of records you want returned. By default, all results.
int	$offset	(Optional) The offset to use when selecting the results. By default, no offset.
array | bool	$inputarr	(Optional) Any parameter values required by the SQL statement, or false if none.
int	$secs2cache	(Optional) If greater than 0, perform a cached execute. By default, normal execution.

Return values

ADORecordSet|false

The query results, or false if the query failed to execute.

serverInfo()

serverInfo

(

)

Get information about the current Firebird server.

Gets the version iformation from the server.

Return values

array
string[]

SetAutoCommit()

SetAutoCommit

(

$auto_commit

)

Parameters

bool

$auto_commit

Return values

void

setSessionInitSQL()

setSessionInitSQL

(

$sql

)

Defines SQL queries that are executed each time a new database connection is established.

Parameters

$sql

Return values

bool

setSessionVariable()

setSessionVariable	(		$name,
			$value,
			$execute_immediately = true )

Allow setting session variables that are maintained across connections.

Its important that these are set using name/value, so it can determine if the same variable is set multiple times causing bloat/clutter when new connections are established. For example if the time_zone is set to many different ones through the course of a single connection, a new connection should only set it to the most recent value.

Parameters

	$name
	$value
bool	$execute_immediately

Return values

array|bool|mixed

Exceptions

Exception

sqlDate()

sqlDate	(		$fmt,
			$col = false )

Returns a portably-formatted date string from a timestamp database column.

@externalurl https://adodb.org/dokuwiki/doku.php?id=v5:reference:connection:sqldate

Firebird does not support an AM/PM format, so the A indicator always shows AM

Parameters

string	$fmt	The date format to use.
string | bool	$col	(Optional) The table column to date format, or if false, use NOW().

Return values

string

The SQL DATE_FORMAT() string, or empty if the provided date format was empty.

updateBlob()

updateBlob	(		$table,
			$column,
			$val,
			$where,
			$blobtype = 'BLOB' )

Insert blob data into a database column.

Parameters

string	$table	table to insert
string	$column	column to insert
string	$val	value to insert
string	$where	string to find unique record
string	$blobtype	BLOB or CLOB

Return values

bool

success

updateBlobFile()

updateBlobFile	(		$table,
			$column,
			$path,
			$where,
			$blobtype = 'BLOB' )

Insert blob data into a database column directly from file.

Parameters

string	$table	table to insert
string	$column	column to insert
string	$path	physical file name
string	$where	string to find unique record
string	$blobtype	BLOB or CLOB

Return values

bool

success

Variable Documentation

$ADODB_sybase_mths

$ADODB_sybase_mths

Initial value:

= array(
    'JAN'=>1,'FEB'=>2,'MAR'=>3,'APR'=>4,'MAY'=>5,'JUN'=>6,
    'JUL'=>7,'AUG'=>8,'SEP'=>9,'OCT'=>10,'NOV'=>11,'DEC'=>12)

$metaColumnsSQL

$metaColumnsSQL

Initial value:

= "SELECT a.attname,t.typname,a.attlen,a.atttypmod,a.attnotnull,a.atthasdef,a.attnum
        FROM pg_class c, pg_attribute a,pg_type t
        WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s')) and a.attname not like '....%%'
        AND a.attnum > 0 AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum"

$metaColumnsSQL1

$metaColumnsSQL1

Initial value:

= "SELECT a.attname, t.typname, a.attlen, a.atttypmod, a.attnotnull, a.atthasdef, a.attnum
        FROM pg_class c, pg_attribute a, pg_type t, pg_namespace n
        WHERE relkind in ('r','v') AND (c.relname='%s' or c.relname = lower('%s'))
        and c.relnamespace=n.oid and n.nspname='%s'
        and a.attname not like '....%%' AND a.attnum > 0
        AND a.atttypid = t.oid AND a.attrelid = c.oid ORDER BY a.attnum"

$metaKeySQL

$metaKeySQL

Initial value:

= "SELECT ic.relname AS index_name, a.attname AS column_name,i.indisunique AS unique_key, i.indisprimary AS primary_key
    FROM pg_class bc, pg_class ic, pg_index i, pg_attribute a WHERE bc.oid = i.indrelid AND ic.oid = i.indexrelid AND (i.indkey[0] = a.attnum OR i.indkey[1] = a.attnum OR i.indkey[2] = a.attnum OR i.indkey[3] = a.attnum OR i.indkey[4] = a.attnum OR i.indkey[5] = a.attnum OR i.indkey[6] = a.attnum OR i.indkey[7] = a.attnum) AND a.attrelid = bc.oid AND bc.relname = '%s'"

$metaTablesSQL

$metaTablesSQL

Initial value:

= "select tablename,'T' from pg_tables where tablename not like 'pg\_%'
        and tablename not in ('sql_features', 'sql_implementation_info', 'sql_languages',
            'sql_packages', 'sql_sizing', 'sql_sizing_profiles')
        union
        select viewname,'V' from pg_views where viewname not like 'pg\_%'"

_connectionID

else $this _connectionID

Initial value:

= $fn($argHostname,$argUsername,$argPassword,
                    $this->charSet,$this->buffers,$this->dialect)

ADODB_ASSOC_CASE_LOWER

const ADODB_ASSOC_CASE_LOWER 0

Associative array case constants.

By defining the ADODB_ASSOC_CASE constant to one of these values, it is possible to control the case of field names (associative array's keys) when operating in ADODB_FETCH_ASSOC fetch mode.

• LOWER: $rs->fields['orderid']
• UPPER: $rs->fields['ORDERID']
• NATIVE: $rs->fields['OrderID'] (or whatever the RDBMS will return)

The default is to use native case-names.

NOTE: This functionality is not implemented everywhere, it currently works only with: mssql, odbc, oci8 and ibase derived drivers

ADODB_FETCH_DEFAULT

const ADODB_FETCH_DEFAULT(!defined( 'ADODB_PREFETCH_ROWS'))

(

!

defined 'ADODB_PREFETCH_ROWS'

)

0

Fetch mode.

Set global variable $ADODB_FETCH_MODE to one of these constants or use the SetFetchMode() method to control how recordset fields are returned when fetching data.

• NUM: array()
• ASSOC: array('id' => 456, 'name' => 'john')
• BOTH: array(0 => 456, 'id' => 456, 1 => 'john', 'name' => 'john')
• DEFAULT: driver-dependent

ADODB_STRINGMAX_NOTSET

const ADODB_STRINGMAX_NOTSET -1

Constants for returned values from the charMax and textMax methods.

If not specifically defined in the driver, methods return the NOTSET value.

else

if (is_array( $colfield)) else

Initial value:

{
        foreach ($colarr as $v) {
            if (!is_numeric($v)) $vq = $db->qstr($v);
            else $vq = $v;
            $v = trim($v);
            if (strlen($v) == 0 ) $v = 'null';
            if (!$hidecnt) {
                $sel .= $iif ?
                    "\n\t$aggfn(IIF($colfield=$vq,1,0)) AS "$v\", "
                    :
                    "\n\t$aggfn(CASE WHEN $colfield=$vq THEN 1 ELSE 0 END) AS "$v\", ";
            }
            if ($aggfield) {
                if ($hidecnt) $label = $v;
                else $label = "{$v}_$aggfield";
                $sel .= $iif ?
                    "\n\t$aggfn(IIF($colfield=$vq,$aggfield,0)) AS "$label\", "
                    :
                    "\n\t$aggfn(CASE WHEN $colfield=$vq THEN $aggfield ELSE 0 END) AS "$label\", ";
            }
        }
    }
    if ($aggfield && $aggfield != '1'){
        $agg = "$aggfn($aggfield)";
        $sel .= "\n\t$agg as "$sumlabel$aggfield\", ";
    }
 
    if ($showcount)
        $sel .= "\n\tSUM(1) as Total"