MDB2.php File Reference

Go to the source code of this file.

Data Structures
class	MDB2
class	MDB2_Error
class	MDB2_Driver_Common
class	MDB2_Result
class	MDB2_Result_Common
class	MDB2_Row
class	MDB2_Statement_Common
class	MDB2_Module_Common

Namespaces
	MDB2
	Several methods to convert the MDB2 native timestamp format (ISO based) to and from data structures that are convenient to worth with in side of php.

Functions
	MDB2_closeOpenTransactions ()
	Close any open transactions form persistent connections. More...
	MDB2_defaultDebugOutput (&$db, $scope, $message, $context=array())
	default debug output handler More...

Variables
const	MDB2_OK (!class_exists('PEAR')) true
	The method mapErrorCode in each MDB2_dbtype implementation maps native error codes to one of these. More...
const	MDB2_ERROR -1
const	MDB2_ERROR_SYNTAX -2
const	MDB2_ERROR_CONSTRAINT -3
const	MDB2_ERROR_NOT_FOUND -4
const	MDB2_ERROR_ALREADY_EXISTS -5
const	MDB2_ERROR_UNSUPPORTED -6
const	MDB2_ERROR_MISMATCH -7
const	MDB2_ERROR_INVALID -8
const	MDB2_ERROR_NOT_CAPABLE -9
const	MDB2_ERROR_TRUNCATED -10
const	MDB2_ERROR_INVALID_NUMBER -11
const	MDB2_ERROR_INVALID_DATE -12
const	MDB2_ERROR_DIVZERO -13
const	MDB2_ERROR_NODBSELECTED -14
const	MDB2_ERROR_CANNOT_CREATE -15
const	MDB2_ERROR_CANNOT_DELETE -16
const	MDB2_ERROR_CANNOT_DROP -17
const	MDB2_ERROR_NOSUCHTABLE -18
const	MDB2_ERROR_NOSUCHFIELD -19
const	MDB2_ERROR_NEED_MORE_DATA -20
const	MDB2_ERROR_NOT_LOCKED -21
const	MDB2_ERROR_VALUE_COUNT_ON_ROW -22
const	MDB2_ERROR_INVALID_DSN -23
const	MDB2_ERROR_CONNECT_FAILED -24
const	MDB2_ERROR_EXTENSION_NOT_FOUND -25
const	MDB2_ERROR_NOSUCHDB -26
const	MDB2_ERROR_ACCESS_VIOLATION -27
const	MDB2_ERROR_CANNOT_REPLACE -28
const	MDB2_ERROR_CONSTRAINT_NOT_NULL -29
const	MDB2_ERROR_DEADLOCK -30
const	MDB2_ERROR_CANNOT_ALTER -31
const	MDB2_ERROR_MANAGER -32
const	MDB2_ERROR_MANAGER_PARSE -33
const	MDB2_ERROR_LOADMODULE -34
const	MDB2_ERROR_INSUFFICIENT_DATA -35
const	MDB2_PREPARE_MANIP false
	These are just helper constants to more verbosely express parameters to prepare() More...
const	MDB2_PREPARE_RESULT null
const	MDB2_FETCHMODE_DEFAULT 0
	This is a special constant that tells MDB2 the user hasn't specified any particular get mode, so the default should be used. More...
const	MDB2_FETCHMODE_ORDERED 1
	Column data indexed by numbers, ordered from 0 and up. More...
const	MDB2_FETCHMODE_ASSOC 2
	Column data indexed by column names. More...
const	MDB2_FETCHMODE_OBJECT 3
	Column data as object properties. More...
const	MDB2_FETCHMODE_FLIPPED 4
	For multi-dimensional results: normally the first level of arrays is the row number, and the second level indexed by column number or name. More...
const	MDB2_PORTABILITY_NONE 0
	Portability: turn off all portability features. More...
const	MDB2_PORTABILITY_FIX_CASE 1
	Portability: convert names of tables and fields to case defined in the "field_case" option when using the query*(), fetch*() and tableInfo() methods. More...
const	MDB2_PORTABILITY_RTRIM 2
	Portability: right trim the data output by query*() and fetch*(). More...
const	MDB2_PORTABILITY_DELETE_COUNT 4
	Portability: force reporting the number of rows deleted. More...
const	MDB2_PORTABILITY_NUMROWS 8
	Portability: not needed in MDB2 (just left here for compatibility to DB) More...
const	MDB2_PORTABILITY_ERRORS 16
	Portability: makes certain error messages in certain drivers compatible with those from other DBMS's. More...
const	MDB2_PORTABILITY_EMPTY_TO_NULL 32
	Portability: convert empty values to null strings in data output by query*() and fetch*(). More...
const	MDB2_PORTABILITY_FIX_ASSOC_FIELD_NAMES 64
	Portability: removes database/table qualifiers from associative indexes. More...
