Inheritance diagram for ilDBInterface:

Collaboration diagram for ilDBInterface:

Public Member Functions
	doesCollationSupportMB4Strings ()

	sanitizeMB4StringIfNotSupported ($query)

	initFromIniFile ($tmpClientIniFile=null)

	connect ($return_false_on_error=false)

	nextId ($table_name)

	createTable ($table_name, $fields, $drop_table=false, $ignore_erros=false)

	addPrimaryKey ($table_name, $primary_keys)

	createSequence ($table_name, $start=1)

	getSequenceName ($table_name)

	tableExists ($table_name)

	tableColumnExists ($table_name, $column_name)

	addTableColumn ($table_name, $column_name, $attributes)

	dropTable ($table_name, $error_if_not_existing=true)

	renameTable ($old_name, $new_name)

	query ($query)

	fetchAll ($query_result, $fetch_mode=ilDBConstants::FETCHMODE_ASSOC)

	dropSequence ($table_name)

	dropTableColumn ($table_name, $column_name)

	renameTableColumn ($table_name, $column_old_name, $column_new_name)

	insert ($table_name, $values)

	fetchObject ($query_result)

	update ($table_name, $values, $where)

	manipulate ($query)

	fetchAssoc ($query_result)

	numRows ($query_result)

	quote ($value, $type)

	addIndex ($table_name, $fields, $index_name='', $fulltext=false)

	indexExistsByFields ($table_name, $fields)

	getDSN ()
	Get DSN. More...

	getDBType ()
	Get DSN. More...

	lockTables ($tables)
	Abstraction of lock table. More...

	unlockTables ()
	Unlock tables locked by previous lock table calls. More...

	in ($field, $values, $negate=false, $type="")

	queryF ($query, $types, $values)

	manipulateF ($query, $types, $values)

	useSlave ($bool)
	Return false iff slave is not supported. More...

	setLimit ($limit, $offset)

	like ($column, $type, $value="?", $case_insensitive=true)
	Generate a like subquery. More...

	now ()

	replace ($table, $primaryKeys, $otherColumns)
	Replace into method. More...

	equals ($columns, $value, $type, $emptyOrNull=false)

	setDBUser ($user)

	setDBPort ($port)

	setDBPassword ($password)

	setDBHost ($host)

	upper ($a_exp)

	lower ($a_exp)

	substr ($a_exp)

	prepareManip ($a_query, $a_types=null)

	enableResultBuffering ($a_status)

	execute ($stmt, $data=array())

	sequenceExists ($sequence)

	listSequences ()

	supports ($feature)

	supportsFulltext ()

	supportsSlave ()

	supportsTransactions ()

	listTables ()

	loadModule ($module)

	getAllowedAttributes ()

	concat (array $values, $allow_null=true)

	locate ($a_needle, $a_string, $a_start_pos=1)

	quoteIdentifier ($identifier, $check_option=false)

	modifyTableColumn ($table, $column, $attributes)

	free ($a_st)

	checkTableName ($a_name)

	beginTransaction ()

	commit ()

	rollback ()

	constraintName ($a_table, $a_constraint)

	dropIndex ($a_table, $a_name="i1")

	createDatabase ($a_name, $a_charset="utf8", $a_collation="")

	dropIndexByFields ($table_name, $afields)

	getPrimaryKeyIdentifier ()

	addFulltextIndex ($table_name, $afields, $a_name='in')

	dropFulltextIndex ($a_table, $a_name)

	isFulltextIndex ($a_table, $a_name)

	setStorageEngine ($storage_engine)

	getStorageEngine ()

	buildAtomQuery ()

	groupConcat ($a_field_name, $a_seperator=",", $a_order=NULL)

	cast ($a_field_name, $a_dest_type)

Static Public Member Functions
static	getReservedWords ()
	Get reserved words. More...

static	isReservedWord ($a_word)

Detailed Description

Interface ilDBInterface.

Author: Oskar Truffer ot@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch; Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 9 of file interface.ilDBInterface.php.

Member Function Documentation

◆ addFulltextIndex()

