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
namespace	MDB2
	The main 'MDB2' 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.

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

@access public

Definition at line 4231 of file MDB2.php.

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

References $GLOBALS.

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

@access public

Definition at line 4263 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 219 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 220 of file MDB2.php.

MDB2_ERROR

const MDB2_ERROR -1

Definition at line 68 of file MDB2.php.

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

MDB2_ERROR_ACCESS_VIOLATION

const MDB2_ERROR_ACCESS_VIOLATION -27

Definition at line 94 of file MDB2.php.

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

MDB2_ERROR_ALREADY_EXISTS

const MDB2_ERROR_ALREADY_EXISTS -5

Definition at line 72 of file MDB2.php.

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

MDB2_ERROR_CANNOT_ALTER

const MDB2_ERROR_CANNOT_ALTER -31

Definition at line 98 of file MDB2.php.

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

MDB2_ERROR_CANNOT_CREATE

const MDB2_ERROR_CANNOT_CREATE -15

Definition at line 82 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 83 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_CANNOT_DROP

const MDB2_ERROR_CANNOT_DROP -17

Definition at line 84 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 95 of file MDB2.php.

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

MDB2_ERROR_CONNECT_FAILED

const MDB2_ERROR_CONNECT_FAILED -24

Definition at line 91 of file MDB2.php.

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

MDB2_ERROR_CONSTRAINT

const MDB2_ERROR_CONSTRAINT -3

Definition at line 70 of file MDB2.php.

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

MDB2_ERROR_CONSTRAINT_NOT_NULL

const MDB2_ERROR_CONSTRAINT_NOT_NULL -29

Definition at line 96 of file MDB2.php.

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

MDB2_ERROR_DEADLOCK

const MDB2_ERROR_DEADLOCK -30

Definition at line 97 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_DIVZERO

const MDB2_ERROR_DIVZERO -13

Definition at line 80 of file MDB2.php.

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

MDB2_ERROR_EXTENSION_NOT_FOUND

const MDB2_ERROR_EXTENSION_NOT_FOUND -25

Definition at line 92 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_INSUFFICIENT_DATA

const MDB2_ERROR_INSUFFICIENT_DATA -35

Definition at line 102 of file MDB2.php.

MDB2_ERROR_INVALID

const MDB2_ERROR_INVALID -8

Definition at line 75 of file MDB2.php.

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

MDB2_ERROR_INVALID_DATE

const MDB2_ERROR_INVALID_DATE -12

Definition at line 79 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_INVALID_DSN

const MDB2_ERROR_INVALID_DSN -23

Definition at line 90 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_INVALID_NUMBER

const MDB2_ERROR_INVALID_NUMBER -11

Definition at line 78 of file MDB2.php.

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

MDB2_ERROR_LOADMODULE

const MDB2_ERROR_LOADMODULE -34

Definition at line 101 of file MDB2.php.

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

MDB2_ERROR_MANAGER

const MDB2_ERROR_MANAGER -32

Definition at line 99 of file MDB2.php.

MDB2_ERROR_MANAGER_PARSE

const MDB2_ERROR_MANAGER_PARSE -33

Definition at line 100 of file MDB2.php.

MDB2_ERROR_MISMATCH

const MDB2_ERROR_MISMATCH -7

Definition at line 74 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_NEED_MORE_DATA

const MDB2_ERROR_NEED_MORE_DATA -20

Definition at line 87 of file MDB2.php.

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

MDB2_ERROR_NODBSELECTED

const MDB2_ERROR_NODBSELECTED -14

Definition at line 81 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 93 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 86 of file MDB2.php.

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

MDB2_ERROR_NOSUCHTABLE

const MDB2_ERROR_NOSUCHTABLE -18

Definition at line 85 of file MDB2.php.

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

MDB2_ERROR_NOT_CAPABLE

const MDB2_ERROR_NOT_CAPABLE -9

Definition at line 76 of file MDB2.php.

Referenced by MDB2\errorMessage().

MDB2_ERROR_NOT_FOUND

const MDB2_ERROR_NOT_FOUND -4

Definition at line 71 of file MDB2.php.