const	MDB2_PORTABILITY_ALL 127
	Portability: turn on all portability features. More...
	$GLOBALS ['_MDB2_databases'] = array()
	These are global variables that are used to track the various class instances. More...
	$GLOBALS ['_MDB2_dsninfo_default']

Function Documentation

MDB2_closeOpenTransactions()

MDB2_closeOpenTransactions

(

)

Close any open transactions form persistent connections.

Returns

void

public

Definition at line 4263 of file MDB2.php.

References $GLOBALS.

{
    reset($GLOBALS['_MDB2_databases']);
    while (next($GLOBALS['_MDB2_databases'])) {
        $key = key($GLOBALS['_MDB2_databases']);
        if ($GLOBALS['_MDB2_databases'][$key]->opened_persistent
            && $GLOBALS['_MDB2_databases'][$key]->in_transaction
        ) {
            $GLOBALS['_MDB2_databases'][$key]->rollback();
        }
    }
}

MDB2_defaultDebugOutput()

MDB2_defaultDebugOutput	(	&	$db,
			$scope,
			$message,
			$context = array()
	)

default debug output handler

Parameters

object	reference to an MDB2 database object
string	usually the method name that triggered the debug call: for example 'query', 'prepare', 'execute', 'parameters', 'beginTransaction', 'commit', 'rollback'
string	message that should be appended to the debug variable
array	contains context information about the debug() call common keys are: is_manip, time, result etc.

Returns

void|string optionally return a modified message, this allows rewriting a query before being issued or prepared

public

Definition at line 4295 of file MDB2.php.

{
    $db->debug_output.= $scope.'('.$db->db_index.'): ';
    $db->debug_output.= $message.$db->getOption('log_line_break');
    return $message;
}

Variable Documentation

$GLOBALS [1/2]

$GLOBALS[ '_MDB2_databases'] = array()

These are global variables that are used to track the various class instances.

Definition at line 224 of file MDB2.php.

Referenced by MDB2_Driver_Common\__construct(), MDB2_Driver_Common\free(), MDB2_Module_Common\getDBInstance(), MDB2_Driver_Common\getDSN(), MDB2_closeOpenTransactions(), MDB2\parseDSN(), MDB2_Driver_Common\setDSN(), and MDB2\singleton().

$GLOBALS [2/2]

$GLOBALS[ '_MDB2_dsninfo_default']

Initial value:

= array(
    'phptype'  => false,
    'dbsyntax' => false,
    'username' => false,
    'password' => false,
    'protocol' => false,
    'hostspec' => false,
    'port'     => false,
    'socket'   => false,
    'database' => false,
    'mode'     => false,
)

Definition at line 225 of file MDB2.php.

MDB2_ERROR

const MDB2_ERROR -1

Definition at line 73 of file MDB2.php.

Referenced by MDB2_Error\__construct(), MDB2_Driver_pgsql\errorInfo(), MDB2\errorMessage(), MDB2_Statement_Common\execute(), MDB2_Statement_pgsql\free(), MDB2_Statement_mysql\free(), MDB2_Statement_oci8\free(), MDB2_Statement_mysqli\free(), MDB2_Statement_Common\free(), and MDB2_Driver_Datatype_Common\writeLOBToFile().

MDB2_ERROR_ACCESS_VIOLATION

const MDB2_ERROR_ACCESS_VIOLATION -27

Definition at line 99 of file MDB2.php.

Referenced by MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_ALREADY_EXISTS

const MDB2_ERROR_ALREADY_EXISTS -5

Definition at line 77 of file MDB2.php.

Referenced by MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_CANNOT_ALTER

const MDB2_ERROR_CANNOT_ALTER -31

Definition at line 103 of file MDB2.php.

Referenced by MDB2_Driver_Manager_pgsql\alterTable(), MDB2_Driver_Manager_mysql\alterTable(), MDB2_Driver_Manager_mysqli\alterTable(), and MDB2\errorMessage().

MDB2_ERROR_CANNOT_CREATE

const MDB2_ERROR_CANNOT_CREATE -15

Definition at line 87 of file MDB2.php.