ilDBInterface::addFulltextIndex	(	$table_name,
		$afields,
		$a_name = `'in'`
	)

Parameters

	$table_name
	$afields
string	$a_name

Returns: bool

Implemented in ilDB, ilDBMySQL, ilDBPdo, and ilDBPdoMySQLInnoDB.

◆ addIndex()

ilDBInterface::addIndex	(	$table_name,
		$fields,
		$index_name = `''`,
		$fulltext = `false`
	)

Parameters

	$table_name
	$fields
string	$index_name
bool	$fulltext

Returns: bool

Implemented in ilDBPdo, and ilDBPdoPostgreSQL.

Referenced by ilMySQLAbstraction\addIndices().

Here is the caller graph for this function:

◆ addPrimaryKey()

ilDBInterface::addPrimaryKey	(	$table_name,
		$primary_keys
	)

Parameters

$table_name	string
$primary_keys	array

Implemented in ilDB, ilDBPdo, and ilDBPdoPostgreSQL.

Referenced by ilMySQLAbstraction\addPrimaryKey().

Here is the caller graph for this function:

◆ addTableColumn()

ilDBInterface::addTableColumn	(	$table_name,
		$column_name,
		$attributes
	)

Parameters

$table_name	string
$column_name	string
$attributes	array

Implemented in ilDB, and ilDBPdo.

◆ beginTransaction()

ilDBInterface::beginTransaction ( )

Returns: bool

Exceptions

ilDatabaseException

Implemented in ilDB, and ilDBPdo.

◆ buildAtomQuery()

ilDBInterface::buildAtomQuery ( )

Returns: \ilAtomQuery

Implemented in ilDB, ilDBPdo, and ilDBPdoMySQLGalera.

◆ cast()

ilDBInterface::cast	(	$a_field_name,
		$a_dest_type
	)

Parameters

string	$a_field_name
string	$a_dest_type

Returns: string;

Implemented in ilDB, and ilDBPdo.

◆ checkTableName()

ilDBInterface::checkTableName ( $a_name )

Parameters

$a_name

Returns: bool

Implemented in ilDB, and ilDBPdo.

◆ commit()

ilDBInterface::commit ( )

Returns: bool

Exceptions

ilDatabaseException

Implemented in ilDB, and ilDBPdo.

◆ concat()

ilDBInterface::concat	(	array	$values,
			$allow_null = `true`
	)

Parameters

array	$values
bool	$allow_null

Returns: mixed

Implemented in ilDB, ilDBOracle, and ilDBPdo.

◆ connect()

ilDBInterface::connect ( $return_false_on_error = false )

Parameters

bool $return_false_on_error

Returns: mixed

Implemented in ilDB, ilDBPdo, and ilDBPdoPostgreSQL.

Referenced by ilDatabaseBaseTest\connect(), ilDatabaseImplementationBaseTest\connect(), ilDbSetup\createDatabase(), ilDbSetup\installDatabase(), ilDbSetup\isConnectable(), and ilDbSetup\isDatabaseConnectable().

Here is the caller graph for this function:

◆ constraintName()

ilDBInterface::constraintName	(	$a_table,
		$a_constraint
	)

Parameters

$a_table
$a_constraint

Returns: string

Implemented in ilDB, ilDBOracle, ilDBPostgreSQL, ilDBPdo, and ilDBPdoPostgreSQL.

◆ createDatabase()

ilDBInterface::createDatabase	(	$a_name,
		$a_charset = `"utf8"`,
		$a_collation = `""`
	)

Parameters

	$a_name
string	$a_charset
string	$a_collation

Returns: mixed

Implemented in ilDB, and ilDBPdo.

Referenced by ilDbSetup\createDatabase().

Here is the caller graph for this function:

◆ createSequence()

ilDBInterface::createSequence	(	$table_name,
		$start = `1`
	)

Parameters

	$table_name
int	$start

Implemented in ilDB, ilDBPdo, and ilDBPdoPostgreSQL.

Referenced by ilMySQLAbstraction\addAutoIncrementSequence().

