Collaboration diagram for MDB2:

Public Member Functions
	setOptions (&$db, $options)
	set option array in an exiting database object More...

	loadClass ($class_name, $debug)
	Loads a PEAR class. More...

&	factory ($dsn, $options=false)
	Create a new MDB2 object for the specified database type. More...

&	connect ($dsn, $options=false)
	Create a new MDB2 connection object and connect to the specified database. More...

&	singleton ($dsn=null, $options=false)
	Returns a MDB2 connection with the requested DSN. More...

	loadFile ($file)
	load a file (like 'Date') More...

	apiVersion ()
	Return the MDB2 API version. More...

&	raiseError ($code=null, $mode=null, $options=null, $userinfo=null)
	This method is used to communicate an error and invoke error callbacks etc. More...

	isError ($data, $code=null)
	Tell whether a value is a MDB2 error. More...

	isConnection ($value)
	Tell whether a value is a MDB2 connection. More...

	isResult ($value)
	Tell whether a value is a MDB2 result. More...

	isResultCommon ($value)
	Tell whether a value is a MDB2 result implementing the common interface. More...

	isStatement ($value)
	Tell whether a value is a MDB2 statement interface. More...

	errorMessage ($value=null)
	Return a textual error message for a MDB2 error code. More...

	parseDSN ($dsn)

	fileExists ($file)
	Checks if a file exists in the include path. More...

Static Public Member Functions
	classExists ($classname)
	Checks if a class exists without triggering __autoload. More...

Detailed Description

Definition at line 270 of file MDB2.php.

Member Function Documentation

◆ apiVersion()

MDB2::apiVersion ( )

Return the MDB2 API version.

Returns: string the MDB2 API version number

@access public

Definition at line 545 of file MDB2.php.

    {
        return '2.4.1';
    }

◆ classExists()

MDB2::classExists ( $classname )

static

Checks if a class exists without triggering __autoload.

Parameters

string classname

Returns: bool true success and false on error

@access public

Definition at line 309 of file MDB2.php.

    {
        if (version_compare(phpversion(), "5.0", ">=")) {
            return class_exists($classname, false);
        }
        return class_exists($classname);
    }

Referenced by MDB2_Driver_Common\_wrapResult(), loadClass(), and MDB2_Driver_Common\loadModule().

Here is the caller graph for this function:

◆ connect()

& MDB2::connect	(	$dsn,
		$options = `false`
	)

Create a new MDB2 connection object and connect to the specified database.

IMPORTANT: In order for MDB2 to work properly it is necessary that you make sure that you work with a reference of the original object instead of a copy (this is a PHP4 quirk).

For example: $db =& MDB2::connect($dsn); ^^ And not: $db = MDB2::connect($dsn); ^^

Parameters

mixed	'data source name', see the MDB2::parseDSN method for a description of the dsn format. Can also be specified as an array of the format returned by MDB2::parseDSN.
array	An associative array of option names and their values.

Returns: mixed a newly created MDB2 connection object, or a MDB2 error object on error

@access public

See also: MDB2::parseDSN

Definition at line 436 of file MDB2.php.

    {
        $db =& MDB2::factory($dsn, $options);
        if (PEAR::isError($db)) {
            return $db;
        }
 
        $err = $db->connect();
        if (PEAR::isError($err)) {
            $dsn = $db->getDSN('string', 'xxx');
            $db->disconnect();
            $err->addUserInfo($dsn);
            return $err;
        }
 
        return $db;
    }

References $options, factory(), and PEAR\isError().

Referenced by ilDB\connectHost(), ilDB\doConnect(), ilDBMySQL\doConnect(), and ilDBOracle\doConnect().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ errorMessage()

MDB2::errorMessage ( $value = null )

Return a textual error message for a MDB2 error code.

Parameters

int|array integer error code, null to get the current error code-message map, or an array with a new error code-message map

Returns: string error message, or false if the error code was not recognized

@access public