Referenced by MDB2_Driver_Manager_Common\_getCreateTableQuery(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_CANNOT_DELETE

const MDB2_ERROR_CANNOT_DELETE -16

Definition at line 88 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_CANNOT_DROP

const MDB2_ERROR_CANNOT_DROP -17

Definition at line 89 of file MDB2.php.

Referenced by MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_CANNOT_REPLACE

const MDB2_ERROR_CANNOT_REPLACE -28

Definition at line 100 of file MDB2.php.

Referenced by MDB2\errorMessage(), MDB2_Driver_mysql\replace(), MDB2_Driver_mysqli\replace(), and MDB2_Driver_Common\replace().

MDB2_ERROR_CONNECT_FAILED

const MDB2_ERROR_CONNECT_FAILED -24

Definition at line 96 of file MDB2.php.

Referenced by MDB2_Driver_oci8\_doConnect(), MDB2_Driver_pgsql\_doConnect(), MDB2_Driver_mysqli\connect(), MDB2_Driver_mysql\connect(), MDB2_Driver_pgsql\errorInfo(), MDB2\errorMessage(), and MDB2_Driver_pgsql\standaloneQuery().

MDB2_ERROR_CONSTRAINT

const MDB2_ERROR_CONSTRAINT -3

Definition at line 75 of file MDB2.php.

Referenced by MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), MDB2\errorMessage(), and ilADTBasedObject\translateDBErrorCodes().

MDB2_ERROR_CONSTRAINT_NOT_NULL

const MDB2_ERROR_CONSTRAINT_NOT_NULL -29

Definition at line 101 of file MDB2.php.

Referenced by MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_DEADLOCK

const MDB2_ERROR_DEADLOCK -30

Definition at line 102 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_DIVZERO

const MDB2_ERROR_DIVZERO -13

Definition at line 85 of file MDB2.php.

Referenced by MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_EXTENSION_NOT_FOUND

const MDB2_ERROR_EXTENSION_NOT_FOUND -25

Definition at line 97 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_INSUFFICIENT_DATA

const MDB2_ERROR_INSUFFICIENT_DATA -35

Definition at line 107 of file MDB2.php.

MDB2_ERROR_INVALID

const MDB2_ERROR_INVALID -8

Definition at line 80 of file MDB2.php.

Referenced by MDB2_Driver_Datatype_Common\_baseConvertResult(), MDB2_Driver_oci8\beginTransaction(), MDB2_Driver_mysql\beginTransaction(), MDB2_Driver_mysqli\beginTransaction(), MDB2_Driver_pgsql\beginTransaction(), MDB2_Driver_oci8\commit(), MDB2_Driver_mysqli\commit(), MDB2_Driver_mysql\commit(), MDB2_Driver_pgsql\commit(), MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2\errorMessage(), MDB2_Driver_oci8\getServerVersion(), MDB2_Driver_oci8\rollback(), MDB2_Driver_pgsql\rollback(), MDB2_Driver_mysqli\rollback(), MDB2_Driver_mysql\rollback(), MDB2_BufferedResult_pgsql\seek(), MDB2_BufferedResult_mysql\seek(), and MDB2_BufferedResult_mysqli\seek().

MDB2_ERROR_INVALID_DATE

const MDB2_ERROR_INVALID_DATE -12

Definition at line 84 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_INVALID_DSN

const MDB2_ERROR_INVALID_DSN -23

Definition at line 95 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_INVALID_NUMBER

const MDB2_ERROR_INVALID_NUMBER -11

Definition at line 83 of file MDB2.php.

Referenced by MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_LOADMODULE

const MDB2_ERROR_LOADMODULE -34

Definition at line 106 of file MDB2.php.

Referenced by MDB2\errorMessage(), and MDB2_Driver_Common\loadModule().

MDB2_ERROR_MANAGER

const MDB2_ERROR_MANAGER -32

Definition at line 104 of file MDB2.php.

MDB2_ERROR_MANAGER_PARSE

const MDB2_ERROR_MANAGER_PARSE -33

Definition at line 105 of file MDB2.php.

MDB2_ERROR_MISMATCH

const MDB2_ERROR_MISMATCH -7

Definition at line 79 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_NEED_MORE_DATA

const MDB2_ERROR_NEED_MORE_DATA -20

Definition at line 92 of file MDB2.php.

Referenced by MDB2_Extended\buildManipSQL(), MDB2_Driver_Manager_mysql\createConstraint(), MDB2_Driver_Manager_mysqli\createConstraint(), MDB2\errorMessage(), MDB2_Result_oci8\fetchRow(), MDB2_Result_pgsql\fetchRow(), MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_BufferedResult_oci8\fetchRow(), MDB2_Driver_Manager_Common\getFieldDeclarationList(), MDB2_Result_oci8\numCols(), MDB2_Result_pgsql\numCols(), MDB2_Result_mysql\numCols(), MDB2_Result_mysqli\numCols(), MDB2_BufferedResult_pgsql\numRows(), MDB2_BufferedResult_oci8\numRows(), MDB2_BufferedResult_mysql\numRows(), MDB2_BufferedResult_mysqli\numRows(), MDB2_BufferedResult_pgsql\seek(), MDB2_BufferedResult_oci8\seek(), MDB2_BufferedResult_mysql\seek(), MDB2_BufferedResult_mysqli\seek(), ilDBPdoReversePostgres\tableInfo(), MDB2_Driver_Reverse_mysql\tableInfo(), MDB2_Driver_Reverse_pgsql\tableInfo(), MDB2_Driver_Reverse_mysqli\tableInfo(), MDB2_Driver_Reverse_oci8\tableInfo(), and MDB2_BufferedResult_oci8\valid().

