API Documentation
\

\

Classes

ADOConnection Connection object. For connecting to databases, and executing queries.
ADODB2_access
ADODB2_db2
ADODB2_firebird V5.20dev ??-???-2014 (c) 2000-2014 John Lim (jlim#natsoft.com). All rights reserved.
ADODB2_generic
ADODB2_ibase
ADODB2_informix
ADODB2_mssql
ADODB2_mssqlnative
ADODB2_mysql
ADODB2_oci8
ADODB2_postgres
ADODB2_sapdb
ADODB2_sqlite
ADODB2_sybase
ADODB_access Connection object. For connecting to databases, and executing queries.
ADODB_Active_DB
ADODB_Active_DB
ADODB_Active_Record
ADODB_Active_Record
ADODB_Active_Table
ADODB_Active_Table
ADODB_ado Connection object. For connecting to databases, and executing queries.
ADODB_ado Connection object. For connecting to databases, and executing queries.
ADODB_ado_access Connection object. For connecting to databases, and executing queries.
ADODB_ado_mssql Connection object. For connecting to databases, and executing queries.
ADODB_ads Connection object. For connecting to databases, and executing queries.
ADODB_BASE_RS
ADODB_borland_ibase Connection object. For connecting to databases, and executing queries.
ADODB_Cache_File
ADODB_Cache_MemCache
ADODB_Compress_Bzip2
ADODB_Compress_Gzip
ADODB_csv Connection object. For connecting to databases, and executing queries.
ADODB_DataDict
ADODB_db2 Connection object. For connecting to databases, and executing queries.
ADODB_db2oci Connection object. For connecting to databases, and executing queries.
ADODB_db2oci Connection object. For connecting to databases, and executing queries.
ADODB_Encrypt_MCrypt
ADODB_Encrypt_MD5
ADODB_Encrypt_Secret NOTE: On Windows 2000 SP4 with PHP 4.3.1, MCrypt 2.4.x, and Apache 1.3.28, the session didn't work properly.
ADODB_Encrypt_SHA1
ADODB_Exception
ADODB_fbsql Connection object. For connecting to databases, and executing queries.
ADODB_firebird Connection object. For connecting to databases, and executing queries.
ADODB_ibase Connection object. For connecting to databases, and executing queries.
ADODB_informix Connection object. For connecting to databases, and executing queries.
ADODB_informix72 Connection object. For connecting to databases, and executing queries.
ADODB_Iterator
ADODB_Iterator_empty
ADODB_ldap Connection object. For connecting to databases, and executing queries.
ADODB_mssql Connection object. For connecting to databases, and executing queries.
ADODB_mssql_n Connection object. For connecting to databases, and executing queries.
ADODB_mssqlnative Connection object. For connecting to databases, and executing queries.
ADODB_mssqlpo Connection object. For connecting to databases, and executing queries.
ADODB_mysql Connection object. For connecting to databases, and executing queries.
ADODB_mysqli Connection object. For connecting to databases, and executing queries.
ADODB_mysqlt Connection object. For connecting to databases, and executing queries.
ADODB_mysqlt Connection object. For connecting to databases, and executing queries.
ADODB_netezza Connection object. For connecting to databases, and executing queries.
ADODB_oci8 Connection object. For connecting to databases, and executing queries.
ADODB_oci805 Connection object. For connecting to databases, and executing queries.
ADODB_oci8po Connection object. For connecting to databases, and executing queries.
ADODB_oci8quercus Connection object. For connecting to databases, and executing queries.
ADODB_odbc Connection object. For connecting to databases, and executing queries.
ADODB_ODBC_DB2 Connection object. For connecting to databases, and executing queries.
ADODB_odbc_mssql Connection object. For connecting to databases, and executing queries.
ADODB_odbc_oracle Connection object. For connecting to databases, and executing queries.
ADODB_odbtp Connection object. For connecting to databases, and executing queries.
ADODB_odbtp_unicode Connection object. For connecting to databases, and executing queries.
ADODB_oracle Connection object. For connecting to databases, and executing queries.
ADODB_Pager
ADODB_pdo Connection object. For connecting to databases, and executing queries.
ADODB_pdo_base Connection object. For connecting to databases, and executing queries.
ADODB_pdo_mssql Connection object. For connecting to databases, and executing queries.
ADODB_pdo_mysql Connection object. For connecting to databases, and executing queries.
ADODB_pdo_oci Connection object. For connecting to databases, and executing queries.
ADODB_pdo_pgsql Connection object. For connecting to databases, and executing queries.
ADODB_pdo_sqlite Connection object. For connecting to databases, and executing queries.
ADODB_pdo_sqlsrv Provided by Ned Andre to support sqlsrv library
adodb_perf
ADODB_postgres64 Connection object. For connecting to databases, and executing queries.
ADODB_postgres7 Connection object. For connecting to databases, and executing queries.
ADODB_postgres8 Connection object. For connecting to databases, and executing queries.
ADODB_postgres9 Connection object. For connecting to databases, and executing queries.
ADODB_proxy Connection object. For connecting to databases, and executing queries.
ADODB_Replicate
ADODB_SAPDB Connection object. For connecting to databases, and executing queries.
ADODB_Session
ADODB_Session
ADODB_sqlanywhere Connection object. For connecting to databases, and executing queries.
ADODB_sqlite Connection object. For connecting to databases, and executing queries.
ADODB_sqlite3 Connection object. For connecting to databases, and executing queries.
ADODB_sqlitepo Connection object. For connecting to databases, and executing queries.
ADODB_sybase Connection object. For connecting to databases, and executing queries.
ADODB_sybase_ase Connection object. For connecting to databases, and executing queries.
ADODB_text Connection object. For connecting to databases, and executing queries.
ADODB_vfp Connection object. For connecting to databases, and executing queries.
ADOFetchObj Internal placeholder for record objects. Used by ADORecordSet->FetchObj().
ADOFieldObject Helper class for FetchFields -- holds info on a column
ADOPDOStatement
ADORecordSet RecordSet class that represents the dataset returned by the database.
ADORecordSet_access RecordSet class that represents the dataset returned by the database.
ADORecordSet_ado RecordSet class that represents the dataset returned by the database.
ADORecordSet_ado RecordSet class that represents the dataset returned by the database.
ADORecordSet_ado_access RecordSet class that represents the dataset returned by the database.
ADORecordSet_ado_mssql RecordSet class that represents the dataset returned by the database.
ADORecordSet_ads RecordSet class that represents the dataset returned by the database.
ADORecordSet_array This class encapsulates the concept of a recordset created in memory as an array. This is useful for the creation of cached recordsets.
ADORecordSet_array_mssql This class encapsulates the concept of a recordset created in memory as an array. This is useful for the creation of cached recordsets.
ADORecordSet_array_mssqlnative This class encapsulates the concept of a recordset created in memory as an array. This is useful for the creation of cached recordsets.
ADORecordSet_array_mysqli This class encapsulates the concept of a recordset created in memory as an array. This is useful for the creation of cached recordsets.
ADORecordSet_array_sybase This class encapsulates the concept of a recordset created in memory as an array. This is useful for the creation of cached recordsets.
ADORecordSet_assoc_postgres7 RecordSet class that represents the dataset returned by the database.
ADORecordSet_assoc_postgres8 RecordSet class that represents the dataset returned by the database.
ADORecordSet_assoc_postgres9 RecordSet class that represents the dataset returned by the database.
ADORecordSet_borland_ibase
ADORecordset_csv
ADORecordSet_db2 RecordSet class that represents the dataset returned by the database.
ADORecordSet_db2oci RecordSet class that represents the dataset returned by the database.
ADORecordSet_db2oci RecordSet class that represents the dataset returned by the database.
ADORecordSet_empty Lightweight recordset when there are no records to be returned
ADORecordSet_ext_mysql RecordSet class that represents the dataset returned by the database.
ADORecordSet_ext_mysqlt RecordSet class that represents the dataset returned by the database.
ADORecordSet_ext_mysqlt RecordSet class that represents the dataset returned by the database.
ADORecordSet_ext_oci8
ADORecordSet_fbsql RecordSet class that represents the dataset returned by the database.
ADORecordSet_firebird
ADORecordset_ibase RecordSet class that represents the dataset returned by the database.
ADORecordset_informix RecordSet class that represents the dataset returned by the database.
ADORecordset_informix72 RecordSet class that represents the dataset returned by the database.
ADORecordSet_ldap RecordSet class that represents the dataset returned by the database.
ADORecordset_mssql RecordSet class that represents the dataset returned by the database.
ADORecordset_mssql_n RecordSet class that represents the dataset returned by the database.
ADORecordset_mssqlnative RecordSet class that represents the dataset returned by the database.
ADORecordset_mssqlpo RecordSet class that represents the dataset returned by the database.
ADORecordSet_mysql RecordSet class that represents the dataset returned by the database.
ADORecordSet_mysqli RecordSet class that represents the dataset returned by the database.
ADORecordSet_mysqlt RecordSet class that represents the dataset returned by the database.
ADORecordSet_mysqlt RecordSet class that represents the dataset returned by the database.
ADORecordSet_netezza RecordSet class that represents the dataset returned by the database.
ADORecordset_oci8 RecordSet class that represents the dataset returned by the database.
ADORecordset_oci805 RecordSet class that represents the dataset returned by the database.
ADORecordset_oci8po RecordSet class that represents the dataset returned by the database.
ADORecordset_oci8quercus RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbc RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbc_db2 RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbc_mssql RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbc_oracle RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbtp RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbtp_access RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbtp_mssql RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbtp_oci8 RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbtp_sybase RecordSet class that represents the dataset returned by the database.
ADORecordSet_odbtp_vfp RecordSet class that represents the dataset returned by the database.
ADORecordset_oracle RecordSet class that represents the dataset returned by the database.
ADORecordSet_pdo RecordSet class that represents the dataset returned by the database.
ADORecordSet_postgres64 RecordSet class that represents the dataset returned by the database.
ADORecordSet_postgres7 RecordSet class that represents the dataset returned by the database.
ADORecordSet_postgres8 RecordSet class that represents the dataset returned by the database.
ADORecordSet_postgres9 RecordSet class that represents the dataset returned by the database.
ADORecordset_proxy
ADORecordSet_sapdb RecordSet class that represents the dataset returned by the database.
ADORecordSet_sqlanywhere RecordSet class that represents the dataset returned by the database.
ADORecordset_sqlite RecordSet class that represents the dataset returned by the database.
ADORecordset_sqlite3 RecordSet class that represents the dataset returned by the database.
ADORecordset_sqlitepo RecordSet class that represents the dataset returned by the database.
ADORecordset_sybase RecordSet class that represents the dataset returned by the database.
adorecordset_sybase_ase RecordSet class that represents the dataset returned by the database.
ADORecordSet_text This class encapsulates the concept of a recordset created in memory as an array. This is useful for the creation of cached recordsets.
ADORecordSet_vfp RecordSet class that represents the dataset returned by the database.
adoSchema Loads and parses an XML file, creating an array of "ready-to-run" SQL statements
adoSchema Loads and parses an XML file, creating an array of "ready-to-run" SQL statements
Artist
Auth_Container_ADOdb Storage driver for fetching login data from a database using ADOdb-PHP.
Child
child
Child
City
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.
dbData Creates a data object in ADOdb's datadict format
dbData Creates a data object in ADOdb's datadict format
dbIndex Creates an index object in ADOdb's datadict format
dbIndex Creates an index object in ADOdb's datadict format
dbObject Abstract DB Object. This class provides basic methods for database objects, such as tables and indexes.
dbObject Abstract DB Object. This class provides basic methods for database objects, such as tables and indexes.
dbQuerySet Creates the SQL to execute a list of provided SQL queries
dbQuerySet Creates the SQL to execute a list of provided SQL queries
dbTable Creates a table object in ADOdb's datadict format
dbTable Creates a table object in ADOdb's datadict format
Kid
MD5Crypt
MD5Crypt
perf_db2
perf_informix
perf_mssql
perf_mssqlnative
perf_mysql
perf_oci8
perf_postgres
Person
Person
person
Rugrat
SHA1Crypt
Song

Constants

_ADODB_ACCESS

_ADODB_ACCESS

_ADODB_ADO_LAYER

_ADODB_ADO_LAYER

_ADODB_ADO_LAYER

_ADODB_ADO_LAYER

_ADODB_ADS_LAYER

_ADODB_ADS_LAYER

_ADODB_CSV_LAYER

_ADODB_CSV_LAYER

_ADODB_DB2_LAYER

_ADODB_DB2_LAYER

_ADODB_FBSQL_LAYER

_ADODB_FBSQL_LAYER

_ADODB_LAYER

_ADODB_LAYER

_ADODB_MYSQL_LAYER

_ADODB_MYSQL_LAYER

_ADODB_MYSQLI_LAYER

_ADODB_MYSQLI_LAYER

_ADODB_ODBC_LAYER

_ADODB_ODBC_LAYER

_ADODB_ODBTP_LAYER

_ADODB_ODBTP_LAYER

_ADODB_PROXY_LAYER

_ADODB_PROXY_LAYER

_ADODB_TEXT_LAYER

_ADODB_TEXT_LAYER

ADODB_ASSOC_CASE

ADODB_ASSOC_CASE

ADODB_ASSOC_CASE

ADODB_ASSOC_CASE

ADODB_ASSOC_CASE_LOWER

ADODB_ASSOC_CASE_LOWER

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_ASSOC_CASE_NATIVE

ADODB_ASSOC_CASE_NATIVE

ADODB_ASSOC_CASE_UPPER

ADODB_ASSOC_CASE_UPPER

ADODB_BAD_RS

ADODB_BAD_RS

ADODB_DATE_VERSION

ADODB_DATE_VERSION

ADODB_DB2OCI

ADODB_DB2OCI

ADODB_DB2OCI

ADODB_DB2OCI

ADODB_DIR

ADODB_DIR

ADODB_ERROR_HANDLER

ADODB_ERROR_HANDLER

ADODB_ERROR_HANDLER

ADODB_ERROR_HANDLER

ADODB_ERROR_HANDLER

ADODB_ERROR_HANDLER

ADODB_ERROR_HANDLER_TYPE

ADODB_ERROR_HANDLER_TYPE

ADODB_ERROR_HANDLER_TYPE

ADODB_ERROR_HANDLER_TYPE

ADODB_FETCH_ASSOC

ADODB_FETCH_ASSOC

ADODB_FETCH_BOTH

ADODB_FETCH_BOTH

ADODB_FETCH_DEFAULT

ADODB_FETCH_DEFAULT

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_FETCH_NUM

ADODB_FETCH_NUM

ADODB_FORCE_EMPTY

ADODB_FORCE_EMPTY

ADODB_FORCE_IGNORE

ADODB_FORCE_IGNORE

ADODB_FORCE_NULL

ADODB_FORCE_NULL

ADODB_FORCE_VALUE

ADODB_FORCE_VALUE

ADODB_JOIN_AR

ADODB_JOIN_AR

ADODB_LAZY_AR

ADODB_LAZY_AR

ADODB_NO_NEGATIVE_TS

ADODB_NO_NEGATIVE_TS

ADODB_ODBC_DB2

ADODB_ODBC_DB2

ADODB_OPT_HIGH

ADODB_OPT_HIGH

ADODB_OPT_LOW

ADODB_OPT_LOW

ADODB_PEAR

ADODB_PEAR

ADODB_PEAR_ERROR_CLASS

ADODB_PEAR_ERROR_CLASS

ADODB_PHPVER

ADODB_PHPVER

ADODB_PREFETCH_ROWS

ADODB_PREFETCH_ROWS

ADODB_REPLICATE

ADODB_REPLICATE

ADODB_SAPDB

ADODB_SAPDB

ADODB_SESSION

ADODB_SESSION

ADODB_SESSION

ADODB_SESSION

ADODB_SESSION

ADODB_SESSION

ADODB_SESSION

ADODB_SESSION

ADODB_SESSION

ADODB_SESSION

ADODB_SESSION2

ADODB_SESSION2

ADODB_SESSION_SYNCH_SECS

ADODB_SESSION_SYNCH_SECS

ADODB_SESSION_SYNCH_SECS

ADODB_SESSION_SYNCH_SECS

ADODB_SESSION_SYNCH_SECS

ADODB_SESSION_SYNCH_SECS

ADODB_SYBASE_SQLANYWHERE

ADODB_SYBASE_SQLANYWHERE

ADODB_TABLE_REGEX

ADODB_TABLE_REGEX

ADODB_TEST_DATES

ADODB_TEST_DATES

ADODB_VFP

ADODB_VFP

ADODB_WORK_AR

ADODB_WORK_AR

DB_AUTOQUERY_INSERT

DB_AUTOQUERY_INSERT

AutoExecute constants (moved from adodb-pear.inc.php since they are only used in here)

DB_AUTOQUERY_UPDATE

DB_AUTOQUERY_UPDATE

DB_ERROR

DB_ERROR

DB_ERROR

DB_ERROR

DB_ERROR_ACCESS_VIOLATION

DB_ERROR_ACCESS_VIOLATION

DB_ERROR_ALREADY_EXISTS

DB_ERROR_ALREADY_EXISTS

DB_ERROR_CANNOT_CREATE

DB_ERROR_CANNOT_CREATE

DB_ERROR_CANNOT_DELETE

DB_ERROR_CANNOT_DELETE

DB_ERROR_CANNOT_DROP

DB_ERROR_CANNOT_DROP

DB_ERROR_CONNECT_FAILED

DB_ERROR_CONNECT_FAILED

DB_ERROR_CONSTRAINT

DB_ERROR_CONSTRAINT

DB_ERROR_DEADLOCK

DB_ERROR_DEADLOCK

DB_ERROR_DIVZERO

DB_ERROR_DIVZERO

DB_ERROR_EXTENSION_NOT_FOUND

DB_ERROR_EXTENSION_NOT_FOUND

DB_ERROR_INVALID

DB_ERROR_INVALID

DB_ERROR_INVALID_DATE

DB_ERROR_INVALID_DATE

DB_ERROR_INVALID_DSN

DB_ERROR_INVALID_DSN

DB_ERROR_INVALID_NUMBER

DB_ERROR_INVALID_NUMBER

DB_ERROR_MISMATCH

DB_ERROR_MISMATCH

DB_ERROR_NEED_MORE_DATA

DB_ERROR_NEED_MORE_DATA

DB_ERROR_NODBSELECTED

DB_ERROR_NODBSELECTED

DB_ERROR_NOSUCHDB

DB_ERROR_NOSUCHDB

DB_ERROR_NOSUCHFIELD

DB_ERROR_NOSUCHFIELD

DB_ERROR_NOSUCHTABLE

DB_ERROR_NOSUCHTABLE

DB_ERROR_NOT_CAPABLE

DB_ERROR_NOT_CAPABLE

DB_ERROR_NOT_FOUND

DB_ERROR_NOT_FOUND

DB_ERROR_NOT_LOCKED

DB_ERROR_NOT_LOCKED

DB_ERROR_SERIALIZATION_FAILURE

DB_ERROR_SERIALIZATION_FAILURE

DB_ERROR_STATEMENT_TIMEOUT

DB_ERROR_STATEMENT_TIMEOUT

DB_ERROR_SYNTAX

DB_ERROR_SYNTAX

DB_ERROR_TRUNCATED

DB_ERROR_TRUNCATED

DB_ERROR_UNSUPPORTED

DB_ERROR_UNSUPPORTED

DB_ERROR_VALUE_COUNT_ON_ROW

DB_ERROR_VALUE_COUNT_ON_ROW

DB_FETCHMODE_ASSOC

DB_FETCHMODE_ASSOC

Column data indexed by column names

DB_FETCHMODE_DEFAULT

DB_FETCHMODE_DEFAULT

This is a special constant that tells DB the user hasn't specified any particular get mode, so the default should be used.

DB_FETCHMODE_ORDERED

DB_FETCHMODE_ORDERED

Column data indexed by numbers, ordered from 0 and up

DB_GETMODE_ASSOC

DB_GETMODE_ASSOC

DB_GETMODE_ORDERED

DB_GETMODE_ORDERED

DB_OK

DB_OK

DB_TABLEINFO_FULL

DB_TABLEINFO_FULL

DB_TABLEINFO_ORDER

DB_TABLEINFO_ORDER

these are constants for the tableInfo-function they are bitwised or'ed. so if there are more constants to be defined in the future, adjust DB_TABLEINFO_FULL accordingly

DB_TABLEINFO_ORDERTABLE

DB_TABLEINFO_ORDERTABLE

HORDE_BASE

HORDE_BASE

IFX_SCROLL

IFX_SCROLL

LDAP_ASSOC

LDAP_ASSOC

LDAP_BOTH

LDAP_BOTH

LDAP_NUM

LDAP_NUM

MYNUM

MYNUM

MYSQLI_BINARY_FLAG

MYSQLI_BINARY_FLAG

MYSQLI_READ_DEFAULT_GROUP

MYSQLI_READ_DEFAULT_GROUP

SINGLEQUOTE

SINGLEQUOTE

TIMESTAMP_FIRST_YEAR

TIMESTAMP_FIRST_YEAR

WEB

WEB

XMLS_CONTINUE_ON_ERROR

XMLS_CONTINUE_ON_ERROR

XMLS_CONTINUE_ON_ERROR

XMLS_CONTINUE_ON_ERROR

XMLS_DEBUG

XMLS_DEBUG

XMLS_DEBUG

XMLS_DEBUG

XMLS_DEFAULT_SCHEMA_VERSION

XMLS_DEFAULT_SCHEMA_VERSION

XMLS_DEFAULT_SCHEMA_VERSION

XMLS_DEFAULT_SCHEMA_VERSION

XMLS_DEFAULT_UPGRADE_METHOD

XMLS_DEFAULT_UPGRADE_METHOD

XMLS_DEFAULT_UPGRADE_METHOD

XMLS_DEFAULT_UPGRADE_METHOD

XMLS_EXECUTE_INLINE

XMLS_EXECUTE_INLINE

XMLS_EXECUTE_INLINE

XMLS_EXECUTE_INLINE

XMLS_EXISTING_DATA

XMLS_EXISTING_DATA

XMLS_MODE_IGNORE

XMLS_MODE_IGNORE

XMLS_MODE_INSERT

XMLS_MODE_INSERT

XMLS_MODE_UPDATE

XMLS_MODE_UPDATE

XMLS_PREFIX

XMLS_PREFIX

XMLS_PREFIX

XMLS_PREFIX

XMLS_PREFIX_MAXLEN

XMLS_PREFIX_MAXLEN

XMLS_PREFIX_MAXLEN

XMLS_PREFIX_MAXLEN

XMLS_SCHEMA_VERSION

XMLS_SCHEMA_VERSION

XMLS_SCHEMA_VERSION

XMLS_SCHEMA_VERSION

Functions

_adodb_backtrace()

_adodb_backtrace(  $printOrArr = true,   $levels = 9999,   $skippy,   $ishtml = null)

Parameters

$printOrArr
$levels
$skippy
$ishtml

_adodb_column_sql()

_adodb_column_sql(  $zthis,   $action,   $type,   $fname,   $fnameq,   $arrFields,   $magicq,   $recurse = true)

Parameters

$zthis
$action
$type
$fname
$fnameq
$arrFields
$magicq
$recurse

_adodb_column_sql_oci8()

_adodb_column_sql_oci8(  $zthis,   $action,   $type,   $fname,   $fnameq,   $arrFields,   $magicq) : string

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

$zthis
$action
$type
$fname
$fnameq
$arrFields
$magicq

Returns

string

_adodb_debug_execute()

_adodb_debug_execute(  $zthis,   $sql,   $inputarr)

Parameters

$zthis
$sql
$inputarr

_adodb_export()

_adodb_export(  $rs,   $sep,   $sepreplace,   $fp = false,   $addtitles = true,   $quote = '"',   $escquote = '"',   $replaceNewLine = ' ')

Parameters

$rs
$sep
$sepreplace
$fp
$addtitles
$quote
$escquote
$replaceNewLine

_adodb_getcount()

_adodb_getcount(  $zthis,   $sql,   $inputarr = false,   $secs2cache)

Parameters

$zthis
$sql
$inputarr
$secs2cache

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

Parameters

$origd
$fast
$is_gmt

_adodb_getdriver()

_adodb_getdriver(  $provider,   $drivername,   $perf = false)

Parameters

$provider
$drivername
$perf

_adodb_getinsertsql()

_adodb_getinsertsql(  $zthis,   $rs,   $arrFields,   $magicq = false,   $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.

Parameters

$zthis
$rs
$arrFields
$magicq
$force

_adodb_getmenu()

_adodb_getmenu(  $zthis,   $name,   $defstr = '',   $blank1stItem = true,   $multiple = false,   $size,   $selectAttr = '',   $compareFields0 = true)

Parameters

$zthis
$name
$defstr
$blank1stItem
$multiple
$size
$selectAttr
$compareFields0

_adodb_getmenu_gp()

_adodb_getmenu_gp(  $zthis,   $name,   $defstr = '',   $blank1stItem = true,   $multiple = false,   $size,   $selectAttr = '',   $compareFields0 = true)

Parameters

$zthis
$name
$defstr
$blank1stItem
$multiple
$size
$selectAttr
$compareFields0

_adodb_getupdatesql()

_adodb_getupdatesql(  $zthis,   $rs,   $arrFields,   $forceUpdate = false,   $magicq = false,   $force = 2)

Parameters

$zthis
$rs
$arrFields
$forceUpdate
$magicq
$force

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

Parameters

$year

_adodb_pageexecute_all_rows()

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

Parameters

$zthis
$sql
$nrows
$page
$inputarr
$secs2cache

_adodb_pageexecute_no_last_page()

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

Parameters

$zthis
$sql
$nrows
$page
$inputarr
$secs2cache

_adodb_replace()

_adodb_replace(  $zthis,   $table,   $fieldArray,   $keyCol,   $autoQuote,   $has_autoinc)

Parameters

$zthis
$table
$fieldArray
$keyCol
$autoQuote
$has_autoinc

_adodb_safedate()

_adodb_safedate(  $s)

Parameters

$s

_adodb_safedateq()

_adodb_safedateq(  $s)

Parameters

$s

_array_change_key_case()

_array_change_key_case(  $an_array)

Parameters

$an_array

_colonparser()

_colonparser(  $sql,   $arr)

Parameters

$sql
$arr

_colonscope()

_colonscope(  $sql,   $arr)

Parameters

$sql
$arr

_colontrack()

_colontrack(  $p)

Parameters

$p

_file_get_contents()

_file_get_contents(  $file)

Parameters

$file

_file_get_contents()

_file_get_contents(  $file)

Parameters

$file

_rs2serialize()

_rs2serialize(  $rs,   $conn = false,   $sql = '') : \the

convert a recordset into special format

Parameters

$rs
$conn
$sql

Returns

\the —

CSV formated data

adodb_addslashes()

adodb_addslashes(  $s)

Parameters

$s

adodb_backtrace()

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

Parameters

$printOrArr
$levels
$ishtml

adodb_cmp()

adodb_cmp(  $a,   $b)

Parameters

$a
$b

adodb_cmpr()

adodb_cmpr(  $a,   $b)

Parameters

$a
$b

adodb_date()

adodb_date(  $fmt,   $d = false,   $is_gmt = false)

Return formatted date based on timestamp $d

Parameters

$fmt
$d
$is_gmt

adodb_date2()

adodb_date2(  $fmt,   $d = false,   $is_gmt = false)

Parameters

$fmt
$d
$is_gmt

adodb_date_test()

adodb_date_test()

Test Suite

adodb_date_test_date()

adodb_date_test_date(  $y1,   $m,   $d = 13)

Parameters

$y1
$m
$d

adodb_date_test_strftime()

adodb_date_test_strftime(  $fmt)

Parameters

$fmt

adodb_dow()

adodb_dow(  $year,   $month,   $day)

Returns day of week, 0 = Sunday,.

.. 6=Saturday. Algorithm from PEAR::Date_Calc

Parameters

$year
$month
$day

adodb_error()

adodb_error(  $provider,   $dbType,   $errno)

Parameters

$provider
$dbType
$errno

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

adodb_error_ibase()

adodb_error_ibase()

adodb_error_ifx()

adodb_error_ifx()

adodb_error_mssql()

adodb_error_mssql()

adodb_error_mysql()

adodb_error_mysql()

adodb_error_oci8()

adodb_error_oci8()

adodb_error_odbc()

adodb_error_odbc()

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

adodb_error_pg()

adodb_error_pg(  $errormsg)

Parameters

$errormsg

adodb_error_sqlite()

adodb_error_sqlite()

adodb_errormsg()

adodb_errormsg(  $value)

Parameters

$value

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.

Parameters

$y
$m
$d

adodb_get_gmt_diff_ts()

adodb_get_gmt_diff_ts(  $ts)

Parameters

$ts

adodb_GetActiveRecordsClass()

adodb_GetActiveRecordsClass(  $db,   $class,   $tableObj,   $whereOrderBy,   $bindarr,   $primkeyArr,   $extra,   $relations)

Parameters

$db
$class
$tableObj
$whereOrderBy
$bindarr
$primkeyArr
$extra
$relations

adodb_GetActiveRecordsClass()

adodb_GetActiveRecordsClass(  $db,   $class,   $table,   $whereOrderBy,   $bindarr,   $primkeyArr,   $extra)

Parameters

$db
$class
$table
$whereOrderBy
$bindarr
$primkeyArr
$extra

adodb_getdate()

adodb_getdate(  $d = false,   $fast = false)

Returns an array with date info.

Parameters

$d
$fast

adodb_getmem()

adodb_getmem()

adodb_gmdate()

adodb_gmdate(  $fmt,   $d = false)

Parameters

$fmt
$d

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.

Parameters

$hr
$min
$sec
$mon
$day
$year
$is_dst

adodb_gmstrftime()

adodb_gmstrftime(  $fmt,   $ts = false)

Parameters

$fmt
$ts

adodb_is_leap_year()

adodb_is_leap_year(  $year)

checks for leap year, returns true if it is. Has 2-digit year check

Parameters

$year

adodb_key_exists()

adodb_key_exists(  $key,   $arr,   $force = 2)

Parameters

$key
$arr
$force

adodb_log_sql()

adodb_log_sql(  $connx,   $sql,   $inputarr)

Parameters

$connx
$sql
$inputarr

adodb_microtime()

adodb_microtime()

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

Parameters

$hr
$min
$sec
$mon
$day
$year
$is_dst
$is_gmt

adodb_pdo_type()

adodb_pdo_type(  $t)

Parameters

$t

ADODB_PEAR_Error()

ADODB_PEAR_Error()

Returns last PEAR_Error object. This error might be for an error that occured several sql statements ago.

adodb_pr()

adodb_pr(  $var,   $as_string = false)

Parameters

$var
$as_string

adodb_probetypes()

adodb_probetypes(  $array,   $types,   $probe = 8)

Parameters

$array
$types
$probe

adodb_round()

adodb_round(  $n,   $prec)

Parameters

$n
$prec

adodb_sess_close()

adodb_sess_close()

adodb_sess_close()

adodb_sess_close()

adodb_sess_close()

adodb_sess_close()

adodb_sess_destroy()

adodb_sess_destroy(  $key)

Parameters

$key

adodb_sess_destroy()

adodb_sess_destroy(  $key)

Parameters

$key

adodb_sess_destroy()

adodb_sess_destroy(  $key)

Parameters

$key

adodb_sess_gc()

adodb_sess_gc(  $maxlifetime)

Parameters

$maxlifetime

adodb_sess_gc()

adodb_sess_gc(  $maxlifetime)

Parameters

$maxlifetime

adodb_sess_gc()

adodb_sess_gc(  $maxlifetime)

Parameters

$maxlifetime

adodb_sess_gc()

adodb_sess_gc(  $t)

Parameters

$t

adodb_sess_gc()

adodb_sess_gc(  $t)

Parameters

$t

adodb_sess_open()

adodb_sess_open(  $save_path,   $session_name,   $persist = true)

Parameters

$save_path
$session_name
$persist

adodb_sess_open()

adodb_sess_open(  $save_path,   $session_name,   $persist = true)

Parameters

$save_path
$session_name
$persist

adodb_sess_open()

adodb_sess_open(  $save_path,   $session_name)

Parameters

$save_path
$session_name

adodb_sess_open()

adodb_sess_open(  $save_path,   $session_name,   $persist = true)

Parameters

$save_path
$session_name
$persist

adodb_sess_open()

adodb_sess_open(  $save_path,   $session_name,   $persist = true)

Parameters

$save_path
$session_name
$persist

adodb_sess_read()

adodb_sess_read(  $key)

Parameters

$key

adodb_sess_read()

adodb_sess_read(  $key)

Parameters

$key

adodb_sess_read()

adodb_sess_read(  $key)

Parameters

$key

adodb_sess_write()

adodb_sess_write(  $key,   $val)

Parameters

$key
$val

adodb_sess_write()

adodb_sess_write(  $key,   $val)

Parameters

$key
$val

adodb_sess_write()

adodb_sess_write(  $key,   $val)

Parameters

$key
$val

adodb_session_create_table()

adodb_session_create_table(  $schemaFile = null,   $conn = null)

Parameters

$schemaFile
$conn

adodb_session_create_table()

adodb_session_create_table(  $schemaFile = null,   $conn = null)

Parameters

$schemaFile
$conn

ADODB_Session_Key()

ADODB_Session_Key()

adodb_session_regenerate_id()

adodb_session_regenerate_id()

adodb_session_regenerate_id()

adodb_session_regenerate_id()

adodb_session_regenerate_id()

adodb_session_regenerate_id()

ADODB_SetDatabaseAdapter()

ADODB_SetDatabaseAdapter(  $db)

Parameters

$db

ADODB_SetDatabaseAdapter()

ADODB_SetDatabaseAdapter(  $db,   $index = false)

Parameters

$db
$index

ADODB_Setup()

ADODB_Setup()

ADODB_str_replace()

ADODB_str_replace(  $src,   $dest,   $data)

Accepts $src and $dest arrays, replacing string $data

Parameters

$src
$dest
$data

adodb_strftime()

adodb_strftime(  $fmt,   $ts = false,   $is_gmt = false)

Parameters

$fmt
$ts
$is_gmt

adodb_strip_order_by()

adodb_strip_order_by(  $sql)

Parameters

$sql

adodb_test_err()

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

Parameters

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

adodb_throw()

adodb_throw(  $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
$thisConnection

adodb_time()

adodb_time()

ADODB_TransMonitor()

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

Parameters

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

adodb_transpose()

adodb_transpose(  $arr,   $newarr,   $hdr,   $fobjs)

Parameters

$arr
$newarr
$hdr
$fobjs

adodb_tz_offset()

adodb_tz_offset(  $gmt,   $isphp5)

Parameters

$gmt
$isphp5

adodb_unserialize()

adodb_unserialize(  $serialized_string)

Parameters

$serialized_string

adodb_unserialize()

adodb_unserialize(  $serialized_string)

Parameters

$serialized_string

adodb_validdate()

adodb_validdate(  $y,   $m,   $d)

Parameters

$y
$m
$d

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)

Parameters

$filename
$contents
$debug

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.

Parameters

$y

ADOLoadCode()

ADOLoadCode(  $dbType)

Load the code for a specific database driver. Private function. Do not use.

Parameters

$dbType

ADOLoadCode2()

ADOLoadCode2(  $d)

Parameters

$d

ADOLoadDB()

ADOLoadDB(  $dbType)

Synonym for ADOLoadCode. Private function. Do not use.

Parameters

$dbType

ADONewConnection()

ADONewConnection(  $db = '') : \the

Instantiate a new Connection class for a specific database driver.

Parameters

$db

Returns

\the —

freshly created instance of the Connection class.

ar_assert()

ar_assert(  $bool)

Parameters

$bool

ar_echo()

ar_echo(  $txt)

Parameters

$txt

arr2html()

arr2html(  $arr,   $ztabhtml = '',   $zheaderarray = '')

Parameters

$arr
$ztabhtml
$zheaderarray

AutoDetect_MSSQL_Date_Order()

AutoDetect_MSSQL_Date_Order(  $conn)

Parameters

$conn

CheckWS()

CheckWS(  $conn)

Parameters

$conn

CopyData()

CopyData(  $rep,   $table,   $pkey)

Parameters

$rep
$table
$pkey

CountCachedExecs()

CountCachedExecs(  $db,   $secs2cache,   $sql,   $inputarray)

Parameters

$db
$secs2cache
$sql
$inputarray

CountExecs()

CountExecs(  $db,   $sql,   $inputarray)

Parameters

$db
$sql
$inputarray

CreateTable()

CreateTable(  $rep,   $table)

Parameters

$rep
$table

csv2rs()

csv2rs(  $url,   $err,   $timeout,   $rsclass = 'ADORecordSet_array') : \recordset,

Open CSV file and convert it into Data.

Parameters

$url
$err
$timeout
$rsclass

Returns

\recordset, —

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

ctype_alnum()

ctype_alnum(  $text)

Parameters

$text

do_strtolower()

do_strtolower(  $arr)

Parameters

$arr

doloop()

doloop()

dump()

dump(  $var,   $str,   $vardump = false)

Parameters

$var
$str
$vardump

err()

err(  $s)

Parameters

$s

Err()

Err(  $msg)

Parameters

$msg

FieldFilter()

FieldFilter(  $fld,   $mode)

Parameters

$fld
$mode

found()

found(  $obj,   $cond)

Parameters

$obj
$cond

getmicrotime()

getmicrotime()

getmicrotime()

getmicrotime()

ifx_props()

ifx_props(  $coltype,   $collength)

!Eos Auxiliar function to Parse coltype,collength. Used by Metacolumns return: array ($mtype,$length,$precision,$nullable) (similar to ifx_fieldpropierties)

Parameters

$coltype
$collength

IndexFilter()

IndexFilter(  $dtable,   $idxname,   $flds,   $options)

Parameters

$dtable
$idxname
$flds
$options

Lens_ParseArgs()

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

$args
$endstmtchar
$tokenchars

Lens_ParseTest()

Lens_ParseTest()

loginFunction()

loginFunction()

logMsg()

logMsg(  $msg,   $title = NULL,   $force = FALSE)

Message logging function

Parameters

$msg
$title
$force

logMsg()

logMsg(  $msg,   $title = NULL,   $force = FALSE)

Message logging function

Parameters

$msg
$title
$force

MergeDataJohnTest()

MergeDataJohnTest(  $rep,   $table,   $pkey)

Parameters

$rep
$table
$pkey

NewADOConnection()

NewADOConnection(  $db = '')

synonym for ADONewConnection for people like me who cannot remember the correct name

Parameters

$db

NewDataDictionary()

NewDataDictionary(  $conn,   $drivername = false)

Parameters

$conn
$drivername

NewPerfMonitor()

NewPerfMonitor(  $conn)

Parameters

$conn

notfound()

notfound(  $obj,   $cond)

Parameters

$obj
$cond

NotifyExpire()

NotifyExpire(  $ref,   $key)

Parameters

$ref
$key

oci_lob_desc()

oci_lob_desc(  $type)

Parameters

$type

ParseTable()

ParseTable(  $table,   $pkey)

Parameters

$table
$pkey

PivotTableSQL()

PivotTableSQL(  $db,   $tables,   $rowfields,   $colfield,   $where = false,   $aggfield = false,   $sumlabel = 'Sum ',   $aggfn = 'SUM',   $showcount = true)

Parameters

$db
$tables
$rowfields
$colfield
$where
$aggfield
$sumlabel
$aggfn
$showcount

print_pre()

print_pre(  $s)

Parameters

$s

printsqla()

printsqla(  $dbType,   $sqla)

Parameters

$dbType
$sqla

rs2csv()

rs2csv(  $rs,   $addtitles = true)

Parameters

$rs
$addtitles

rs2csvfile()

rs2csvfile(  $rs,   $fp,   $addtitles = true)

Parameters

$rs
$fp
$addtitles

rs2csvout()

rs2csvout(  $rs,   $addtitles = true)

Parameters

$rs
$addtitles

rs2html()

rs2html(  $rs,   $ztabhtml = false,   $zheaderarray = false,   $htmlspecialchars = true,   $echo = true)

Parameters

$rs
$ztabhtml
$zheaderarray
$htmlspecialchars
$echo

rs2tab()

rs2tab(  $rs,   $addtitles = true)

Parameters

$rs
$addtitles

rs2tabfile()

rs2tabfile(  $rs,   $fp,   $addtitles = true)

Parameters

$rs
$fp
$addtitles

rs2tabout()

rs2tabout(  $rs,   $addtitles = true)

Parameters

$rs
$addtitles

rs2xmlrpcstring()

rs2xmlrpcstring(  $adodbrs)

Returns an xmlrpc struct value as string out of an AdoDB recordset

Parameters

$adodbrs

rs2xmlrpcval()

rs2xmlrpcval(  $adodbrs)

Builds an xmlrpc struct value out of an AdoDB recordset

Parameters

$adodbrs

rs2xmlrpcval_body()

rs2xmlrpcval_body(  $adodbrs)

Builds an xmlrpc struct value out of an AdoDB recordset (data values only, no data definition)

Parameters

$adodbrs

rs2xmlrpcval_header()

rs2xmlrpcval_header(  $adodbrs)

Builds an xmlrpc struct value describing an AdoDB recordset

Parameters

$adodbrs

RSFilter()

RSFilter(  $rs,   $fn)

Parameters

$rs
$fn

SelFilter()

SelFilter(  $table,   $arr,   $delfirst)

Parameters

$table
$arr
$delfirst

send2server()

send2server(  $url,   $sql)

Parameters

$url
$sql

showDbg()

showDbg(  $string)

Parameters

$string

sqlsrv_log_set_severity()

sqlsrv_log_set_severity(  $constant)

Parameters

$constant

sqlsrv_log_set_subsystems()

sqlsrv_log_set_subsystems(  $constant)

Parameters

$constant

sqlsrv_set_error_handling()

sqlsrv_set_error_handling(  $constant)

Parameters

$constant

TableStats()

TableStats(  $rep,   $table,   $pkey)

Parameters

$rep
$table
$pkey

tadodb()

tadodb()

testdb()

testdb(  $db,   $createtab = "create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)")

Parameters

$db
$createtab

testdb()

testdb(  $db,   $createtab = "create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)")

Parameters

$db
$createtab

testdb()

testdb(  $db)

Parameters

$db

testdb()

testdb(  $db,   $createtab = "create table ADOXYZ (id int, firstname char(24), lastname char(24), created date)")

Parameters

$db
$createtab

testsql()

testsql()

tmssql()

tmssql()

tpear()

tpear()

undomq()

undomq(  $m)

Parameters

$m

updatefilter()

updatefilter(  $table,   $fld,   $val)

Parameters

$table
$fld
$val

xmlrpcval2rs()

xmlrpcval2rs(  $xmlrpcval)

Given a well-formed xmlrpc struct object returns an AdoDB object

Parameters

$xmlrpcval