Definition at line 697 of file MDB2.php.

    {
        static $errorMessages;
 
        if (is_array($value)) {
            $errorMessages = $value;
            return MDB2_OK;
        }
 
        if (!isset($errorMessages)) {
            $errorMessages = array(
                MDB2_OK                       => 'no error',
                MDB2_ERROR                    => 'unknown error',
                MDB2_ERROR_ALREADY_EXISTS     => 'already exists',
                MDB2_ERROR_CANNOT_CREATE      => 'can not create',
                MDB2_ERROR_CANNOT_ALTER       => 'can not alter',
                MDB2_ERROR_CANNOT_REPLACE     => 'can not replace',
                MDB2_ERROR_CANNOT_DELETE      => 'can not delete',
                MDB2_ERROR_CANNOT_DROP        => 'can not drop',
                MDB2_ERROR_CONSTRAINT         => 'constraint violation',
                MDB2_ERROR_CONSTRAINT_NOT_NULL=> 'null value violates not-null constraint',
                MDB2_ERROR_DIVZERO            => 'division by zero',
                MDB2_ERROR_INVALID            => 'invalid',
                MDB2_ERROR_INVALID_DATE       => 'invalid date or time',
                MDB2_ERROR_INVALID_NUMBER     => 'invalid number',
                MDB2_ERROR_MISMATCH           => 'mismatch',
                MDB2_ERROR_NODBSELECTED       => 'no database selected',
                MDB2_ERROR_NOSUCHFIELD        => 'no such field',
                MDB2_ERROR_NOSUCHTABLE        => 'no such table',
                MDB2_ERROR_NOT_CAPABLE        => 'MDB2 backend not capable',
                MDB2_ERROR_NOT_FOUND          => 'not found',
                MDB2_ERROR_NOT_LOCKED         => 'not locked',
                MDB2_ERROR_SYNTAX             => 'syntax error',
                MDB2_ERROR_UNSUPPORTED        => 'not supported',
                MDB2_ERROR_VALUE_COUNT_ON_ROW => 'value count on row',
                MDB2_ERROR_INVALID_DSN        => 'invalid DSN',
                MDB2_ERROR_CONNECT_FAILED     => 'connect failed',
                MDB2_ERROR_NEED_MORE_DATA     => 'insufficient data supplied',
                MDB2_ERROR_EXTENSION_NOT_FOUND=> 'extension not found',
                MDB2_ERROR_NOSUCHDB           => 'no such database',
                MDB2_ERROR_ACCESS_VIOLATION   => 'insufficient permissions',
                MDB2_ERROR_LOADMODULE         => 'error while including on demand module',
                MDB2_ERROR_TRUNCATED          => 'truncated',
                MDB2_ERROR_DEADLOCK           => 'deadlock detected',
            );
        }
 
        if (is_null($value)) {
            return $errorMessages;
        }
 
        if (PEAR::isError($value)) {
            $value = $value->getCode();
        }
 
        return isset($errorMessages[$value]) ?
           $errorMessages[$value] : $errorMessages[MDB2_ERROR];
    }

References PEAR\isError(), MDB2_ERROR, MDB2_ERROR_ACCESS_VIOLATION, MDB2_ERROR_ALREADY_EXISTS, MDB2_ERROR_CANNOT_ALTER, MDB2_ERROR_CANNOT_CREATE, MDB2_ERROR_CANNOT_DELETE, MDB2_ERROR_CANNOT_DROP, MDB2_ERROR_CANNOT_REPLACE, MDB2_ERROR_CONNECT_FAILED, MDB2_ERROR_CONSTRAINT, MDB2_ERROR_CONSTRAINT_NOT_NULL, MDB2_ERROR_DEADLOCK, MDB2_ERROR_DIVZERO, MDB2_ERROR_EXTENSION_NOT_FOUND, MDB2_ERROR_INVALID, MDB2_ERROR_INVALID_DATE, MDB2_ERROR_INVALID_DSN, MDB2_ERROR_INVALID_NUMBER, MDB2_ERROR_LOADMODULE, MDB2_ERROR_MISMATCH, MDB2_ERROR_NEED_MORE_DATA, MDB2_ERROR_NODBSELECTED, MDB2_ERROR_NOSUCHDB, MDB2_ERROR_NOSUCHFIELD, MDB2_ERROR_NOSUCHTABLE, MDB2_ERROR_NOT_CAPABLE, MDB2_ERROR_NOT_FOUND, MDB2_ERROR_NOT_LOCKED, MDB2_ERROR_SYNTAX, MDB2_ERROR_TRUNCATED, MDB2_ERROR_UNSUPPORTED, MDB2_ERROR_VALUE_COUNT_ON_ROW, and MDB2_OK.