MDB2_ERROR_NODBSELECTED

const MDB2_ERROR_NODBSELECTED -14

Definition at line 86 of file MDB2.php.

Referenced by MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_NOSUCHDB

const MDB2_ERROR_NOSUCHDB -26

Definition at line 98 of file MDB2.php.

Referenced by MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_NOSUCHFIELD

const MDB2_ERROR_NOSUCHFIELD -19

Definition at line 91 of file MDB2.php.

Referenced by MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_NOSUCHTABLE

const MDB2_ERROR_NOSUCHTABLE -18

Definition at line 90 of file MDB2.php.

Referenced by MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), MDB2\errorMessage(), MDB2_Driver_oci8\nextID(), MDB2_Driver_pgsql\nextID(), MDB2_Driver_mysql\nextID(), and MDB2_Driver_mysqli\nextID().

MDB2_ERROR_NOT_CAPABLE

const MDB2_ERROR_NOT_CAPABLE -9

Definition at line 81 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_NOT_FOUND

const MDB2_ERROR_NOT_FOUND -4

Definition at line 76 of file MDB2.php.

Referenced by MDB2_Driver_oci8\_doConnect(), MDB2_Statement_pgsql\_execute(), MDB2_Statement_oci8\_execute(), MDB2_Statement_mysql\_execute(), MDB2_Statement_mysqli\_execute(), MDB2_Statement_Common\_execute(), MDB2_Driver_Datatype_oci8\_readLOB(), MDB2_Driver_Datatype_oci8\_retrieveLOB(), MDB2_Driver_Common\_wrapResult(), MDB2_Statement_Common\bindParam(), MDB2_Statement_Common\bindValue(), MDB2_Driver_mysqli\connect(), MDB2_Driver_mysql\connect(), MDB2_Driver_pgsql\connect(), MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), MDB2\errorMessage(), MDB2\factory(), MDB2_Module_Common\getDBInstance(), MDB2_Driver_Datatype_Common\getDeclaration(), MDB2_Driver_Reverse_mysql\getTableConstraintDefinition(), MDB2_Driver_Reverse_pgsql\getTableConstraintDefinition(), MDB2_Driver_Reverse_oci8\getTableConstraintDefinition(), MDB2_Driver_Reverse_mysqli\getTableConstraintDefinition(), MDB2_Driver_Reverse_pgsql\getTableFieldDefinition(), MDB2_Driver_Reverse_oci8\getTableFieldDefinition(), MDB2_Driver_Reverse_mysql\getTableFieldDefinition(), MDB2_Driver_Reverse_mysqli\getTableFieldDefinition(), MDB2_Driver_Reverse_mysql\getTableIndexDefinition(), MDB2_Driver_Reverse_oci8\getTableIndexDefinition(), MDB2_Driver_Reverse_pgsql\getTableIndexDefinition(), MDB2_Driver_Reverse_mysqli\getTableIndexDefinition(), MDB2\loadClass(), MDB2\loadFile(), and MDB2_Driver_Common\raiseError().

MDB2_ERROR_NOT_LOCKED

const MDB2_ERROR_NOT_LOCKED -21

Definition at line 93 of file MDB2.php.

Referenced by MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_ERROR_SYNTAX

const MDB2_ERROR_SYNTAX -2

Definition at line 74 of file MDB2.php.

Referenced by MDB2_Driver_Common\_skipDelimitedStrings(), MDB2_Extended\buildManipSQL(), MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), MDB2\errorMessage(), MDB2_Driver_oci8\prepare(), MDB2_Driver_pgsql\prepare(), MDB2_Driver_mysql\prepare(), MDB2_Driver_mysqli\prepare(), MDB2_Driver_Common\prepare(), and MDB2_Driver_Common\setLimit().

MDB2_ERROR_TRUNCATED

const MDB2_ERROR_TRUNCATED -10

Definition at line 82 of file MDB2.php.

Referenced by MDB2\errorMessage(), MDB2_Result_Common\fetchAll(), MDB2_Result_Common\fetchCol(), and MDB2_Result_Common\fetchOne().

MDB2_ERROR_UNSUPPORTED

const MDB2_ERROR_UNSUPPORTED -6

Definition at line 78 of file MDB2.php.