Here is the caller graph for this function:

◆ createTable()

ilDBInterface::createTable	(	$table_name,
		$fields,
		$drop_table = `false`,
		$ignore_erros = `false`
	)

Parameters

	$table_name
	$fields
bool	$drop_table
bool	$ignore_erros

Returns: mixed

Implemented in ilDB, ilDBPdo, and ilDBPdoPostgreSQL.

◆ doesCollationSupportMB4Strings()

ilDBInterface::doesCollationSupportMB4Strings ( )

Returns: bool

Implemented in ilDB, ilDBPdo, and ilDBPdoMySQL.

◆ dropFulltextIndex()

ilDBInterface::dropFulltextIndex	(	$a_table,
		$a_name
	)

Parameters

$a_table
$a_name

Returns: bool

Implemented in ilDBMySQL, ilDBOracle, ilDBPostgreSQL, and ilDBPdo.

Referenced by ilDB\dropIndex().

Here is the caller graph for this function:

◆ dropIndex()

ilDBInterface::dropIndex	(	$a_table,
		$a_name = `"i1"`
	)

Parameters

	$a_table
string	$a_name

Returns: bool

Implemented in ilDBPdo, and ilDB.

Referenced by ilMySQLAbstraction\fixIndexNames().

Here is the caller graph for this function:

◆ dropIndexByFields()

ilDBInterface::dropIndexByFields	(	$table_name,
		$afields
	)

Parameters

$table_name
$afields

Returns: bool

Implemented in ilDB, and ilDBPdo.

◆ dropSequence()

ilDBInterface::dropSequence ( $table_name )

Parameters

$table_name string

Implemented in ilDB, and ilDBPdo.

◆ dropTable()

ilDBInterface::dropTable	(	$table_name,
		$error_if_not_existing = `true`
	)

Parameters

	$table_name
bool	$error_if_not_existing

Returns: bool

Implemented in ilDB, ilDBPdoPostgreSQL, and ilDBPdo.

◆ dropTableColumn()

ilDBInterface::dropTableColumn	(	$table_name,
		$column_name
	)

Parameters

$table_name	string
$column_name	string

Implemented in ilDB, and ilDBPdo.

◆ enableResultBuffering()

ilDBInterface::enableResultBuffering ( $a_status )

Parameters

$a_status

Implemented in ilDB, and ilDBPdo.

◆ equals()

ilDBInterface::equals	(	$columns,
		$value,
		$type,
		$emptyOrNull = `false`
	)

Parameters

	$columns
	$value
	$type
bool	$emptyOrNull

Returns: string

Implemented in ilDB, and ilDBPdo.

◆ execute()

ilDBInterface::execute	(	$stmt,
		$data = `array()`
	)

Parameters

	$stmt
array	$data

Exceptions

ilDatabaseException

Returns: ilDBStatement

Implemented in ilDB.

Referenced by ilDBPdo\autoExecute(), ilDbSetup\readDumpUltraSmall(), ilMySQLAbstraction\storeStep(), and ilDBPdo\update().

Here is the caller graph for this function:

◆ fetchAll()

ilDBInterface::fetchAll	(	$query_result,
		$fetch_mode = `ilDBConstants::FETCHMODE_ASSOC`
	)

Parameters

	$query_result
int	$fetch_mode

Returns: array

◆ fetchAssoc()

ilDBInterface::fetchAssoc ( $query_result )

Parameters

$query_result ilDBStatement

Returns: mixed

Implemented in ilDB, and ilDBPdo.

Referenced by ilMySQLAbstraction\addAutoIncrementSequence().

Here is the caller graph for this function:

◆ fetchObject()

ilDBInterface::fetchObject ( $query_result )

Parameters

$query_result PDOStatement

Returns: mixed|null

Implemented in ilDB, and ilDBPdo.

◆ free()

ilDBInterface::free ( $a_st )

Parameters

$a_st

Returns: mixed

Implemented in ilDB.

Referenced by ilDBPdo\autoExecute(), and ilDBPdo\update().

Here is the caller graph for this function:

◆ getAllowedAttributes()

ilDBInterface::getAllowedAttributes ( )

Returns: array

Implemented in ilDB, and ilDBPdo.

◆ getDBType()

ilDBInterface::getDBType ( )

Get DSN.

This must be overwritten in DBMS specific class.

Implemented in ilDB, ilDBInnoDB, ilDBMySQL, ilDBOracle, ilDBPostgreSQL, and ilDBPdo.

Referenced by ilDbSetup\createDatabase(), ilDbSetup\installDatabase(), and ilDbSetup\isConnectable().

Here is the caller graph for this function:

◆ getDSN()

ilDBInterface::getDSN ( )

Get DSN.

Parameters

int $fetchMode

Returns: mixed This must be overwritten in DBMS specific class.

Implemented in ilDB, ilDBMySQL, ilDBOracle, ilDBPostgreSQL, and ilDBPdo.

◆ getPrimaryKeyIdentifier()

ilDBInterface::getPrimaryKeyIdentifier ( )

Returns: string

Implemented in ilDB, ilDBOracle, ilDBPostgreSQL, ilDBPdo, and ilDBPdoPostgreSQL.

◆ getReservedWords()

static ilDBInterface::getReservedWords ( )

static

Get reserved words.

This must be overwritten in DBMS specific class. This is mainly used to check whether a new identifier can be problematic because it is a reserved word. So createTable / alterTable usually check these.

Implemented in ilDB, ilDBMySQL, ilDBOracle, and ilDBPostgreSQL.

◆ getSequenceName()

ilDBInterface::getSequenceName ( $table_name )

Parameters

$table_name

Returns: string

Implemented in ilDB, and ilDBPdo.

◆ getStorageEngine()

ilDBInterface::getStorageEngine ( )

Returns: string

Implemented in ilDBInnoDB, ilDBMySQL, ilDBOracle, ilDBPostgreSQL, ilDBPdo, and ilDBPdoPostgreSQL.

◆ groupConcat()

ilDBInterface::groupConcat	(	$a_field_name,
		$a_seperator = `","`,
		$a_order = `NULL`
	)

Parameters

string	$a_field_name
string	$a_seperator
string	$a_order

Returns: string

Implemented in ilDBMySQL, ilDBPostgreSQL, and ilDBPdo.

◆ in()

ilDBInterface::in	(	$field,
		$values,
		$negate = `false`,
		$type = `""`
	)

Parameters

	$field	string
	$values	array
bool	$negate
string	$type

Returns: string

Implemented in ilDB, ilDBOracle, and ilDBPdo.

◆ indexExistsByFields()

ilDBInterface::indexExistsByFields	(	$table_name,
		$fields
	)

Parameters

$table_name
$fields

Returns: mixed

Implemented in ilDB, and ilDBPdo.

◆ initFromIniFile()

ilDBInterface::initFromIniFile ( $tmpClientIniFile = null )

Parameters

null $tmpClientIniFile

Implemented in ilDB, ilDBMySQL, and ilDBPdo.

Referenced by ilDbSetup\__construct(), ilDatabaseBaseTest\connect(), ilDatabaseImplementationBaseTest\connect(), and ilDbSetup\createDatabase().

Here is the caller graph for this function:

◆ insert()

ilDBInterface::insert	(	$table_name,
		$values
	)

Parameters

$table_name	string
$values

Returns: int|void

Implemented in ilDB, and ilDBPdo.

◆ isFulltextIndex()

ilDBInterface::isFulltextIndex	(	$a_table,
		$a_name
	)

Parameters

$a_table
$a_name

Returns: bool

Implemented in ilDB, ilDBMySQL, and ilDBPdo.

◆ isReservedWord()

static ilDBInterface::isReservedWord ( $a_word )

static

Parameters

$a_word

Returns: bool

Implemented in ilDB, and ilDBPdo.

Referenced by ilDatabaseReservedWordsTest\testReservedPDO().

Here is the caller graph for this function:

◆ like()

ilDBInterface::like	(	$column,
		$type,
		$value = `"?"`,
		$case_insensitive = `true`
	)