Referenced by MDB2_Error\__construct().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ factory()

& MDB2::factory	(	$dsn,
		$options = `false`
	)

Create a new MDB2 object for the specified database type.

IMPORTANT: In order for MDB2 to work properly it is necessary that you make sure that you work with a reference of the original object instead of a copy (this is a PHP4 quirk).

For example: $db =& MDB2::factory($dsn); ^^ And not: $db = MDB2::factory($dsn);

Parameters

mixed	'data source name', see the MDB2::parseDSN method for a description of the dsn format. Can also be specified as an array of the format returned by MDB2::parseDSN.
array	An associative array of option names and their values.

Returns: mixed a newly created MDB2 object, or false on error

@access public

Definition at line 379 of file MDB2.php.

    {
        $dsninfo = MDB2::parseDSN($dsn);
        if (empty($dsninfo['phptype'])) {
            $err =& MDB2::raiseError(MDB2_ERROR_NOT_FOUND,
                null, null, 'no RDBMS driver specified');
            return $err;
        }
        $class_name = 'MDB2_Driver_'.$dsninfo['phptype'];
 
        $debug = (!empty($options['debug']));
        $err = MDB2::loadClass($class_name, $debug);
        if (PEAR::isError($err)) {
            return $err;
        }
 
        $db = new $class_name();
        $db->setDSN($dsninfo);
        $err = MDB2::setOptions($db, $options);
        if (PEAR::isError($err)) {
            return $err;
        }
 
        return $db;
    }

References $debug, $options, PEAR\isError(), loadClass(), MDB2_ERROR_NOT_FOUND, parseDSN(), raiseError(), and setOptions().

Referenced by connect(), and singleton().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ fileExists()

MDB2::fileExists ( $file )

Checks if a file exists in the include path.

Parameters

string filename

Returns: bool true success and false on error

@access public

Definition at line 926 of file MDB2.php.

    {
        // safe_mode does notwork with is_readable()
        if (!@ini_get('safe_mode')) {
             $dirs = explode(PATH_SEPARATOR, ini_get('include_path'));
             foreach ($dirs as $dir) {
                 if (@is_readable($dir . DIRECTORY_SEPARATOR . $file)) {
                     return true;
                 }
            }
        } else {
            $fp = @fopen($file, 'r', true);
            if (is_resource($fp)) {
                @fclose($fp);
                return true;
            }
        }
        return false;
    }

References $file.

Referenced by loadClass(), loadFile(), and MDB2_Driver_Common\loadModule().

Here is the caller graph for this function:

◆ isConnection()

MDB2::isConnection ( $value )

Tell whether a value is a MDB2 connection.

Parameters

mixed value to test

Returns: bool whether $value is a MDB2 connection

@access public

Definition at line 626 of file MDB2.php.

    {
        return is_a($value, 'MDB2_Driver_Common');
    }

◆ isError()

MDB2::isError	(	$data,
		$code = `null`
	)

Tell whether a value is a MDB2 error.

Parameters

mixed	the value to test
int	if is an error object, return true only if $code is a string and $db->getMessage() == $code or $code is an integer and $db->getCode() == $code

Returns: bool true if parameter is an error

@access public

Definition at line 599 of file MDB2.php.

    {
        if (is_a($data, 'MDB2_Error')) {
            if (is_null($code)) {
                return true;
            } elseif (is_string($code)) {
                return $data->getMessage() === $code;
            } else {
                $code = (array)$code;
                return in_array($data->getCode(), $code);
            }
        }
        return false;
    }

References $code, and $data.

Referenced by ilClient\checkDatabaseExists(), ilDB\connect(), ilDB\connectHost(), MDB2_Result_Common\execute(), ilDBOracle\getDBVersion(), ilDB\getLastInsertId(), ilDB\getOne(), ilDB\handleError(), ilDB\isDbError(), ilDB\listSequences(), ilDB\listTables(), and ilDB\tableColumnExists().

Here is the caller graph for this function:

◆ isResult()

MDB2::isResult ( $value )

Tell whether a value is a MDB2 result.

Parameters