Referenced by MDB2_Driver_Common\_affectedRows(), MDB2_Driver_Common\_doQuery(), MDB2_Result_Common\_getColumnNames(), MDB2_Driver_Datatype_mysql\_mapNativeDatatype(), MDB2_Driver_Datatype_mysqli\_mapNativeDatatype(), MDB2_Driver_Datatype_oci8\_mapNativeDatatype(), MDB2_Driver_Datatype_pgsql\_mapNativeDatatype(), MDB2_Driver_Datatype_Common\_mapNativeDatatype(), MDB2_Driver_Manager_Common\alterTable(), MDB2_Driver_mysql\beginTransaction(), MDB2_Driver_mysqli\beginTransaction(), MDB2_Driver_Common\beginTransaction(), MDB2_Driver_Datatype_Common\checkResultTypes(), MDB2_Driver_mysqli\commit(), MDB2_Driver_mysql\commit(), MDB2_Driver_Common\commit(), MDB2_Driver_Datatype_Common\compareDefinition(), MDB2_Driver_Common\connect(), MDB2_Driver_Manager_oci8\createDatabase(), MDB2_Driver_Manager_Common\createDatabase(), MDB2_Driver_Manager_Common\createSequence(), MDB2_Driver_Manager_oci8\dropDatabase(), MDB2_Driver_Manager_Common\dropDatabase(), MDB2_Driver_Manager_Common\dropSequence(), MDB2\errorMessage(), MDB2_Driver_Function_Common\executeStoredProc(), MDB2_Result_Common\fetchRow(), MDB2_Driver_Common\getOption(), MDB2_Driver_Common\getServerVersion(), MDB2_Driver_Reverse_Common\getTableConstraintDefinition(), MDB2_Driver_Reverse_Common\getTableFieldDefinition(), MDB2_Driver_Reverse_Common\getTableIndexDefinition(), MDB2_Driver_Reverse_Common\getTriggerDefinition(), MDB2_Driver_Function_Common\guid(), MDB2_Driver_Common\lastInsertID(), MDB2_Driver_Manager_Common\listDatabases(), MDB2_Driver_Manager_Common\listFunctions(), MDB2_Driver_Manager_Common\listSequences(), MDB2_Driver_Manager_Common\listTableConstraints(), MDB2_Driver_Manager_Common\listTableFields(), MDB2_Driver_Manager_Common\listTableIndexes(), MDB2_Driver_Manager_Common\listTables(), MDB2_Driver_Manager_Common\listTableTriggers(), MDB2_Driver_Manager_Common\listTableViews(), MDB2_Driver_Manager_Common\listUsers(), MDB2_Driver_Manager_Common\listViews(), MDB2_Driver_Datatype_mysql\matchPattern(), MDB2_Driver_Datatype_mysqli\matchPattern(), MDB2_Driver_Datatype_pgsql\matchPattern(), MDB2_Driver_Datatype_Common\matchPattern(), MDB2_Driver_Common\nextID(), MDB2_Result_Common\nextResult(), MDB2_Result_Common\numCols(), MDB2_Result_Common\numRows(), MDB2_Driver_Datatype_Common\quote(), MDB2_Driver_Common\replace(), MDB2_Driver_mysqli\rollback(), MDB2_Driver_mysql\rollback(), MDB2_Driver_Common\rollback(), MDB2_Result_Common\seek(), MDB2_Driver_Common\setCharset(), MDB2_Driver_Common\setFetchMode(), MDB2_Driver_Common\setLimit(), MDB2_Driver_Common\setOption(), MDB2_Driver_oci8\setTransactionIsolation(), MDB2_Driver_pgsql\setTransactionIsolation(), MDB2_Driver_mysqli\setTransactionIsolation(), MDB2_Driver_mysql\setTransactionIsolation(), MDB2_Driver_Common\setTransactionIsolation(), MDB2_Driver_Common\subSelect(), MDB2_Driver_Common\supports(), and MDB2_Driver_Reverse_Common\tableInfo().

MDB2_ERROR_VALUE_COUNT_ON_ROW

const MDB2_ERROR_VALUE_COUNT_ON_ROW -22

Definition at line 94 of file MDB2.php.

Referenced by MDB2_Driver_pgsql\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), and MDB2\errorMessage().

MDB2_FETCHMODE_ASSOC

const MDB2_FETCHMODE_ASSOC 2

Column data indexed by column names.

Definition at line 134 of file MDB2.php.