Generate a like subquery.

Parameters

string	$column
string	$type
mixed	$value
bool	$case_insensitive

Returns: string

Implemented in ilDB, ilDBOracle, and ilDBPdo.

◆ listSequences()

ilDBInterface::listSequences ( )

Returns: array

Implemented in ilDB, and ilDBPdo.

◆ listTables()

ilDBInterface::listTables ( )

Returns: array

Implemented in ilDB, and ilDBPdo.

Referenced by ilDbSetup\dropTables(), and ilDbSetup\isDatabaseInstalled().

Here is the caller graph for this function:

◆ loadModule()

ilDBInterface::loadModule ( $module )

Parameters

$module

Returns: ilDBReverse|ilDBManager

Implemented in ilDBMySQL, ilDBOracle, ilDBPostgreSQL, and ilDBPdo.

◆ locate()

ilDBInterface::locate	(	$a_needle,
		$a_string,
		$a_start_pos = `1`
	)

Parameters

	$a_needle
	$a_string
int	$a_start_pos

Returns: mixed

Implemented in ilDB, ilDBOracle, and ilDBPdo.

◆ lockTables()

ilDBInterface::lockTables ( $tables )

Abstraction of lock table.

Deprecated:: Use ilAtomQuery instead

Parameters

array table definitions

Returns

Implemented in ilDB, ilDBMySQL, ilDBOracle, ilDBPostgreSQL, ilDBPdoPostgreSQL, and ilDBPdo.

◆ lower()

ilDBInterface::lower ( $a_exp )

Parameters

$a_exp

Returns: string

Implemented in ilDB, and ilDBPdo.

◆ manipulate()

ilDBInterface::manipulate ( $query )

Parameters

$query string

Returns: int|void

Implemented in ilDBPdo, and ilDB.

Referenced by ilDbSetup\dropTables(), and ilDbSetup\readDumpSmall().

Here is the caller graph for this function:

◆ manipulateF()

ilDBInterface::manipulateF	(	$query,
		$types,
		$values
	)

Parameters

$query	string
$types	string[]
$values	mixed[]

Returns: string

Implemented in ilDB, and ilDBPdo.

◆ modifyTableColumn()

ilDBInterface::modifyTableColumn	(	$table,
		$column,
		$attributes
	)

Parameters

$table
$column
$attributes

Returns: bool

Implemented in ilDB, and ilDBPdo.

Referenced by ilMySQLAbstraction\fixClobNotNull(), ilMySQLAbstraction\fixDatetimeValues(), and ilMySQLAbstraction\removeAutoIncrement().

Here is the caller graph for this function:

◆ nextId()

ilDBInterface::nextId ( $table_name )

Parameters

$table_name string

Returns: int

Implemented in ilDB, ilDBPdo, ilDBPdoMySQL, and ilDBPdoPostgreSQL.

◆ now()

ilDBInterface::now ( )

Returns: string the now statement

Implemented in ilDB, ilDBMySQL, ilDBOracle, ilDBPostgreSQL, and ilDBPdo.

◆ numRows()

ilDBInterface::numRows ( $query_result )

Parameters

$query_result PDOStatement

Returns: int

Implemented in ilDB, and ilDBPdo.

◆ prepareManip()

ilDBInterface::prepareManip	(	$a_query,
		$a_types = `null`
	)

Parameters

	$a_query
null	$a_types

Returns: ilDBStatement

Implemented in ilDB, and ilDBPdo.

Referenced by ilDbSetup\readDumpUltraSmall(), and ilMySQLAbstraction\storeStep().

Here is the caller graph for this function:

◆ query()

ilDBInterface::query ( $query )

Parameters

$query string

Returns: \ilPDOStatement

Implemented in ilDBPdo.

Referenced by ilMySQLAbstraction\addAutoIncrementSequence(), ilDbSetup\readDump(), ilMySQLAbstraction\removeConstraints(), and ilMySQLAbstraction\removeIndices().

Here is the caller graph for this function:

◆ queryF()