mixed value to test

Returns: bool whether $value is a MDB2 result

@access public

Definition at line 643 of file MDB2.php.

    {
        return is_a($value, 'MDB2_Result');
    }

◆ isResultCommon()

MDB2::isResultCommon ( $value )

Tell whether a value is a MDB2 result implementing the common interface.

Parameters

mixed value to test

Returns: bool whether $value is a MDB2 result implementing the common interface

@access public

Definition at line 660 of file MDB2.php.

    {
        return is_a($value, 'MDB2_Result_Common');
    }

Referenced by MDB2_Driver_Common\_wrapResult(), MDB2_Extended\getAll(), MDB2_Extended\getAssoc(), MDB2_Extended\getCol(), MDB2_Extended\getOne(), MDB2_Extended\getRow(), MDB2_Driver_Manager_pgsql\listDatabases(), MDB2_Driver_Manager_pgsql\listUsers(), MDB2_Driver_Common\queryAll(), MDB2_Driver_Common\queryCol(), MDB2_Driver_Common\queryOne(), MDB2_Driver_Common\queryRow(), ilDBPdoReversePostgres\tableInfo(), MDB2_Driver_Reverse_mysql\tableInfo(), MDB2_Driver_Reverse_mysqli\tableInfo(), MDB2_Driver_Reverse_oci8\tableInfo(), and MDB2_Driver_Reverse_pgsql\tableInfo().

Here is the caller graph for this function:

◆ isStatement()

MDB2::isStatement ( $value )

Tell whether a value is a MDB2 statement interface.

Parameters

mixed value to test

Returns: bool whether $value is a MDB2 statement interface

@access public

Definition at line 677 of file MDB2.php.

    {
        return is_a($value, 'MDB2_Statement');
    }

◆ loadClass()

MDB2::loadClass	(	$class_name,
		$debug
	)

Loads a PEAR class.

Parameters

string	classname to load
bool	if errors should be suppressed

Returns: mixed true success or PEAR_Error on failure

@access public

Definition at line 330 of file MDB2.php.

    {
        if (!MDB2::classExists($class_name)) {
            $file_name = str_replace('_', DIRECTORY_SEPARATOR, $class_name).'.php';
            if ($debug) {
                $include = include_once($file_name);
            } else {
                $include = @include_once($file_name);
            }
            if (!$include) {
                if (!MDB2::fileExists($file_name)) {
                    $msg = "unable to find package '$class_name' file '$file_name'";
                } else {
                    $msg = "unable to load class '$class_name' from file '$file_name'";
                }
                $err =& MDB2::raiseError(MDB2_ERROR_NOT_FOUND, null, null, $msg);
                return $err;
            }
        }
        return MDB2_OK;
    }

References $debug, classExists(), fileExists(), MDB2_ERROR_NOT_FOUND, MDB2_OK, and raiseError().

Referenced by factory(), and MDB2_Driver_Common\loadModule().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ loadFile()

MDB2::loadFile ( $file )

load a file (like 'Date')

Parameters

string name of the file in the MDB2 directory (without '.php')

Returns: string name of the file that was included

@access public

Definition at line 521 of file MDB2.php.

    {
        $file_name = 'MDB2'.DIRECTORY_SEPARATOR.$file.'.php';
        if (!MDB2::fileExists($file_name)) {
            return MDB2::raiseError(MDB2_ERROR_NOT_FOUND, null, null,
                'unable to find: '.$file_name);
        }
        if (!include_once($file_name)) {
            return MDB2::raiseError(MDB2_ERROR_NOT_FOUND, null, null,
                'unable to load driver class: '.$file_name);
        }
        return $file_name;
    }

References fileExists(), MDB2_ERROR_NOT_FOUND, and raiseError().

Here is the call graph for this function:

◆ parseDSN()

MDB2::parseDSN ( $dsn )