Referenced by MDB2_Result_Common\fetchAll(), MDB2_Result_Common\fetchCol(), MDB2_Result_Common\fetchOne(), MDB2_Result_oci8\fetchRow(), MDB2_Result_pgsql\fetchRow(), MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_BufferedResult_oci8\fetchRow(), MDB2_Driver_Reverse_mysql\getTableConstraintDefinition(), MDB2_Driver_Reverse_pgsql\getTableConstraintDefinition(), MDB2_Driver_Reverse_oci8\getTableConstraintDefinition(), MDB2_Driver_Reverse_mysqli\getTableConstraintDefinition(), MDB2_Driver_Reverse_oci8\getTableFieldDefinition(), MDB2_Driver_Reverse_pgsql\getTableFieldDefinition(), MDB2_Driver_Reverse_mysql\getTableFieldDefinition(), MDB2_Driver_Reverse_mysqli\getTableFieldDefinition(), MDB2_Driver_Reverse_mysql\getTableIndexDefinition(), MDB2_Driver_Reverse_oci8\getTableIndexDefinition(), MDB2_Driver_Reverse_pgsql\getTableIndexDefinition(), MDB2_Driver_Reverse_mysqli\getTableIndexDefinition(), ilDBPdoReversePostgres\getTriggerDefinition(), MDB2_Driver_Reverse_pgsql\getTriggerDefinition(), MDB2_Driver_Reverse_mysql\getTriggerDefinition(), MDB2_Driver_Reverse_mysqli\getTriggerDefinition(), MDB2_Driver_Reverse_oci8\getTriggerDefinition(), MDB2_Driver_Manager_mysql\listTableConstraints(), MDB2_Driver_Manager_mysqli\listTableConstraints(), MDB2_Driver_Manager_mysql\listTableIndexes(), MDB2_Driver_Manager_mysqli\listTableIndexes(), and MDB2_Driver_Common\setFetchMode().

MDB2_FETCHMODE_DEFAULT

const MDB2_FETCHMODE_DEFAULT 0

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

Definition at line 124 of file MDB2.php.

Referenced by MDB2_Result_oci8\fetchRow(), MDB2_Result_pgsql\fetchRow(), MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), and MDB2_BufferedResult_oci8\fetchRow().

MDB2_FETCHMODE_FLIPPED

const MDB2_FETCHMODE_FLIPPED 4

For multi-dimensional results: normally the first level of arrays is the row number, and the second level indexed by column number or name.

MDB2_FETCHMODE_FLIPPED switches this order, so the first level of arrays is the column name, and the second level the row number.

Definition at line 147 of file MDB2.php.

Referenced by MDB2_Result_Common\fetchAll().

MDB2_FETCHMODE_OBJECT

const MDB2_FETCHMODE_OBJECT 3

Column data as object properties.

Definition at line 139 of file MDB2.php.

Referenced by MDB2_Result_oci8\fetchRow(), MDB2_Result_pgsql\fetchRow(), MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_BufferedResult_oci8\fetchRow(), and MDB2_Driver_Common\setFetchMode().

MDB2_FETCHMODE_ORDERED

const MDB2_FETCHMODE_ORDERED 1

Column data indexed by numbers, ordered from 0 and up.

Definition at line 129 of file MDB2.php.

Referenced by MDB2_Result_Common\fetchCol(), MDB2_Result_Common\fetchOne(), MDB2_Driver_Manager_mysql\listTables(), MDB2_Driver_Manager_mysqli\listTables(), and MDB2_Driver_Common\setFetchMode().

MDB2_OK

const MDB2_OK(!class_exists( 'PEAR')) true

The method mapErrorCode in each MDB2_dbtype implementation maps native error codes to one of these.

If you add an error code here, make sure you also add a textual version of it in MDB2::errorMessage().

Definition at line 72 of file MDB2.php.