ilDBInterface::queryF	(	$query,
		$types,
		$values
	)

Parameters

$query	string
$types	string[]
$values	mixed[]

Returns: \ilDBStatement

Implemented in ilDB, and ilDBPdo.

◆ quote()

ilDBInterface::quote	(	$value,
		$type
	)

Parameters

$value
$type

Returns: string

Implemented in ilDB, and ilDBPdo.

◆ quoteIdentifier()

ilDBInterface::quoteIdentifier	(	$identifier,
		$check_option = `false`
	)

Parameters

	$identifier
bool	$check_option

Returns: string

Implemented in ilDB, ilDBPdo, and ilDBPdoPostgreSQL.

◆ renameTable()

ilDBInterface::renameTable	(	$old_name,
		$new_name
	)

Parameters

$old_name
$new_name

Returns: mixed

Implemented in ilDB, ilDBPdo, and ilDBPdoPostgreSQL.

◆ renameTableColumn()

ilDBInterface::renameTableColumn	(	$table_name,
		$column_old_name,
		$column_new_name
	)

Parameters

$table_name	string
$column_old_name	string
$column_new_name	string

Implemented in ilDB, and ilDBPdo.

◆ replace()

ilDBInterface::replace	(	$table,
		$primaryKeys,
		$otherColumns
	)

Replace into method.

Parameters

string	table name
array	primary key values: array("field1" => array("text", $name), "field2" => ...)
array	other values: array("field1" => array("text", $name), "field2" => ...)

Implemented in ilDB, ilDBOracle, ilDBPostgreSQL, ilDBPdoPostgreSQL, and ilDBPdo.

◆ rollback()

ilDBInterface::rollback ( )

Returns: bool

Exceptions

ilDatabaseException

Implemented in ilDB, and ilDBPdo.

◆ sanitizeMB4StringIfNotSupported()

ilDBInterface::sanitizeMB4StringIfNotSupported ( $query )

Parameters

$query string to sanitize, all MB4-Characters like emojis will re replaced with ???

Returns: string sanitized query

Implemented in ilDB, and ilDBPdo.

◆ sequenceExists()

ilDBInterface::sequenceExists ( $sequence )

Parameters

$sequence

Returns: mixed

Implemented in ilDB, and ilDBPdo.

◆ setDBHost()

ilDBInterface::setDBHost ( $host )

Parameters

$host

Implemented in ilDB, and ilDBPdo.

◆ setDBPassword()

ilDBInterface::setDBPassword ( $password )

Parameters

$password

Implemented in ilDB, and ilDBPdo.

◆ setDBPort()

ilDBInterface::setDBPort ( $port )

Parameters

$port

Implemented in ilDB, and ilDBPdo.

◆ setDBUser()

ilDBInterface::setDBUser ( $user )

Parameters

$user

Implemented in ilDB, and ilDBPdo.

◆ setLimit()

ilDBInterface::setLimit	(	$limit,
		$offset
	)

Parameters

$limit
$offset

Implemented in ilDB, and ilDBPdo.

◆ setStorageEngine()

ilDBInterface::setStorageEngine ( $storage_engine )

Parameters

$storage_engine

Implemented in ilDBMySQL, ilDBOracle, ilDBPostgreSQL, ilDBPdo, and ilDBPdoPostgreSQL.

◆ substr()

ilDBInterface::substr ( $a_exp )

Parameters

$a_exp

Returns: string

◆ supports()

ilDBInterface::supports ( $feature )

Parameters

$feature

Returns: bool

Implemented in ilDB, and ilDBPdo.

◆ supportsFulltext()

ilDBInterface::supportsFulltext ( )

Returns: bool

Implemented in ilDB, ilDBInnoDB, ilDBMySQL, ilDBOracle, ilDBPostgreSQL, ilDBPdo, ilDBPdoMySQLInnoDB, ilDBPdoMySQLMyISAM, and ilDBPdoPostgreSQL.

◆ supportsSlave()

ilDBInterface::supportsSlave ( )

Returns: bool

Implemented in ilDB, ilDBMySQL, and ilDBPdo.