Definition at line 796 of file MDB2.php.

    {
        $parsed = $GLOBALS['_MDB2_dsninfo_default'];
 
        if (is_array($dsn)) {
            $dsn = array_merge($parsed, $dsn);
            if (!$dsn['dbsyntax']) {
                $dsn['dbsyntax'] = $dsn['phptype'];
            }
            return $dsn;
        }
 
        // Find phptype and dbsyntax
        if (($pos = strpos($dsn, '://')) !== false) {
            $str = substr($dsn, 0, $pos);
            $dsn = substr($dsn, $pos + 3);
        } else {
            $str = $dsn;
            $dsn = null;
        }
 
        // Get phptype and dbsyntax
        // $str => phptype(dbsyntax)
        if (preg_match('|^(.+?)\‍((.*?)\‍)$|', $str, $arr)) {
            $parsed['phptype']  = $arr[1];
            $parsed['dbsyntax'] = !$arr[2] ? $arr[1] : $arr[2];
        } else {
            $parsed['phptype']  = $str;
            $parsed['dbsyntax'] = $str;
        }
 
        if (!count($dsn)) {
            return $parsed;
        }
 
        // Get (if found): username and password
        // $dsn => username:password@protocol+hostspec/database
        if (($at = strrpos($dsn,'@')) !== false) {
            $str = substr($dsn, 0, $at);
            $dsn = substr($dsn, $at + 1);
            if (($pos = strpos($str, ':')) !== false) {
                $parsed['username'] = rawurldecode(substr($str, 0, $pos));
                $parsed['password'] = rawurldecode(substr($str, $pos + 1));
            } else {
                $parsed['username'] = rawurldecode($str);
            }
        }
 
        // Find protocol and hostspec
 
        // $dsn => proto(proto_opts)/database
        if (preg_match('|^([^(]+)\‍((.*?)\‍)/?(.*?)$|', $dsn, $match)) {
            $proto       = $match[1];
            $proto_opts  = $match[2] ? $match[2] : false;
            $dsn         = $match[3];
 
        // $dsn => protocol+hostspec/database (old format)
        } else {
            if (strpos($dsn, '+') !== false) {
                list($proto, $dsn) = explode('+', $dsn, 2);
            }
            if (   strpos($dsn, '//') === 0
                && strpos($dsn, '/', 2) !== false
                && $parsed['phptype'] == 'oci8'
            ) {
                //oracle's "Easy Connect" syntax:
                //"username/password@[//]host[:port][/service_name]"
                //e.g. "scott/tiger@//mymachine:1521/oracle"
                $proto_opts = $dsn;
                $dsn = null;
            } elseif (strpos($dsn, '/') !== false) {
                list($proto_opts, $dsn) = explode('/', $dsn, 2);
            } else {
                $proto_opts = $dsn;
                $dsn = null;
            }
        }
 
        // process the different protocol options
        $parsed['protocol'] = (!empty($proto)) ? $proto : 'tcp';
        $proto_opts = rawurldecode($proto_opts);
        if (strpos($proto_opts, ':') !== false) {
            list($proto_opts, $parsed['port']) = explode(':', $proto_opts);
        }
        if ($parsed['protocol'] == 'tcp') {
            $parsed['hostspec'] = $proto_opts;
        } elseif ($parsed['protocol'] == 'unix') {
            $parsed['socket'] = $proto_opts;
        }
 
        // Get dabase if any
        // $dsn => database
        if ($dsn) {
            // /database
            if (($pos = strpos($dsn, '?')) === false) {
                $parsed['database'] = $dsn;
            // /database?param1=value1&param2=value2
            } else {
                $parsed['database'] = substr($dsn, 0, $pos);
                $dsn = substr($dsn, $pos + 1);
                if (strpos($dsn, '&') !== false) {
                    $opts = explode('&', $dsn);
                } else { // database?param1=value1
                    $opts = array($dsn);
                }
                foreach ($opts as $opt) {
                    list($key, $value) = explode('=', $opt);
                    if (!isset($parsed[$key])) {
                        // don't allow params overwrite
                        $parsed[$key] = rawurldecode($value);
                    }
                }
            }
        }
 
        return $parsed;
    }

References $GLOBALS, and $key.

Referenced by factory(), MDB2_Driver_Common\setDSN(), and singleton().

Here is the caller graph for this function:

◆ raiseError()

& MDB2::raiseError	(	$code = `null`,
		$mode = `null`,
		$options = `null`,
		$userinfo = `null`
	)

This method is used to communicate an error and invoke error callbacks etc.

Basically a wrapper for PEAR::raiseError without the message string.

Parameters