Referenced by MDB2_Result_Common\_assignBindColumns(), MDB2_Driver_Datatype_Common\_destroyLOB(), MDB2_Statement_oci8\_execute(), MDB2_Driver_Datatype_oci8\_retrieveLOB(), MDB2_Driver_Datatype_Common\_retrieveLOB(), MDB2_Driver_Manager_pgsql\alterTable(), MDB2_Driver_Manager_mysql\alterTable(), MDB2_Driver_Manager_mysqli\alterTable(), MDB2_Driver_Common\beginNestedTransaction(), MDB2_Driver_oci8\beginTransaction(), MDB2_Driver_mysql\beginTransaction(), MDB2_Driver_mysqli\beginTransaction(), MDB2_Driver_pgsql\beginTransaction(), MDB2_Result_Common\bindColumn(), MDB2_Statement_Common\bindParam(), MDB2_Statement_Common\bindParamArray(), MDB2_Statement_Common\bindValue(), MDB2_Statement_Common\bindValueArray(), MDB2_Driver_oci8\commit(), MDB2_Driver_mysqli\commit(), MDB2_Driver_mysql\commit(), MDB2_Driver_pgsql\commit(), MDB2_Driver_Common\completeNestedTransaction(), MDB2_Driver_mysqli\connect(), MDB2_Driver_mysql\connect(), MDB2_Driver_oci8\connect(), MDB2_Driver_pgsql\connect(), MDB2_Driver_Manager_oci8\createDatabase(), MDB2_Driver_Manager_mysqli\createDatabase(), MDB2_Driver_Manager_mysql\createDatabase(), MDB2_Driver_Manager_mysql\createSequence(), MDB2_Driver_Manager_mysqli\createSequence(), MDB2_Driver_Native_pgsql\deleteOID(), MDB2_Driver_Datatype_Common\destroyLOB(), MDB2_Driver_Common\disconnect(), MDB2_Driver_Manager_mysql\dropDatabase(), MDB2_Driver_Manager_mysqli\dropDatabase(), MDB2\errorMessage(), MDB2_Extended\executeMultiple(), MDB2_Driver_Common\failNestedTransaction(), MDB2_Result_oci8\free(), MDB2_Result_pgsql\free(), MDB2_Result_mysql\free(), MDB2_Result_mysqli\free(), MDB2_Driver_Common\free(), MDB2_Statement_pgsql\free(), MDB2_Statement_mysql\free(), MDB2_Statement_oci8\free(), MDB2_Statement_mysqli\free(), MDB2_Result_Common\free(), MDB2_Statement_Common\free(), MDB2\loadClass(), MDB2_Result_pgsql\nextResult(), MDB2_Result_mysqli\nextResult(), MDB2_BufferedResult_mysqli\nextResult(), ilDBPdoFieldDefinition\retrieveLOB(), MDB2_Driver_oci8\rollback(), MDB2_Driver_pgsql\rollback(), MDB2_Driver_mysqli\rollback(), MDB2_Driver_mysql\rollback(), MDB2_BufferedResult_pgsql\seek(), MDB2_BufferedResult_oci8\seek(), MDB2_BufferedResult_mysql\seek(), MDB2_BufferedResult_mysqli\seek(), MDB2_Result_Common\seek(), MDB2_Driver_pgsql\setCharset(), MDB2_Driver_Common\setFetchMode(), MDB2_Driver_Common\setLimit(), MDB2_Driver_Common\setOption(), MDB2\setOptions(), MDB2_Result_Common\setResultTypes(), MDB2_Driver_Datatype_oci8\writeLOBToFile(), MDB2_Driver_Datatype_Common\writeLOBToFile(), and ilDBPdoFieldDefinition\writeLOBToFile().

MDB2_PORTABILITY_ALL

const MDB2_PORTABILITY_ALL 127

Portability: turn on all portability features.

See also

MDB2_Driver_Common::setOption()

Definition at line 215 of file MDB2.php.

Referenced by ilDB\connect().

MDB2_PORTABILITY_DELETE_COUNT

const MDB2_PORTABILITY_DELETE_COUNT 4

Portability: force reporting the number of rows deleted.

See also

MDB2_Driver_Common::setOption()

Definition at line 175 of file MDB2.php.

Referenced by MDB2_Driver_mysql\_modifyQuery(), and MDB2_Driver_mysqli\_modifyQuery().

MDB2_PORTABILITY_EMPTY_TO_NULL

const MDB2_PORTABILITY_EMPTY_TO_NULL 32

Portability: convert empty values to null strings in data output by query*() and fetch*().

See also

MDB2_Driver_Common::setOption()

Definition at line 203 of file MDB2.php.

Referenced by MDB2_Driver_Common\_fixResultArrayValues(), MDB2_Driver_Datatype_Common\_getDeclarationOptions(), ilDB\connectHost(), MDB2_Result_pgsql\fetchRow(), MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_Driver_Datatype_Common\quote(), and ilDBPdoFieldDefinition\quote().

MDB2_PORTABILITY_ERRORS

const MDB2_PORTABILITY_ERRORS 16

Portability: makes certain error messages in certain drivers compatible with those from other DBMS's.

• mysql, mysqli: change unique/primary key constraints MDB2_ERROR_ALREADY_EXISTS -> MDB2_ERROR_CONSTRAINT
• odbc(access): MS's ODBC driver reports 'no such field' as code 07001, which means 'too few parameters.' When this option is on that code gets mapped to MDB2_ERROR_NOSUCHFIELD.

See also

MDB2_Driver_Common::setOption()

Definition at line 196 of file MDB2.php.

Referenced by MDB2_Driver_mysql\errorInfo(), and MDB2_Driver_mysqli\errorInfo().

MDB2_PORTABILITY_FIX_ASSOC_FIELD_NAMES

const MDB2_PORTABILITY_FIX_ASSOC_FIELD_NAMES 64

Portability: removes database/table qualifiers from associative indexes.

See also

MDB2_Driver_Common::setOption()

Definition at line 209 of file MDB2.php.

Referenced by MDB2_Driver_Common\_fixResultArrayValues().

MDB2_PORTABILITY_FIX_CASE

const MDB2_PORTABILITY_FIX_CASE 1

Portability: convert names of tables and fields to case defined in the "field_case" option when using the query*(), fetch*() and tableInfo() methods.

See also