Referenced by MDB2_Driver_oci8\_doConnect(), MDB2_Statement_Common\_execute(), MDB2_Statement_mysql\_execute(), MDB2_Statement_mysqli\_execute(), MDB2_Statement_oci8\_execute(), MDB2_Statement_pgsql\_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_mysql\connect(), MDB2_Driver_mysqli\connect(), MDB2_Driver_pgsql\connect(), MDB2_Driver_mysql\errorInfo(), MDB2_Driver_mysqli\errorInfo(), MDB2_Driver_oci8\errorInfo(), MDB2_Driver_pgsql\errorInfo(), MDB2\errorMessage(), MDB2\factory(), MDB2_Module_Common\getDBInstance(), MDB2_Driver_Datatype_Common\getDeclaration(), MDB2_Driver_Reverse_mysqli\getTableConstraintDefinition(), MDB2_Driver_Reverse_oci8\getTableConstraintDefinition(), MDB2_Driver_Reverse_pgsql\getTableConstraintDefinition(), MDB2_Driver_Reverse_mysql\getTableConstraintDefinition(), MDB2_Driver_Reverse_mysql\getTableFieldDefinition(), MDB2_Driver_Reverse_mysqli\getTableFieldDefinition(), MDB2_Driver_Reverse_oci8\getTableFieldDefinition(), MDB2_Driver_Reverse_pgsql\getTableFieldDefinition(), MDB2_Driver_Reverse_mysql\getTableIndexDefinition(), MDB2_Driver_Reverse_mysqli\getTableIndexDefinition(), MDB2_Driver_Reverse_oci8\getTableIndexDefinition(), MDB2_Driver_Reverse_pgsql\getTableIndexDefinition(), MDB2\loadClass(), MDB2\loadFile(), and MDB2_Driver_Common\raiseError().

MDB2_ERROR_NOT_LOCKED

const MDB2_ERROR_NOT_LOCKED -21

Definition at line 88 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 69 of file MDB2.php.

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

MDB2_ERROR_TRUNCATED

const MDB2_ERROR_TRUNCATED -10

Definition at line 77 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 73 of file MDB2.php.

Referenced by MDB2_Driver_Common\_affectedRows(), MDB2_Driver_Common\_doQuery(), MDB2_Result_Common\_getColumnNames(), MDB2_Driver_Datatype_Common\_mapNativeDatatype(), MDB2_Driver_Datatype_mysql\_mapNativeDatatype(), MDB2_Driver_Datatype_mysqli\_mapNativeDatatype(), MDB2_Driver_Datatype_oci8\_mapNativeDatatype(), MDB2_Driver_Datatype_pgsql\_mapNativeDatatype(), MDB2_Driver_Manager_Common\alterTable(), MDB2_Driver_Common\beginTransaction(), MDB2_Driver_mysql\beginTransaction(), MDB2_Driver_mysqli\beginTransaction(), MDB2_Driver_Datatype_Common\checkResultTypes(), MDB2_Driver_Common\commit(), MDB2_Driver_mysql\commit(), MDB2_Driver_mysqli\commit(), MDB2_Driver_Datatype_Common\compareDefinition(), MDB2_Driver_Common\connect(), MDB2_Driver_Manager_Common\createDatabase(), MDB2_Driver_Manager_oci8\createDatabase(), MDB2_Driver_Manager_Common\createSequence(), MDB2_Driver_Manager_Common\dropDatabase(), MDB2_Driver_Manager_oci8\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_Common\matchPattern(), MDB2_Driver_Datatype_mysql\matchPattern(), MDB2_Driver_Datatype_mysqli\matchPattern(), MDB2_Driver_Datatype_pgsql\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_Common\rollback(), MDB2_Driver_mysql\rollback(), MDB2_Driver_mysqli\rollback(), MDB2_Result_Common\seek(), MDB2_Driver_Common\setCharset(), MDB2_Driver_Common\setFetchMode(), MDB2_Driver_Common\setLimit(), MDB2_Driver_Common\setOption(), MDB2_Driver_mysql\setTransactionIsolation(), MDB2_Driver_mysqli\setTransactionIsolation(), MDB2_Driver_oci8\setTransactionIsolation(), MDB2_Driver_pgsql\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 89 of file MDB2.php.

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

MDB2_FETCHMODE_ASSOC

const MDB2_FETCHMODE_ASSOC 2

Column data indexed by column names.

Definition at line 129 of file MDB2.php.

Referenced by Auth_OpenID_MDB2Store\Auth_OpenID_MDB2Store(), MDB2_Result_Common\fetchAll(), MDB2_Result_Common\fetchCol(), Auth_Container_MDB2\fetchData(), MDB2_Result_Common\fetchOne(), MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_Result_oci8\fetchRow(), MDB2_BufferedResult_oci8\fetchRow(), MDB2_Result_pgsql\fetchRow(), MDB2_Driver_Reverse_mysqli\getTableConstraintDefinition(), MDB2_Driver_Reverse_oci8\getTableConstraintDefinition(), MDB2_Driver_Reverse_pgsql\getTableConstraintDefinition(), MDB2_Driver_Reverse_mysql\getTableConstraintDefinition(), MDB2_Driver_Reverse_mysql\getTableFieldDefinition(), MDB2_Driver_Reverse_mysqli\getTableFieldDefinition(), MDB2_Driver_Reverse_oci8\getTableFieldDefinition(), MDB2_Driver_Reverse_pgsql\getTableFieldDefinition(), MDB2_Driver_Reverse_mysql\getTableIndexDefinition(), MDB2_Driver_Reverse_mysqli\getTableIndexDefinition(), MDB2_Driver_Reverse_oci8\getTableIndexDefinition(), MDB2_Driver_Reverse_pgsql\getTableIndexDefinition(), MDB2_Driver_Reverse_mysql\getTriggerDefinition(), MDB2_Driver_Reverse_mysqli\getTriggerDefinition(), MDB2_Driver_Reverse_oci8\getTriggerDefinition(), MDB2_Driver_Reverse_pgsql\getTriggerDefinition(), MDB2_Driver_Manager_mysql\listTableConstraints(), MDB2_Driver_Manager_mysqli\listTableConstraints(), MDB2_Driver_Manager_mysql\listTableIndexes(), MDB2_Driver_Manager_mysqli\listTableIndexes(), Auth_Container_MDB2\listUsers(), 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 119 of file MDB2.php.