◆ supportsTransactions()

ilDBInterface::supportsTransactions ( )

Returns: bool

Implemented in ilDB, ilDBPdo, ilDBPdoMySQL, ilDBPdoMySQLGalera, ilDBPdoMySQLInnoDB, and ilDBPdoPostgreSQL.

◆ tableColumnExists()

ilDBInterface::tableColumnExists	(	$table_name,
		$column_name
	)

Parameters

$table_name	string
$column_name	string

Returns: bool

Implemented in ilDB, ilDBPdo, and ilDBPdoPostgreSQL.

◆ tableExists()

ilDBInterface::tableExists ( $table_name )

Parameters

$table_name string

Returns: bool

Implemented in ilDB, ilDBPdo, and ilDBPdoPostgreSQL.

Referenced by ilMySQLAbstraction\fixClobNotNull(), ilMySQLAbstraction\fixDatetimeValues(), ilMySQLAbstraction\fixIndexNames(), and ilMySQLAbstraction\replaceEmptyDatesWithNull().

Here is the caller graph for this function:

◆ unlockTables()

ilDBInterface::unlockTables ( )

Unlock tables locked by previous lock table calls.

Deprecated:: Use ilAtomQuery instead

Returns

Implemented in ilDB, ilDBMySQL, ilDBOracle, ilDBPostgreSQL, ilDBPdo, and ilDBPdoPostgreSQL.

◆ update()

ilDBInterface::update	(	$table_name,
		$values,
		$where
	)

Parameters

$table_name	string
$values	array
$where	array

Returns: int|void

Implemented in ilDB, and ilDBPdo.

◆ upper()

ilDBInterface::upper ( $a_exp )

Parameters

$a_exp

Returns: string

Implemented in ilDB, and ilDBPdo.

◆ useSlave()

ilDBInterface::useSlave ( $bool )

Return false iff slave is not supported.

Parameters

$bool

Returns: bool

Implemented in ilDB, and ilDBPdo.

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

Services/Database/interfaces/interface.ilDBInterface.php

Public Member Functions

Static Public Member Functions

Detailed Description

Member Function Documentation

◆ addFulltextIndex()

◆ addIndex()

◆ addPrimaryKey()

◆ addTableColumn()

◆ beginTransaction()

◆ buildAtomQuery()

◆ cast()

◆ checkTableName()

◆ commit()

◆ concat()

◆ connect()

◆ constraintName()

◆ createDatabase()

◆ createSequence()

◆ createTable()

◆ doesCollationSupportMB4Strings()

◆ dropFulltextIndex()

◆ dropIndex()

◆ dropIndexByFields()

◆ dropSequence()

◆ dropTable()

◆ dropTableColumn()

◆ enableResultBuffering()

◆ equals()

◆ execute()

◆ fetchAll()

◆ fetchAssoc()

◆ fetchObject()

◆ free()

◆ getAllowedAttributes()

◆ getDBType()

◆ getDSN()

◆ getPrimaryKeyIdentifier()

◆ getReservedWords()

◆ getSequenceName()

◆ getStorageEngine()

◆ groupConcat()

◆ in()

◆ indexExistsByFields()

◆ initFromIniFile()

◆ insert()

◆ isFulltextIndex()

◆ isReservedWord()

◆ like()

◆ listSequences()

◆ listTables()

◆ loadModule()

◆ locate()

◆ lockTables()

◆ lower()

◆ manipulate()

◆ manipulateF()

◆ modifyTableColumn()

◆ nextId()

◆ now()

◆ numRows()

◆ prepareManip()

◆ query()

◆ queryF()

◆ quote()

◆ quoteIdentifier()

◆ renameTable()

◆ renameTableColumn()

◆ replace()

◆ rollback()

◆ sanitizeMB4StringIfNotSupported()

◆ sequenceExists()

◆ setDBHost()

◆ setDBPassword()

◆ setDBPort()

◆ setDBUser()

◆ setLimit()

◆ setStorageEngine()

◆ substr()

◆ supports()

◆ supportsFulltext()