mixed	int error code
int	error mode, see PEAR_Error docs
mixed	If error mode is PEAR_ERROR_TRIGGER, this is the error level (E_USER_NOTICE etc). If error mode is PEAR_ERROR_CALLBACK, this is the callback function, either as a function name, or as an array of an object and method name. For other error modes this parameter is ignored.
string	Extra debug information. Defaults to the last query and native error code.

Returns: PEAR_Error instance of a PEAR Error object

@access private

See also: PEAR_Error

Definition at line 577 of file MDB2.php.

    {
        $err =& PEAR::raiseError(null, $code, $mode, $options, $userinfo, 'MDB2_Error', true);
        return $err;
    }

References $code, $options, and PEAR\raiseError().

Referenced by factory(), MDB2_Module_Common\getDBInstance(), loadClass(), and loadFile().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ setOptions()

MDB2::setOptions	(	&	$db,
			$options
	)

set option array in an exiting database object

Parameters

MDB2_Driver_Common	MDB2 object
array	An associative array of option names and their values.

Returns: mixed MDB2_OK or a PEAR Error object

@access public

Definition at line 284 of file MDB2.php.

    {
        if (is_array($options)) {
            foreach ($options as $option => $value) {
                $test = $db->setOption($option, $value);
                if (PEAR::isError($test)) {
                    return $test;
                }
            }
        }
        return MDB2_OK;
    }

References $options, $test, PEAR\isError(), and MDB2_OK.

Referenced by factory(), and singleton().

Here is the call graph for this function:

Here is the caller graph for this function:

◆ singleton()

& MDB2::singleton	(	$dsn = `null`,
		$options = `false`
	)

Returns a MDB2 connection with the requested DSN.

A new MDB2 connection object is only created if no object with the requested DSN exists yet.

IMPORTANT: In order for MDB2 to work properly it is necessary that you make sure that you work with a reference of the original object instead of a copy (this is a PHP4 quirk).

For example: $db =& MDB2::singleton($dsn); ^^ And not: $db = MDB2::singleton($dsn); ^^

Parameters

mixed	'data source name', see the MDB2::parseDSN method for a description of the dsn format. Can also be specified as an array of the format returned by MDB2::parseDSN.
array	An associative array of option names and their values.

Returns: mixed a newly created MDB2 connection object, or a MDB2 error object on error

@access public

See also: MDB2::parseDSN

Definition at line 486 of file MDB2.php.

    {
        if ($dsn) {
            $dsninfo = MDB2::parseDSN($dsn);
            $dsninfo = array_merge($GLOBALS['_MDB2_dsninfo_default'], $dsninfo);
            $keys = array_keys($GLOBALS['_MDB2_databases']);
            for ($i=0, $j=count($keys); $i<$j; ++$i) {
                if (isset($GLOBALS['_MDB2_databases'][$keys[$i]])) {
                    $tmp_dsn = $GLOBALS['_MDB2_databases'][$keys[$i]]->getDSN('array');
                    if (count(array_diff_assoc($tmp_dsn, $dsninfo)) == 0) {
                        MDB2::setOptions($GLOBALS['_MDB2_databases'][$keys[$i]], $options);
                        return $GLOBALS['_MDB2_databases'][$keys[$i]];
                    }
                }
            }
        } elseif (is_array($GLOBALS['_MDB2_databases']) && reset($GLOBALS['_MDB2_databases'])) {
            $db =& $GLOBALS['_MDB2_databases'][key($GLOBALS['_MDB2_databases'])];
            return $db;
        }
        $db =& MDB2::factory($dsn, $options);
        return $db;
    }

References $GLOBALS, $i, $keys, $options, factory(), parseDSN(), and setOptions().

Here is the call graph for this function:

The documentation for this class was generated from the following file:

Services/Database/lib/PEAR/MDB2.php

Public Member Functions

Static Public Member Functions

Detailed Description

Member Function Documentation

◆ apiVersion()

◆ classExists()

◆ connect()

◆ errorMessage()

◆ factory()

◆ fileExists()

◆ isConnection()

◆ isError()

◆ isResult()

◆ isResultCommon()

◆ isStatement()

◆ loadClass()

◆ loadFile()

◆ parseDSN()

◆ raiseError()

◆ setOptions()

◆ singleton()