Referenced by MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_Result_oci8\fetchRow(), MDB2_BufferedResult_oci8\fetchRow(), and MDB2_Result_pgsql\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 142 of file MDB2.php.

MDB2_FETCHMODE_OBJECT

const MDB2_FETCHMODE_OBJECT 3

Column data as object properties.

Definition at line 134 of file MDB2.php.

Referenced by MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_Result_oci8\fetchRow(), MDB2_BufferedResult_oci8\fetchRow(), MDB2_Result_pgsql\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 124 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 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 67 of file MDB2.php.

Referenced by MDB2_Result_Common\_assignBindColumns(), MDB2_Driver_Datatype_Common\_destroyLOB(), MDB2_Statement_oci8\_execute(), MDB2_Driver_Datatype_Common\_retrieveLOB(), MDB2_Driver_Datatype_oci8\_retrieveLOB(), MDB2_Driver_Manager_mysql\alterTable(), MDB2_Driver_Manager_mysqli\alterTable(), MDB2_Driver_Manager_pgsql\alterTable(), MDB2_Driver_Common\beginNestedTransaction(), MDB2_Driver_mysql\beginTransaction(), MDB2_Driver_mysqli\beginTransaction(), MDB2_Driver_oci8\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_mysql\commit(), MDB2_Driver_mysqli\commit(), MDB2_Driver_oci8\commit(), MDB2_Driver_pgsql\commit(), MDB2_Driver_Common\completeNestedTransaction(), MDB2_Driver_mysql\connect(), MDB2_Driver_mysqli\connect(), MDB2_Driver_oci8\connect(), MDB2_Driver_pgsql\connect(), MDB2_Driver_Manager_mysql\createDatabase(), MDB2_Driver_Manager_mysqli\createDatabase(), MDB2_Driver_Manager_oci8\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_Driver_Common\free(), MDB2_Result_Common\free(), MDB2_Statement_Common\free(), MDB2_Result_mysql\free(), MDB2_Statement_mysql\free(), MDB2_Result_mysqli\free(), MDB2_Statement_mysqli\free(), MDB2_Result_oci8\free(), MDB2_Statement_oci8\free(), MDB2_Result_pgsql\free(), MDB2_Statement_pgsql\free(), MDB2\loadClass(), MDB2_Result_mysqli\nextResult(), MDB2_BufferedResult_mysqli\nextResult(), MDB2_Result_pgsql\nextResult(), MDB2_Driver_mysql\rollback(), MDB2_Driver_mysqli\rollback(), MDB2_Driver_oci8\rollback(), MDB2_Driver_pgsql\rollback(), MDB2_Result_Common\seek(), MDB2_BufferedResult_mysql\seek(), MDB2_BufferedResult_mysqli\seek(), MDB2_BufferedResult_oci8\seek(), MDB2_BufferedResult_pgsql\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_Common\writeLOBToFile(), and MDB2_Driver_Datatype_oci8\writeLOBToFile().

MDB2_PORTABILITY_ALL

const MDB2_PORTABILITY_ALL 127

Portability: turn on all portability features.

See also

MDB2_Driver_Common::setOption()

Definition at line 210 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 170 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 198 of file MDB2.php.

Referenced by MDB2_Driver_Common\_fixResultArrayValues(), MDB2_Driver_Datatype_Common\_getDeclarationOptions(), ilDB\connectHost(), MDB2_Result_mysql\fetchRow(), MDB2_Result_mysqli\fetchRow(), MDB2_Result_pgsql\fetchRow(), and MDB2_Driver_Datatype_Common\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 191 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 204 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 158 of file MDB2.php.

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

MDB2_PORTABILITY_NONE

const MDB2_PORTABILITY_NONE 0

Portability: turn off all portability features.

See also

MDB2_Driver_Common::setOption()

Definition at line 151 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 176 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 164 of file MDB2.php.

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

MDB2_PREPARE_MANIP

const MDB2_PREPARE_MANIP false

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

Definition at line 109 of file MDB2.php.

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

MDB2_PREPARE_RESULT

const MDB2_PREPARE_RESULT null

Definition at line 110 of file MDB2.php.