MDB2_Driver_Common::setOption()

Definition at line 163 of file MDB2.php.

Referenced by MDB2_Result_oci8\_getColumnNames(), MDB2_Result_pgsql\_getColumnNames(), MDB2_Result_mysql\_getColumnNames(), MDB2_Result_mysqli\_getColumnNames(), MDB2_Result_Common\bindColumn(), ilDB\connectHost(), MDB2_Result_oci8\fetchRow(), MDB2_Result_pgsql\fetchRow(), MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_Driver_Reverse_mysql\getTableConstraintDefinition(), MDB2_Driver_Reverse_oci8\getTableConstraintDefinition(), MDB2_Driver_Reverse_mysqli\getTableConstraintDefinition(), MDB2_Driver_Reverse_oci8\getTableFieldDefinition(), MDB2_Driver_Reverse_mysql\getTableFieldDefinition(), MDB2_Driver_Reverse_mysqli\getTableFieldDefinition(), MDB2_Driver_Reverse_mysql\getTableIndexDefinition(), MDB2_Driver_Reverse_oci8\getTableIndexDefinition(), MDB2_Driver_Reverse_mysqli\getTableIndexDefinition(), MDB2_Driver_Manager_pgsql\listDatabases(), MDB2_Driver_Manager_mysql\listDatabases(), MDB2_Driver_Manager_mysqli\listDatabases(), MDB2_Driver_Manager_mysql\listFunctions(), MDB2_Driver_Manager_pgsql\listFunctions(), MDB2_Driver_Manager_mysqli\listFunctions(), MDB2_Driver_Manager_pgsql\listSequences(), MDB2_Driver_Manager_mysql\listSequences(), MDB2_Driver_Manager_mysqli\listSequences(), MDB2_Driver_Manager_pgsql\listTableConstraints(), MDB2_Driver_Manager_mysql\listTableConstraints(), MDB2_Driver_Manager_mysqli\listTableConstraints(), MDB2_Driver_Manager_mysql\listTableFields(), MDB2_Driver_Manager_mysqli\listTableFields(), MDB2_Driver_Manager_pgsql\listTableIndexes(), MDB2_Driver_Manager_mysql\listTableIndexes(), MDB2_Driver_Manager_mysqli\listTableIndexes(), MDB2_Driver_Manager_mysql\listTables(), MDB2_Driver_Manager_pgsql\listTables(), MDB2_Driver_Manager_mysqli\listTables(), MDB2_Driver_Manager_mysql\listTableTriggers(), MDB2_Driver_Manager_pgsql\listTableTriggers(), MDB2_Driver_Manager_mysqli\listTableTriggers(), MDB2_Driver_Manager_pgsql\listTableViews(), MDB2_Driver_Manager_pgsql\listViews(), MDB2_Driver_Manager_mysql\listViews(), MDB2_Driver_Manager_mysqli\listViews(), MDB2_Driver_Reverse_mysql\tableInfo(), MDB2_Driver_Reverse_pgsql\tableInfo(), MDB2_Driver_Reverse_mysqli\tableInfo(), and MDB2_Driver_Reverse_oci8\tableInfo().

MDB2_PORTABILITY_NONE

const MDB2_PORTABILITY_NONE 0

Portability: turn off all portability features.

See also

MDB2_Driver_Common::setOption()

Definition at line 156 of file MDB2.php.

MDB2_PORTABILITY_NUMROWS

const MDB2_PORTABILITY_NUMROWS 8

Portability: not needed in MDB2 (just left here for compatibility to DB)

See also

MDB2_Driver_Common::setOption()

Definition at line 181 of file MDB2.php.

MDB2_PORTABILITY_RTRIM

const MDB2_PORTABILITY_RTRIM 2

Portability: right trim the data output by query*() and fetch*().

See also

MDB2_Driver_Common::setOption()

Definition at line 169 of file MDB2.php.

Referenced by MDB2_Driver_Common\_fixResultArrayValues(), MDB2_Result_oci8\fetchRow(), MDB2_Result_pgsql\fetchRow(), and MDB2_BufferedResult_oci8\fetchRow().

MDB2_PREPARE_MANIP

const MDB2_PREPARE_MANIP false

These are just helper constants to more verbosely express parameters to prepare()

Definition at line 114 of file MDB2.php.

Referenced by MDB2_Extended\execParam(), ilDB\insert(), MDB2_Driver_oci8\prepare(), MDB2_Driver_pgsql\prepare(), MDB2_Driver_mysql\prepare(), MDB2_Driver_mysqli\prepare(), MDB2_Driver_Common\prepare(), ilDB\prepareManip(), ilDB\replace(), and ilDB\update().

MDB2_PREPARE_RESULT

const MDB2_PREPARE_RESULT null

Definition at line 115 of file MDB2.php.