ilDBPdo Class Reference

Inheritance diagram for ilDBPdo:

Collaboration diagram for ilDBPdo:

Public Member Functions
	__construct (private readonly Details $details)
	connect (bool $return_false_for_error=false)
	initHelpers ()
	getFieldDefinition ()
	setFieldDefinition (FieldDefinition $field_definition)
	createDatabase (string $a_name, string $a_charset="utf8", string $a_collation="")
	getLastErrorCode ()
	initFromIniFile (?ilIniFile $ini=null)
	generateDSN ()
	quoteIdentifier (string $identifier, bool $check_option=false)
	nextId (string $table_name)
	createTable (string $table_name, array $fields, bool $drop_table=false, bool $ignore_erros=false)
	checkColumnName (string $a_name)
	addPrimaryKey (string $table_name, array $primary_keys)
	dropIndexByFields (string $table_name, array $fields)
	getPrimaryKeyIdentifier ()
	createSequence (string $table_name, int $start=1)
	tableExists (string $table_name)
	tableColumnExists (string $table_name, string $column_name)
	addTableColumn (string $table_name, string $column_name, array $attributes)
	dropTable (string $table_name, bool $error_if_not_existing=true)
	query (string $query)
	fetchAll (ilDBStatement $statement, int $fetch_mode=ilDBConstants::FETCHMODE_ASSOC)
	dropSequence (string $table_name)
	dropTableColumn (string $table_name, string $column_name)
	renameTableColumn (string $table_name, string $column_old_name, string $column_new_name)
	insert (string $table_name, array $values)
	fetchObject (ilDBStatement $query_result)
	update (string $table_name, array $columns, array $where)
	@description $where MUST contain existing columns only. More...
	manipulate (string $query)
	fetchAssoc (ilDBStatement $statement)
	numRows (ilDBStatement $statement)
	quote ($value, ?string $type=null)
	indexExistsByFields (string $table_name, array $fields)
	addIndex (string $table_name, array $fields, string $index_name='', bool $fulltext=false)
	addFulltextIndex (string $table_name, array $fields, string $name='in')
	dropFulltextIndex (string $a_table, string $a_name)
	Drop fulltext index. More...
	isFulltextIndex (string $a_table, string $a_name)
	Is index a fulltext index? More...
	getIndexName (string $index_name_base)
	getSequenceName (string $table_name)
	constraintName (string $a_table, string $a_constraint)
	Determine contraint name by table name and constraint name. More...
	getDSN ()
	Get DSN. More...
	getDBType ()
	Get DSN. More...
	setDBType (string $type)
	lockTables (array $tables)
	unlockTables ()
	in (string $field, array $values, bool $negate=false, string $type="")
	queryF (string $query, array $types, array $values)
	manipulateF (string $query, array $types, array $values)
	useSlave (bool $bool)
	setLimit (int $limit, int $offset=0)
	Set the Limit for the next Query. More...
	like (string $column, string $type, string $value="?", bool $case_insensitive=true)
	now ()
	replace (string $table, array $primary_keys, array $other_columns)
	Replace into method. More...
	equals (string $columns, $value, string $type, bool $emptyOrNull=false)
	getHost ()
	setHost (string $host)
	getDbname ()
	setDbname (string $dbname)
	getCharset ()
	setCharset (string $charset)
	getUsername ()
	setUsername (string $username)
	getPassword ()
	setPassword (string $password)
	getPort ()
	setPort (int $port)
	setDBUser (string $user)
	setDBPort (int $port)
	setDBPassword (string $password)
	setDBHost (string $host)
	upper (string $expression)
	lower (string $expression)
	substr (string $a_exp, int $a_pos=1, int $a_len=-1)
	prepareManip (string $query, ?array $types=null)
	prepare (string $query, ?array $types=null, ?array $result_types=null)
	Prepare a query (SELECT) statement to be used with execute. More...
	enableResultBuffering (bool $a_status)
	execute (ilDBStatement $stmt, array $data=[])
	supportsSlave ()
	supportsFulltext ()
	supportsTransactions ()
	supports (string $feature)
	listTables ()
	loadModule (string $module)
	getAllowedAttributes ()
	sequenceExists (string $sequence)
	listSequences ()
	concat (array $values, bool $allow_null=true)
	locate (string $needle, string $string, int $start_pos=1)
	modifyTableColumn (string $table, string $column, array $attributes)
	free (ilDBStatement $a_st)
	renameTable (string $name, string $new_name)
	checkTableName (string $a_name)
	beginTransaction ()
	commit ()
	rollback ()
	dropIndex (string $a_table, string $a_name="i1")
	setStorageEngine (string $storage_engine)
	getStorageEngine ()
	queryCol (string $query, int $type=PDO::FETCH_ASSOC, int $colnum=0)
	queryRow (string $query, ?array $types=null, int $fetchmode=ilDBConstants::FETCHMODE_DEFAULT)
	getServerVersion (bool $native=false)
	escape (string $value, bool $escape_wildcards=false)
	escapePattern (string $text)
	migrateAllTablesToEngine (string $engine=ilDBConstants::MYSQL_ENGINE_INNODB)
	migrateAllTablesToCollation (string $collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4)
	supportsCollationMigration ()
	supportsEngineMigration ()
	checkIndexName (string $name)
	addUniqueConstraint (string $table, array $fields, string $name="con")
	dropUniqueConstraint (string $table, string $name="con")
	dropUniqueConstraintByFields (string $table, array $fields)
	getLastInsertId ()
	buildAtomQuery ()
	uniqueConstraintExists (string $table, array $fields)
	dropPrimaryKey (string $table_name)
	executeMultiple (ilDBStatement $stmt, array $data)
	fromUnixtime (string $expr, bool $to_text=true)
	unixTimestamp ()
	getDBVersion ()
	sanitizeMB4StringIfNotSupported (string $query)
	doesCollationSupportMB4Strings ()
	groupConcat (string $a_field_name, string $a_seperator=",", ?string $a_order=null)
	cast (string $a_field_name, string $a_dest_type)
	addForeignKey (string $foreign_key_name, array $field_names, string $table_name, array $reference_field_names, string $reference_table, ?ForeignKeyConstraints $on_update=null, ?ForeignKeyConstraints $on_delete=null)
	dropForeignKey (string $foreign_key_name, string $table_name)
	foreignKeyExists (string $foreign_key_name, string $table_name)
	buildIntegrityAnalyser ()
	primaryExistsByFields (string $table_name, array $fields)
	migrateTableCollation (string $table_name, string $collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4)
	migrateTableToEngine (string $table_name, string $engine=ilDBConstants::MYSQL_ENGINE_INNODB)
	getFieldDefinition ()
	getIndexName (string $index_name_base)
Public Member Functions inherited from ilDBInterface
	doesCollationSupportMB4Strings ()
	sanitizeMB4StringIfNotSupported (string $query)
	initFromIniFile (?ilIniFile $ini=null)
	connect (bool $return_false_on_error=false)
	nextId (string $table_name)
	createTable (string $table_name, array $fields, bool $drop_table=false, bool $ignore_erros=false)
	addPrimaryKey (string $table_name, array $primary_keys)
	createSequence (string $table_name, int $start=1)
	getSequenceName (string $table_name)
	tableExists (string $table_name)
	tableColumnExists (string $table_name, string $column_name)
	addTableColumn (string $table_name, string $column_name, array $attributes)
	dropTable (string $table_name, bool $error_if_not_existing=true)
	renameTable (string $old_name, string $new_name)
	query (string $query)
	Run a (read-only) Query on the database. More...
	fetchAll (ilDBStatement $statement, int $fetch_mode=ilDBConstants::FETCHMODE_ASSOC)
	dropSequence (string $table_name)
	dropTableColumn (string $table_name, string $column_name)
	renameTableColumn (string $table_name, string $column_old_name, string $column_new_name)
	insert (string $table_name, array $values)
	fetchObject (ilDBStatement $query_result)
	update (string $table_name, array $values, array $where)
	@description $where MUST contain existing columns only. More...
	manipulate (string $query)
	Run a (write) Query on the database. More...
	fetchAssoc (ilDBStatement $statement)
	numRows (ilDBStatement $statement)
	quote ($value, string $type)
	addIndex (string $table_name, array $fields, string $index_name='', bool $fulltext=false)
	indexExistsByFields (string $table_name, array $fields)
	getDSN ()
	Get DSN. More...
	getDBType ()
	Get DSN. More...
	lockTables (array $tables)
	Abstraction of lock table. More...
	unlockTables ()
	Unlock tables locked by previous lock table calls. More...
	in (string $field, array $values, bool $negate=false, string $type="")
	queryF (string $query, array $types, array $values)
	manipulateF (string $query, array $types, array $values)
	useSlave (bool $bool)
	setLimit (int $limit, int $offset=0)
	like (string $column, string $type, string $value="?", bool $case_insensitive=true)
	Generate a like subquery. More...
	now ()
	replace (string $table, array $primary_keys, array $other_columns)
	Replace into method. More...
	equals (string $columns, $value, string $type, bool $emptyOrNull=false)
	setDBUser (string $user)
	setDBPort (int $port)
	setDBPassword (string $password)
	setDBHost (string $host)
	upper (string $expression)
	lower (string $expression)
	substr (string $expression)
	prepare (string $a_query, ?array $a_types=null, ?array $a_result_types=null)
	Prepare a query (SELECT) statement to be used with execute. More...
	prepareManip (string $a_query, ?array $a_types=null)
	enableResultBuffering (bool $a_status)
	execute (ilDBStatement $stmt, array $data=[])
	sequenceExists (string $sequence)
	listSequences ()
	supports (string $feature)
	supportsFulltext ()
	supportsSlave ()
	supportsTransactions ()
	listTables ()
	loadModule (string $module)
	getAllowedAttributes ()
	concat (array $values, bool $allow_null=true)
	locate (string $needle, string $string, int $start_pos=1)
	quoteIdentifier (string $identifier, bool $check_option=false)
	modifyTableColumn (string $table, string $column, array $attributes)
	free (ilDBStatement $a_st)
	checkTableName (string $a_name)
	beginTransaction ()
	commit ()
	rollback ()
	constraintName (string $a_table, string $a_constraint)
	dropIndex (string $a_table, string $a_name="i1")
	createDatabase (string $a_name, string $a_charset="utf8", string $a_collation="")
	dropIndexByFields (string $table_name, array $afields)
	getPrimaryKeyIdentifier ()
	addFulltextIndex (string $table_name, array $afields, string $a_name='in')
	dropFulltextIndex (string $a_table, string $a_name)
	isFulltextIndex (string $a_table, string $a_name)
	setStorageEngine (string $storage_engine)
	getStorageEngine ()
	buildAtomQuery ()
	groupConcat (string $a_field_name, string $a_seperator=",", ?string $a_order=null)
	cast (string $a_field_name, string $a_dest_type)
	addForeignKey (string $foreign_key_name, array $field_names, string $table_name, array $reference_field_names, string $reference_table, ?ForeignKeyConstraints $on_update=null, ?ForeignKeyConstraints $on_delete=null)
	dropForeignKey (string $foreign_key_name, string $table_name)
	foreignKeyExists (string $foreign_key_name, string $table_name)
	buildIntegrityAnalyser ()
	primaryExistsByFields (string $table_name, array $fields)
	getServerVersion (bool $native=false)
	queryCol (string $query, int $type=ilDBConstants::FETCHMODE_DEFAULT, int $colnum=0)
	queryRow (string $query, ?array $types=null, int $fetchmode=ilDBConstants::FETCHMODE_DEFAULT)
	escape (string $value, bool $escape_wildcards=false)
	escapePattern (string $text)
	migrateTableToEngine (string $table_name, string $engine=ilDBConstants::MYSQL_ENGINE_INNODB)
	migrateAllTablesToEngine (string $engine=ilDBConstants::MYSQL_ENGINE_INNODB)
	supportsEngineMigration ()
	migrateTableCollation (string $table_name, string $collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4)
	migrateAllTablesToCollation (string $collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4)
	supportsCollationMigration ()
	addUniqueConstraint (string $table, array $fields, string $name="con")
	dropUniqueConstraint (string $table, string $name="con")
	dropUniqueConstraintByFields (string $table, array $fields)
	checkIndexName (string $name)
	getLastInsertId ()
	uniqueConstraintExists (string $table, array $fields)
	dropPrimaryKey (string $table_name)
	executeMultiple (ilDBStatement $stmt, array $data)
	fromUnixtime (string $expr, bool $to_text=true)
	unixTimestamp ()
	getDBVersion ()
	returns the Version of the Database (e.g. More...

Static Public Member Functions
static	isReservedWord (string $a_word)
Static Public Member Functions inherited from ilDBInterface
static	getReservedWords ()
	Get reserved words. More...
static	isReservedWord (string $a_word)

Data Fields
array	$options = []
const	FEATURE_TRANSACTIONS = 'transactions'
const	FEATURE_FULLTEXT = 'fulltext'
const	FEATURE_SLAVE = 'slave'

Protected Member Functions
	getAttributes ()

Private Member Functions
	checkTableColumns (array $a_cols)
	checkColumn (string $a_col, array $a_def)
	checkColumnDefinition (array $a_def, bool $a_modify_mode=false)
	appendLimit (string $query)

Private Attributes
string	$host = ''
string	$dbname = ''
string	$charset = 'utf8'
string	$username = ''
string	$password = ''
int	$port = 3306
PDO	$pdo = null
ilDBManager	$manager
ilDBReverse	$reverse
int	$limit = null
int	$offset = null
string	$storage_engine = 'InnoDB'
string	$dsn = ''
string	$db_type = ''
int	$error_code = 0
FieldDefinition	$field_definition = null
const	SESSION_MODES

Detailed Description

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 31 of file ilDBPdo.php.

Constructor & Destructor Documentation

__construct()

ilDBPdo::__construct

(

private readonly Details

$details

)

Definition at line 66 of file ilDBPdo.php.

    {
    }

Member Function Documentation

addForeignKey()

ilDBPdo::addForeignKey	(	string	$foreign_key_name,
		array	$field_names,
		string	$table_name,
		array	$reference_field_names,
		string	$reference_table,
		?ForeignKeyConstraints	$on_update = null,
		?ForeignKeyConstraints	$on_delete = null
	)

Parameters

string[]	$field_names
string[]	$reference_field_names

Implements ilDBInterface.

Definition at line 1500 of file ilDBPdo.php.

     : bool {
        return $this->manager->addForeignKey($foreign_key_name, $field_names, $table_name, $reference_field_names, $reference_table, $on_update, $on_delete);
    }

addFulltextIndex()

ilDBPdo::addFulltextIndex	(	string	$table_name,
		array	$fields,
		string	$name = 'in'
	)

Implements ilDBInterface.

Definition at line 680 of file ilDBPdo.php.

                                                                                            : bool
    {
        return false;
    }

addIndex()

ilDBPdo::addIndex	(	string	$table_name,
		array	$fields,
		string	$index_name = '',
		bool	$fulltext = false
	)

Implements ilDBInterface.

Definition at line 658 of file ilDBPdo.php.

                                                                                                                : bool
    {
        $this->field_definition->checkIndexName($index_name);
 
        $definition_fields = [];
        foreach ($fields as $f) {
            $definition_fields[$f] = [];
        }
        $definition = [
            'fields' => $definition_fields,
        ];
 
        if (!$fulltext) {
            $this->manager->createIndex($table_name, $this->constraintName($table_name, $index_name), $definition);
        } elseif ($this->supportsFulltext()) {
            $this->addFulltextIndex($table_name, $fields, $index_name);
            // TODO
        }
 
        return true;
    }

References Vendor\Package\$f.

addPrimaryKey()

ilDBPdo::addPrimaryKey	(	string	$table_name,
		array	$primary_keys
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 262 of file ilDBPdo.php.

                                                                          : bool
    {
        $fields = [];
        foreach ($primary_keys as $f) {
            $fields[$f] = [];
        }
        $definition = [
            'primary' => true,
            'fields' => $fields,
        ];
        $this->manager->createConstraint(
            $table_name,
            $this->constraintName($table_name, $this->getPrimaryKeyIdentifier()),
            $definition
        );
 
        return true;
    }

References Vendor\Package\$f.

addTableColumn()

ilDBPdo::addTableColumn	(	string	$table_name,
		string	$column_name,
		array	$attributes
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 327 of file ilDBPdo.php.

                                                                                              : bool
    {
        if (!$this->checkColumnName($column_name)) {
            throw new ilDatabaseException("ilDB Error: addTableColumn(" . $table_name . ", " . $column_name . ")");
        }
        if (!$this->checkColumnDefinition($attributes)) {
            throw new ilDatabaseException("ilDB Error: addTableColumn(" . $table_name . ", " . $column_name . ")");
        }
 
        $changes = [
            "add" => [
                $column_name => $attributes,
            ],
        ];
 
        return $this->manager->alterTable($table_name, $changes, false);
    }

addUniqueConstraint()

ilDBPdo::addUniqueConstraint	(	string	$table,
		array	$fields,
		string	$name = "con"
	)

Exceptions

ilDatabaseException

Implements ilDBPdoInterface.

Definition at line 1345 of file ilDBPdo.php.

                                                                                           : bool
    {
        $manager = $this->manager;
 
        // check index name
        if (!$this->checkIndexName($name)) {
            throw new ilDatabaseException("ilDB Error: addUniqueConstraint(" . $table . "," . $name . ")");
        }
 
        $fields_corrected = [];
        foreach ($fields as $f) {
            $fields_corrected[$f] = [];
        }
        $definition = [
            'unique' => true,
            'fields' => $fields_corrected,
        ];
 
        return $manager->createConstraint($table, $this->constraintName($table, $name), $definition);
    }

References Vendor\Package\$f, and ilDBManager\createConstraint().

Here is the call graph for this function:

appendLimit()

ilDBPdo::appendLimit ( string  $query )

private

Definition at line 1079 of file ilDBPdo.php.

                                               : string
    {
        if ($this->limit !== null && $this->offset !== null) {
            $query .= ' LIMIT ' . $this->offset . ', ' . $this->limit;
            $this->limit = null;
            $this->offset = null;
 
            return $query;
        }
 
        return $query;
    }

beginTransaction()

ilDBPdo::beginTransaction

(

)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 1192 of file ilDBPdo.php.

                                      : bool
    {
        if (!$this->supports(self::FEATURE_TRANSACTIONS)) {
            throw new ilDatabaseException("ilDB::beginTransaction: Transactions are not supported.");
        }
 
        return $this->pdo->beginTransaction();
    }

buildAtomQuery()

ilDBPdo::buildAtomQuery

(

)

Implements ilDBInterface.

Definition at line 1397 of file ilDBPdo.php.

                                    : ilAtomQuery
    {
        return $this->details->atomQuery($this);
    }

buildIntegrityAnalyser()

ilDBPdo::buildIntegrityAnalyser

(

)

Implements ilDBInterface.

Definition at line 1522 of file ilDBPdo.php.

                                            : Integrity
    {
        return new Integrity($this);
    }

cast()

ilDBPdo::cast	(	string	$a_field_name,
		string	$a_dest_type
	)

Implements ilDBInterface.

Definition at line 1495 of file ilDBPdo.php.

                                                                   : string
    {
        return $a_field_name;
    }

checkColumn()

ilDBPdo::checkColumn ( string  $a_col, array  $a_def  )

private

Definition at line 241 of file ilDBPdo.php.

                                                             : bool
    {
        if (!$this->checkColumnName($a_col)) {
            return false;
        }
        return $this->checkColumnDefinition($a_def);
    }

checkColumnDefinition()

ilDBPdo::checkColumnDefinition ( array  $a_def, bool  $a_modify_mode = false  )

private

Definition at line 249 of file ilDBPdo.php.

                                                                                     : bool
    {
        return $this->field_definition->checkColumnDefinition($a_def);
    }

checkColumnName()

ilDBPdo::checkColumnName

(

string

$a_name

)

Definition at line 254 of file ilDBPdo.php.

                                                   : bool
    {
        return $this->field_definition->checkColumnName($a_name);
    }

checkIndexName()

ilDBPdo::checkIndexName

(

string

$name

)

Exceptions

ilDatabaseException

Implements ilDBPdoInterface.

Definition at line 1333 of file ilDBPdo.php.

                                                : bool
    {
        $fd = $this->getFieldDefinition();
        if ($fd !== null) {
            return $fd->checkIndexName($name);
        }
        return false;
    }

checkTableColumns()

ilDBPdo::checkTableColumns ( array  $a_cols )

private

Definition at line 230 of file ilDBPdo.php.

                                                     : bool
    {
        foreach ($a_cols as $col => $def) {
            if (!$this->checkColumn($col, $def)) {
                return false;
            }
        }
 
        return true;
    }

checkTableName()

ilDBPdo::checkTableName

(

string

$a_name

)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 1178 of file ilDBPdo.php.

                                                  : bool
    {
        return $this->field_definition->checkTableName($a_name);
    }

commit()

ilDBPdo::commit

(

)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 1204 of file ilDBPdo.php.

                            : bool
    {
        if (!$this->supports(self::FEATURE_TRANSACTIONS)) {
            throw new ilDatabaseException("ilDB::beginTransaction: Transactions are not supported.");
        }
 
        return $this->pdo->commit();
    }

concat()

ilDBPdo::concat	(	array	$values,
		bool	$allow_null = true
	)

Implements ilDBInterface.

Definition at line 1074 of file ilDBPdo.php.

                                                                  : string
    {
        return $this->manager->getQueryUtils()->concat($values, $allow_null);
    }

connect()

ilDBPdo::connect

(

bool

$return_false_for_error = false

)

Exceptions

Exception

Implements ilDBInterface.

Definition at line 73 of file ilDBPdo.php.

                                                                 : ?bool
    {
        $this->generateDSN();
        try {
            $options = $this->getAttributes();
            $this->pdo = new PDO($this->getDSN(), $this->getUsername(), $this->getPassword(), $options);
            $this->pdo->exec("SET SESSION sql_mode = '" . implode(",", self::SESSION_MODES) . "';");
            $this->manager = new ilDBPdoManager($this->pdo, $this);
            $this->reverse = new ilDBPdoReverse($this->pdo, $this);
            $this->field_definition = new ilDBPdoMySQLFieldDefinition($this);
        } catch (Exception $e) {
            $this->error_code = $e->getCode();
            if ($return_false_for_error) {
                return false;
            }
            throw $e;
        }
 
        return ($this->pdo->errorCode() === PDO::ERR_NONE);
    }

References Vendor\Package\$e, generateDSN(), getAttributes(), getDSN(), getPassword(), and getUsername().

Referenced by createDatabase().

Here is the call graph for this function:

Here is the caller graph for this function:

constraintName()

ilDBPdo::constraintName	(	string	$a_table,
		string	$a_constraint
	)

Determine contraint name by table name and constraint name.

In MySQL these are "unique" per table

Implements ilDBInterface.

Definition at line 724 of file ilDBPdo.php.

                                                                         : string
    {
        return $a_constraint;
    }

createDatabase()

ilDBPdo::createDatabase	(	string	$a_name,
		string	$a_charset = "utf8",
		string	$a_collation = ""
	)

Implements ilDBInterface.

Definition at line 120 of file ilDBPdo.php.

                                                                                                        : bool
    {
        $this->setDbname('');
        $this->generateDSN();
        $this->connect(true);
        try {
            $this->query($this->manager->getQueryUtils()->createDatabase($a_name, $a_charset, $a_collation));
            return true;
        } catch (PDOException) {
            return false;
        }
    }

References connect(), generateDSN(), query(), and setDbname().

Here is the call graph for this function:

createSequence()

ilDBPdo::createSequence	(	string	$table_name,
		int	$start = 1
	)

Implements ilDBInterface.

Definition at line 303 of file ilDBPdo.php.

                                                                      : bool
    {
        $this->manager->createSequence($table_name, $start);
        return true;
    }

createTable()

ilDBPdo::createTable	(	string	$table_name,
		array	$fields,
		bool	$drop_table = false,
		bool	$ignore_erros = false
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 207 of file ilDBPdo.php.

     : bool {
        // check table name
        if (!$ignore_erros && !$this->checkTableName($table_name)) {
            throw new ilDatabaseException("ilDB Error: createTable(" . $table_name . ")");
        }
 
        // check definition array
        if (!$ignore_erros && !$this->checkTableColumns($fields)) {
            throw new ilDatabaseException("ilDB Error: createTable(" . $table_name . ")");
        }
 
        if ($drop_table) {
            $this->dropTable($table_name, false);
        }
 
        return $this->manager->createTable($table_name, $fields, []);
    }

doesCollationSupportMB4Strings()

ilDBPdo::doesCollationSupportMB4Strings

(

)

Implements ilDBInterface.

Definition at line 1476 of file ilDBPdo.php.

                                                    : bool
    {
        // Currently ILIAS does not support utf8mb4, after that ilDB could check like this:
        //              static $supported;
        //              if (!isset($supported)) {
        //                      $q = "SELECT default_character_set_name FROM information_schema.SCHEMATA WHERE schema_name = %s;";
        //                      $res = $this->queryF($q, ['text'], [$this->getDbname()]);
        //                      $data = $this->fetchObject($res);
        //                      $supported = ($data->default_character_set_name === 'utf8mb4');
        //              }
 
        return false;
    }

dropForeignKey()

ilDBPdo::dropForeignKey	(	string	$foreign_key_name,
		string	$table_name
	)

Implements ilDBInterface.

Definition at line 1512 of file ilDBPdo.php.

                                                                                : bool
    {
        return $this->manager->dropForeignKey($foreign_key_name, $table_name);
    }

dropFulltextIndex()

ilDBPdo::dropFulltextIndex	(	string	$a_table,
		string	$a_name
	)

Drop fulltext index.

Implements ilDBInterface.

Definition at line 688 of file ilDBPdo.php.

                                                                      : bool
    {
        $i_name = $this->constraintName($a_table, $a_name) . "_idx";
        $this->query("ALTER TABLE $a_table DROP FULLTEXT $i_name");
        return true;
    }

dropIndex()

ilDBPdo::dropIndex	(	string	$a_table,
		string	$a_name = "i1"
	)

Implements ilDBInterface.

Definition at line 1225 of file ilDBPdo.php.

                                                                     : bool
    {
        return $this->manager->dropIndex($a_table, $a_name);
    }

dropIndexByFields()

ilDBPdo::dropIndexByFields	(	string	$table_name,
		array	$fields
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 284 of file ilDBPdo.php.

                                                                        : bool
    {
        foreach ($this->manager->listTableIndexes($table_name) as $idx_name) {
            $def = $this->reverse->getTableIndexDefinition($table_name, $idx_name);
            $idx_fields = array_keys($def['fields']);
 
            if ($idx_fields === $fields) {
                return $this->dropIndex($table_name, $idx_name);
            }
        }
 
        return false;
    }

dropPrimaryKey()

ilDBPdo::dropPrimaryKey

(

string

$table_name

)

Implements ilDBPdoInterface.

Definition at line 1423 of file ilDBPdo.php.

                                                      : bool
    {
        return $this->manager->dropConstraint($table_name, "PRIMARY", true);
    }

dropSequence()

ilDBPdo::dropSequence

(

string

$table_name

)

Implements ilDBInterface.

Definition at line 412 of file ilDBPdo.php.

                                                    : bool
    {
        $this->manager->dropSequence($table_name);
        return true;
    }

dropTable()

ilDBPdo::dropTable	(	string	$table_name,
		bool	$error_if_not_existing = true
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 348 of file ilDBPdo.php.

                                                                                     : bool
    {
        $tables = $this->manager->listTables();
        $table_exists = in_array($table_name, $tables);
        if (!$table_exists && $error_if_not_existing) {
            throw new ilDatabaseException("Table $table_name does not exist");
        }
 
        // drop sequence
        $sequences = $this->manager->listSequences();
        if (in_array($table_name, $sequences)) {
            $this->manager->dropSequence($table_name);
        }
 
        // drop table
        if ($table_exists) {
            $this->manager->dropTable($table_name);
        }
 
        return true;
    }

dropTableColumn()

ilDBPdo::dropTableColumn	(	string	$table_name,
		string	$column_name
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 421 of file ilDBPdo.php.

                                                                            : bool
    {
        $changes = [
            "remove" => [
                $column_name => [],
            ],
        ];
 
        return $this->manager->alterTable($table_name, $changes, false);
    }

dropUniqueConstraint()

ilDBPdo::dropUniqueConstraint	(	string	$table,
		string	$name = "con"
	)

Implements ilDBPdoInterface.

Definition at line 1366 of file ilDBPdo.php.

                                                                             : bool
    {
        return $this->manager->dropConstraint($table, $this->constraintName($table, $name), false);
    }

dropUniqueConstraintByFields()

ilDBPdo::dropUniqueConstraintByFields	(	string	$table,
		array	$fields
	)

Implements ilDBPdoInterface.

Definition at line 1371 of file ilDBPdo.php.

                                                                              : bool
    {
        $analyzer = new ilDBAnalyzer();
        $cons = $analyzer->getConstraintsInformation($table);
        foreach ($cons as $c) {
            if ($c["type"] === "unique" && count($fields) === count($c["fields"])) {
                $all_in = true;
                foreach ($fields as $f) {
                    if (!isset($c["fields"][$f])) {
                        $all_in = false;
                    }
                }
                if ($all_in) {
                    return $this->dropUniqueConstraint($table, $c['name']);
                }
            }
        }
 
        return false;
    }

References $c, and Vendor\Package\$f.

enableResultBuffering()

ilDBPdo::enableResultBuffering

(

bool

$a_status

)

Implements ilDBInterface.

Definition at line 1001 of file ilDBPdo.php.

                                                         : void
    {
        $this->pdo->setAttribute(PDO::MYSQL_ATTR_USE_BUFFERED_QUERY, $a_status);
    }

equals()

ilDBPdo::equals	(	string	$columns,
			$value,
		string	$type,
		bool	$emptyOrNull = false
	)

Parameters

mixed

$value

Implements ilDBInterface.

Definition at line 883 of file ilDBPdo.php.

                                                                                            : string
    {
        if (!$emptyOrNull || $value != "") {
            return $columns . " = " . $this->quote($value, $type);
        }
 
        return "(" . $columns . " = '' OR $columns IS NULL)";
    }

escape()

ilDBPdo::escape	(	string	$value,
		bool	$escape_wildcards = false
	)

Implements ilDBPdoInterface.

Definition at line 1270 of file ilDBPdo.php.

                                                                         : string
    {
        return $value;
    }

escapePattern()

ilDBPdo::escapePattern

(

string

$text

)

Implements ilDBPdoInterface.

Definition at line 1275 of file ilDBPdo.php.

                                               : string
    {
        return $text;
    }

References $text.

execute()

ilDBPdo::execute	(	ilDBStatement	$stmt,
		array	$data = []
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 1009 of file ilDBPdo.php.

                                                                  : ilDBStatement
    {
        return $stmt->execute($data);
    }

References $data, and ilDBStatement\execute().

Here is the call graph for this function:

executeMultiple()

ilDBPdo::executeMultiple	(	ilDBStatement	$stmt,
		array	$data
	)

Parameters

ilDBStatement[]

$stmt

Returns

string[]

Implements ilDBPdoInterface.

Definition at line 1428 of file ilDBPdo.php.

                                                                     : array
    {
        foreach ($data as $set) {
            $this->execute($stmt, $set);
        }
        return [];
    }

References $data.

fetchAll()

ilDBPdo::fetchAll	(	ilDBStatement	$statement,
		int	$fetch_mode = ilDBConstants::FETCHMODE_ASSOC
	)

Implements ilDBInterface.

Definition at line 402 of file ilDBPdo.php.

                                                                                                      : array
    {
        $return = [];
        while ($data = $statement->fetch($fetch_mode)) {
            $return[] = $data;
        }
 
        return $return;
    }

References $data, and ilDBStatement\fetch().

Here is the call graph for this function:

fetchAssoc()

ilDBPdo::fetchAssoc

(

ilDBStatement

$statement

)

Implements ilDBInterface.

Definition at line 592 of file ilDBPdo.php.

                                                        : ?array
    {
        $res = $statement->fetch(PDO::FETCH_ASSOC);
        if ($res === null || $res === false) {
            $statement->closeCursor();
 
            return null;
        }
 
        return $res;
    }

References $res, and ilDBStatement\fetch().

Here is the call graph for this function:

fetchObject()

ilDBPdo::fetchObject

(

ilDBStatement

$query_result

)

Implements ilDBInterface.

Definition at line 479 of file ilDBPdo.php.

                                                            : ?stdClass
    {
        $res = $query_result->fetchObject();
        if ($res === null) {
            $query_result->closeCursor();
 
            return null;
        }
 
        return $res;
    }

References $res, and ilDBStatement\fetchObject().

Here is the call graph for this function:

foreignKeyExists()

ilDBPdo::foreignKeyExists	(	string	$foreign_key_name,
		string	$table_name
	)

Implements ilDBInterface.

Definition at line 1517 of file ilDBPdo.php.

                                                                                  : bool
    {
        return $this->manager->foreignKeyExists($foreign_key_name, $table_name);
    }

free()

ilDBPdo::free

(

ilDBStatement

$a_st

)

Implements ilDBInterface.

Definition at line 1142 of file ilDBPdo.php.

                                             : void
    {
        $a_st->closeCursor();
    }

fromUnixtime()

ilDBPdo::fromUnixtime	(	string	$expr,
		bool	$to_text = true
	)

Implements ilDBPdoInterface.

Definition at line 1436 of file ilDBPdo.php.

                                                                    : string
    {
        return "FROM_UNIXTIME(" . $expr . ")";
    }

generateDSN()

ilDBPdo::generateDSN

(

)

Definition at line 167 of file ilDBPdo.php.

                                 : void
    {
        $port = $this->getPort() !== 0 ? ";port=" . $this->getPort() : "";
        $dbname = $this->getDbname() !== '' ? ';dbname=' . $this->getDbname() : '';
        $host = $this->getHost();
        $charset = ';charset=' . $this->getCharset();
        $this->dsn = 'mysql:host=' . $host . $port . $dbname . $charset;
    }

References $charset, $dbname, $host, $port, getCharset(), getDbname(), getHost(), and getPort().

Referenced by connect(), createDatabase(), and initFromIniFile().

Here is the call graph for this function:

Here is the caller graph for this function:

getAllowedAttributes()

ilDBPdo::getAllowedAttributes

(

)

Returns

string[]

Implements ilDBInterface.

Definition at line 1059 of file ilDBPdo.php.

                                          : array
    {
        return $this->field_definition->getAllowedAttributes();
    }

getAttributes()

ilDBPdo::getAttributes ( )

protected

Definition at line 101 of file ilDBPdo.php.

                                      : array
    {
        return [
            PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
            PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => true,
            PDO::ATTR_TIMEOUT => 300 * 60,
        ];
    }

Referenced by connect().

Here is the caller graph for this function:

getCharset()

ilDBPdo::getCharset

(

)

Definition at line 912 of file ilDBPdo.php.

                                : string
    {
        return $this->charset;
    }

Referenced by generateDSN().

Here is the caller graph for this function:

getDbname()

ilDBPdo::getDbname

(

)

Definition at line 902 of file ilDBPdo.php.

                               : string
    {
        return $this->dbname;
    }

Referenced by generateDSN().

Here is the caller graph for this function:

getDBType()

ilDBPdo::getDBType

(

)

Get DSN.

This must be overwritten in DBMS specific class.

Implements ilDBInterface.

Definition at line 734 of file ilDBPdo.php.

                               : string
    {
        return $this->db_type;
    }

getDBVersion()

ilDBPdo::getDBVersion

(

)

Exceptions

ilDatabaseException

Implements ilDBPdoInterface.

Definition at line 1449 of file ilDBPdo.php.

                                  : string
    {
        $d = $this->fetchObject($this->query("SELECT VERSION() AS version"));
 
        if ($d !== null && $d->version) {
            return $d->version;
        }
        return 'Unknown';
    }

References Vendor\Package\$d.

getDSN()

ilDBPdo::getDSN

(

)

Get DSN.

This must be overwritten in DBMS specific class.

Implements ilDBInterface.

Definition at line 729 of file ilDBPdo.php.

                            : string
    {
        return $this->dsn;
    }

Referenced by connect().

Here is the caller graph for this function:

getFieldDefinition()

ilDBPdo::getFieldDefinition

(

)

Implements ILIAS\Database\PDO\Internal.

Definition at line 110 of file ilDBPdo.php.

                                        : ?FieldDefinition
    {
        return $this->field_definition;
    }

References $field_definition.

getHost()

ilDBPdo::getHost

(

)

Definition at line 892 of file ilDBPdo.php.

                             : string
    {
        return $this->host;
    }

Referenced by generateDSN().

Here is the caller graph for this function:

getIndexName()

ilDBPdo::getIndexName

(

string

$index_name_base

)

Implements ILIAS\Database\PDO\Internal.

Definition at line 710 of file ilDBPdo.php.

                                                         : string
    {
        return sprintf(FieldDefinition::INDEX_FORMAT, preg_replace('/[^a-z0-9_\$]/i', '_', $index_name_base));
    }

getLastErrorCode()

ilDBPdo::getLastErrorCode

(

)

Returns

string|int|null

Definition at line 136 of file ilDBPdo.php.

    {
        if ($this->pdo instanceof PDO) {
            return $this->pdo->errorCode();
        }
 
        return $this->error_code;
    }

References $error_code.

getLastInsertId()

ilDBPdo::getLastInsertId

(

)

Implements ilDBPdoInterface.

Definition at line 1392 of file ilDBPdo.php.

                                     : int
    {
        return (int) $this->pdo->lastInsertId();
    }

getPassword()

ilDBPdo::getPassword

(

)

Definition at line 932 of file ilDBPdo.php.

                                 : string
    {
        return $this->password;
    }

Referenced by connect().

Here is the caller graph for this function:

getPort()

ilDBPdo::getPort

(

)

Definition at line 942 of file ilDBPdo.php.

                             : int
    {
        return $this->port;
    }

Referenced by generateDSN().

Here is the caller graph for this function:

getPrimaryKeyIdentifier()

ilDBPdo::getPrimaryKeyIdentifier

(

)

Implements ilDBInterface.

Definition at line 298 of file ilDBPdo.php.

                                             : string
    {
        return "PRIMARY";
    }

getSequenceName()

ilDBPdo::getSequenceName

(

string

$table_name

)

Implements ilDBInterface.

Definition at line 715 of file ilDBPdo.php.

                                                       : string
    {
        return sprintf(FieldDefinition::SEQUENCE_FORMAT, preg_replace('/[^a-z0-9_\$.]/i', '_', $table_name));
    }

Referenced by nextId().

Here is the caller graph for this function:

getServerVersion()

ilDBPdo::getServerVersion

(

bool

$native = false

)

Implements ilDBPdoInterface.

Definition at line 1265 of file ilDBPdo.php.

                                                          : int
    {
        return $this->pdo->query('SELECT VERSION()')->fetchColumn();
    }

getStorageEngine()

ilDBPdo::getStorageEngine

(

)

Implements ilDBInterface.

Definition at line 1235 of file ilDBPdo.php.

                                      : string
    {
        return $this->storage_engine;
    }

getUsername()

ilDBPdo::getUsername

(

)

Definition at line 922 of file ilDBPdo.php.

                                 : string
    {
        return $this->username;
    }

Referenced by connect().

Here is the caller graph for this function:

groupConcat()

ilDBPdo::groupConcat	(	string	$a_field_name,
		string	$a_seperator = ",",
		?string	$a_order = null
	)

Implements ilDBInterface.

Definition at line 1490 of file ilDBPdo.php.

                                                                                                         : string
    {
        return $this->manager->getQueryUtils()->groupConcat($a_field_name, $a_seperator, $a_order);
    }

in()

ilDBPdo::in	(	string	$field,
		array	$values,
		bool	$negate = false,
		string	$type = ""
	)

Implements ilDBInterface.

Definition at line 782 of file ilDBPdo.php.

                                                                                             : string
    {
        return $this->manager->getQueryUtils()->in($field, $values, $negate, $type);
    }

indexExistsByFields()

ilDBPdo::indexExistsByFields	(	string	$table_name,
		array	$fields
	)

Implements ilDBInterface.

Definition at line 644 of file ilDBPdo.php.

                                                                          : bool
    {
        foreach ($this->manager->listTableIndexes($table_name) as $idx_name) {
            $def = $this->reverse->getTableIndexDefinition($table_name, $idx_name);
            $idx_fields = array_keys($def['fields']);
 
            if ($idx_fields === $fields) {
                return true;
            }
        }
 
        return false;
    }

initFromIniFile()

ilDBPdo::initFromIniFile

(

?ilIniFile

$ini = null

)

Implements ilDBInterface.

Definition at line 145 of file ilDBPdo.php.

                                                           : void
    {
        global $DIC;
 
        if ($ini instanceof ilIniFile) {
            $clientIniFile = $ini;
        } elseif ($DIC->offsetExists('ilClientIniFile')) {
            $clientIniFile = $DIC['ilClientIniFile'];
        } else {
            throw new InvalidArgumentException('$tmpClientIniFile is not an instance of ilIniFile');
        }
 
        $this->setUsername($clientIniFile->readVariable("db", "user"));
        $this->setHost($clientIniFile->readVariable("db", "host"));
        $this->setPort((int) $clientIniFile->readVariable("db", "port"));
        $this->setPassword((string) $clientIniFile->readVariable("db", "pass"));
        $this->setDbname($clientIniFile->readVariable("db", "name"));
        $this->setDBType($clientIniFile->readVariable("db", "type"));
 
        $this->generateDSN();
    }

References $DIC, $ini, generateDSN(), setDbname(), setDBType(), setHost(), setPassword(), setPort(), and setUsername().

Here is the call graph for this function:

initHelpers()

ilDBPdo::initHelpers

(

)

Deprecated:

Definition at line 97 of file ilDBPdo.php.

                                 : void
    {
    }

insert()

ilDBPdo::insert	(	string	$table_name,
		array	$values
	)

Returns

int The number of rows affected by the manipulation

Implements ilDBInterface.

Definition at line 462 of file ilDBPdo.php.

                                                             : int
    {
        $real = [];
        $fields = [];
        foreach ($values as $key => $val) {
            $real[] = $this->quote($val[1], $val[0]);
            $fields[] = $this->quoteIdentifier($key);
        }
        $values_string = implode(",", $real);
        $fields_string = implode(",", $fields);
        $query = "INSERT INTO " . $this->quoteIdentifier($table_name) . " (" . $fields_string . ") VALUES (" . $values_string . ")";
 
        $query = $this->sanitizeMB4StringIfNotSupported($query);
 
        return (int) $this->pdo->exec($query);
    }

isFulltextIndex()

ilDBPdo::isFulltextIndex	(	string	$a_table,
		string	$a_name
	)

Is index a fulltext index?

Implements ilDBInterface.

Definition at line 698 of file ilDBPdo.php.

                                                                    : bool
    {
        $set = $this->query("SHOW INDEX FROM " . $a_table);
        while ($rec = $this->fetchAssoc($set)) {
            if ($rec["Key_name"] === $a_name && $rec["Index_type"] === "FULLTEXT") {
                return true;
            }
        }
 
        return false;
    }

isReservedWord()

static ilDBPdo::isReservedWord ( string  $a_word )

static

Implements ilDBInterface.

Definition at line 1183 of file ilDBPdo.php.

                                                         : bool
    {
        global $DIC;
        return (new ilDBPdoMySQLFieldDefinition($DIC->database()))->isReserved($a_word);
    }

References $DIC.

like()

ilDBPdo::like	(	string	$column,
		string	$type,
		string	$value = "?",
		bool	$case_insensitive = true
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 840 of file ilDBPdo.php.

                                                                                                          : string
    {
        return $this->manager->getQueryUtils()->like($column, $type, $value, $case_insensitive);
    }

listSequences()

ilDBPdo::listSequences

(

)

Returns

string[]

Implements ilDBInterface.

Definition at line 1069 of file ilDBPdo.php.

                                   : array
    {
        return $this->manager->listSequences();
    }

listTables()

ilDBPdo::listTables

(

)

Returns

int[]|string[]

Implements ilDBInterface.

Definition at line 1042 of file ilDBPdo.php.

                                : array
    {
        return $this->manager->listTables();
    }

loadModule()

ilDBPdo::loadModule

(

string

$module

)

Returns

\ilDBManager|\ilDBReverse

Implements ilDBInterface.

Definition at line 1050 of file ilDBPdo.php.

    {
        return match ($module) {
            ilDBConstants::MODULE_MANAGER => $this->manager,
            ilDBConstants::MODULE_REVERSE => $this->reverse,
            default => throw new LogicException('module "' . $module . '" not available'),
        };
    }

References ilDBConstants\MODULE_MANAGER, and ilDBConstants\MODULE_REVERSE.

locate()

ilDBPdo::locate	(	string	$needle,
		string	$string,
		int	$start_pos = 1
	)

Implements ilDBInterface.

Definition at line 1092 of file ilDBPdo.php.

                                                                              : string
    {
        return $this->manager->getQueryUtils()->locate($needle, $string, $start_pos);
    }

lockTables()

ilDBPdo::lockTables

(

array

$tables

)

Deprecated:

Use ilAtomQuery instead

Implements ilDBInterface.

Definition at line 767 of file ilDBPdo.php.

                                             : void
    {
        $lock = $this->manager->getQueryUtils()->lock($tables);
        $this->pdo->exec($lock);
    }

lower()

ilDBPdo::lower

(

string

$expression

)

Implements ilDBInterface.

Definition at line 977 of file ilDBPdo.php.

                                             : string
    {
        return " LOWER(" . $expression . ") ";
    }

manipulate()

ilDBPdo::manipulate

(

string

$query

)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 572 of file ilDBPdo.php.

                                             : int
    {
        global $DIC;
        $ilBench = $DIC['ilBench'] ?? null;
        try {
            $query = $this->sanitizeMB4StringIfNotSupported($query);
            if ($ilBench instanceof ilBenchmark) {
                $ilBench->startDbBench($query);
            }
            $num_affected_rows = $this->pdo->exec($query);
            if ($ilBench instanceof ilBenchmark) {
                $ilBench->stopDbBench();
            }
        } catch (PDOException $e) {
            throw new ilDatabaseException($e->getMessage() . ' QUERY: ' . $query, (int) $e->getCode());
        }
 
        return (int) $num_affected_rows;
    }

References $DIC, and Vendor\Package\$e.

manipulateF()

ilDBPdo::manipulateF	(	string	$query,
		array	$types,
		array	$values
	)

Parameters

string[]

$types

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 809 of file ilDBPdo.php.

                                                                           : int
    {
        if (count($types) !== count($values)) {
            throw new ilDatabaseException("ilDB::manipulateF: types and values must be arrays of same size. ($query)");
        }
        $quoted_values = [];
        foreach ($types as $k => $t) {
            $quoted_values[] = $this->quote($values[$k], $t);
        }
        $query = vsprintf($query, $quoted_values);
 
        return $this->manipulate($query);
    }

migrateAllTablesToCollation()

ilDBPdo::migrateAllTablesToCollation

(

string

$collation = ilDBConstants::MYSQL_COLLATION_UTF8MB4

)

Returns

array of failed tables

Implements ilDBPdoInterface.

Definition at line 1307 of file ilDBPdo.php.

                                                                                                         : array
    {
        $errors = [];
        foreach ($this->manager->listTables() as $table_name) {
            if (!$this->migrateTableCollation($table_name, $collation)) {
                $errors[] = $table_name;
            }
        }
 
        return $errors;
    }

migrateAllTablesToEngine()

ilDBPdo::migrateAllTablesToEngine

(

string

$engine = ilDBConstants::MYSQL_ENGINE_INNODB

)

Returns

array<int|string, string>

Implements ilDBPdoInterface.

Definition at line 1284 of file ilDBPdo.php.

                                                                                               : array
    {
        $engines = $this->queryCol('SHOW ENGINES');
        if (!in_array($engine, $engines, true)) {
            return [];
        }
        $errors = [];
        $tables = $this->listTables();
        array_walk($tables, function (string $table_name) use (&$errors, $engine): void {
            try {
                $this->pdo->exec("ALTER TABLE $table_name ENGINE=$engine");
                if ($this->sequenceExists($table_name)) {
                    $this->pdo->exec("ALTER TABLE {$table_name}_seq ENGINE=$engine");
                }
            } catch (Exception $e) {
                $errors[$table_name] = $e->getMessage();
            }
        });
 
        return $errors;
    }

References Vendor\Package\$e.

migrateTableCollation()

ilDBPdo::migrateTableCollation	(	string	$table_name,
		string	$collation = ilDBConstants::MYSQL_COLLATION_UTF8MB4
	)

Implements ilDBPdoInterface.

Definition at line 1543 of file ilDBPdo.php.

                                                                                                                       : bool
    {
        $collation_split = explode("_", $collation);
        $character = $collation_split[0] ?? 'utf8mb4';
        $collate = $collation;
        $q = "ALTER TABLE {$this->quoteIdentifier($table_name)} CONVERT TO CHARACTER SET {$character} COLLATE {$collate};";
        try {
            $this->pdo->exec($q);
        } catch (PDOException) {
            return false;
        }
        return true;
    }

References $q.

migrateTableToEngine()

ilDBPdo::migrateTableToEngine	(	string	$table_name,
		string	$engine = ilDBConstants::MYSQL_ENGINE_INNODB
	)

Implements ilDBPdoInterface.

Definition at line 1557 of file ilDBPdo.php.

                                                                                                               : void
    {
        try {
            $this->pdo->exec("ALTER TABLE {$table_name} ENGINE={$engine}");
            if ($this->sequenceExists($table_name)) {
                $this->pdo->exec("ALTER TABLE {$table_name}_seq ENGINE={$engine}");
            }
        } catch (PDOException $e) {
            throw new ilDatabaseException($e->getMessage(), $e->getCode());
        }
    }

References Vendor\Package\$e.

modifyTableColumn()

ilDBPdo::modifyTableColumn	(	string	$table,
		string	$column,
		array	$attributes
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 1100 of file ilDBPdo.php.

                                                                                       : bool
    {
        $def = $this->reverse->getTableFieldDefinition($table, $column);
 
        $analyzer = new ilDBAnalyzer($this);
        $best_alt = $analyzer->getBestDefinitionAlternative($def);
        $def = $def[$best_alt];
        unset($def["nativetype"], $def["mdb2type"]);
 
        // check attributes
        $ilDBPdoFieldDefinition = $this->field_definition;
 
        $type = $attributes["type"] ?? $def["type"];
 
        foreach (array_keys($def) as $k) {
            if ($k !== "type" && !$ilDBPdoFieldDefinition->isAllowedAttribute($k, $type)) {
                unset($def[$k]);
            }
        }
        $check_array = $def;
        foreach ($attributes as $k => $v) {
            $check_array[$k] = $v;
        }
        if (!$this->checkColumnDefinition($check_array, true)) {
            throw new ilDatabaseException("ilDB Error: modifyTableColumn(" . $table . ", " . $column . ")");
        }
 
        foreach ($attributes as $a => $v) {
            $def[$a] = $v;
        }
 
        $attributes["definition"] = $def;
 
        $changes = [
            "change" => [
                $column => $attributes,
            ],
        ];
 
        return $this->manager->alterTable($table, $changes, false);
    }

References Vendor\Package\$a.

nextId()

ilDBPdo::nextId

(

string

$table_name

)

Implements ilDBInterface.

Definition at line 182 of file ilDBPdo.php.

                                              : int
    {
        $sequence_name = $this->quoteIdentifier($this->getSequenceName($table_name), true);
        $seqcol_name = $this->quoteIdentifier('sequence');
        $query = "INSERT INTO $sequence_name ($seqcol_name) VALUES (NULL)";
        try {
            $this->pdo->exec($query);
        } catch (PDOException) {
            // no such table check
        }
 
        $result = $this->query('SELECT LAST_INSERT_ID() AS next');
        $value = $result->fetchObject()->next;
 
        if (is_numeric($value)) {
            $query = "DELETE FROM $sequence_name WHERE $seqcol_name < $value";
            $this->pdo->exec($query);
        }
 
        return (int) $value;
    }

References getSequenceName(), query(), and quoteIdentifier().

Here is the call graph for this function:

now()

ilDBPdo::now

(

)

Returns

string the now statement

Implements ilDBInterface.

Definition at line 848 of file ilDBPdo.php.

                         : string
    {
        return $this->manager->getQueryUtils()->now();
    }

numRows()

ilDBPdo::numRows

(

ilDBStatement

$statement

)

Implements ilDBInterface.

Definition at line 604 of file ilDBPdo.php.

                                                     : int
    {
        return $statement->rowCount();
    }

References ilDBStatement\rowCount().

Here is the call graph for this function:

prepare()

ilDBPdo::prepare	(	string	$a_query,
		?array	$a_types = null,
		?array	$a_result_types = null
	)

Prepare a query (SELECT) statement to be used with execute.

Implements ilDBInterface.

Definition at line 996 of file ilDBPdo.php.

                                                                                             : ilDBStatement
    {
        return new ilPDOStatement($this->pdo->prepare($query));
    }

prepareManip()

ilDBPdo::prepareManip	(	string	$query,
		?array	$types = null
	)

Implements ilDBInterface.

Definition at line 991 of file ilDBPdo.php.

                                                                     : ilDBStatement
    {
        return new ilPDOStatement($this->pdo->prepare($query));
    }

primaryExistsByFields()

ilDBPdo::primaryExistsByFields	(	string	$table_name,
		array	$fields
	)

Implements ilDBInterface.

Definition at line 1527 of file ilDBPdo.php.

                                                                            : bool
    {
        $constraints = $this->manager->listTableConstraints($table_name);
 
        if (in_array('primary', $constraints)) {
            $definitions = $this->reverse->getTableConstraintDefinition($table_name, 'primary');
            $primary_fields = array_keys($definitions['fields']);
            sort($primary_fields);
            sort($fields);
 
            return $primary_fields === $fields;
        }
        return false;
    }

References ILIAS\UI\examples\Symbol\Glyph\Sort\sort().

Here is the call graph for this function:

query()

ilDBPdo::query

(

string

$query

)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 373 of file ilDBPdo.php.

                                        : ilDBStatement
    {
        global $DIC;
        $ilBench = $DIC['ilBench'] ?? null;
 
        $query = $this->appendLimit($query);
 
        try {
            if ($ilBench instanceof ilBenchmark) {
                $ilBench->startDbBench($query);
            }
            $res = $this->pdo->query($query);
            if ($ilBench instanceof ilBenchmark) {
                $ilBench->stopDbBench();
            }
        } catch (PDOException $e) {
            throw new ilDatabaseException($e->getMessage() . ' QUERY: ' . $query, (int) $e->getCode());
        }
 
        $err = $this->pdo->errorCode();
        if ($err !== PDO::ERR_NONE) {
            $info = $this->pdo->errorInfo();
            $info_message = $info[2];
            throw new ilDatabaseException($info_message . ' QUERY: ' . $query);
        }
 
        return new ilPDOStatement($res);
    }

References $DIC, Vendor\Package\$e, $info, and $res.

Referenced by createDatabase(), and nextId().

Here is the caller graph for this function:

queryCol()

ilDBPdo::queryCol	(	string	$query,
		int	$type = PDO::FETCH_ASSOC,
		int	$colnum = 0
	)

Implements ilDBPdoInterface.

Definition at line 1240 of file ilDBPdo.php.

                                                                                        : array
    {
        $type = match ($type) {
            ilDBConstants::FETCHMODE_ASSOC => PDO::FETCH_ASSOC,
            ilDBConstants::FETCHMODE_OBJECT => PDO::FETCH_OBJ,
            default => PDO::FETCH_ASSOC,
        };
 
        return $this->pdo->query($query, PDO::FETCH_ASSOC)->fetchAll(PDO::FETCH_COLUMN, $colnum);
    }

References ilDBConstants\FETCHMODE_ASSOC, and ilDBConstants\FETCHMODE_OBJECT.

queryF()

ilDBPdo::queryF	(	string	$query,
		array	$types,
		array	$values
	)

Parameters

string[]

$types

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 791 of file ilDBPdo.php.

                                                                      : ilDBStatement
    {
        if (count($types) !== count($values)) {
            throw new ilDatabaseException("ilDB::queryF: Types and values must be arrays of same size. ($query)");
        }
        $quoted_values = [];
        foreach ($types as $k => $t) {
            $quoted_values[] = $this->quote($values[$k], $t);
        }
        $query = vsprintf($query, $quoted_values);
 
        return $this->query($query);
    }

queryRow()

ilDBPdo::queryRow	(	string	$query,
		?array	$types = null,
		int	$fetchmode = ilDBConstants::FETCHMODE_DEFAULT
	)

Implements ilDBPdoInterface.

Definition at line 1251 of file ilDBPdo.php.

     : array {
        $type = match ($fetchmode) {
            ilDBConstants::FETCHMODE_ASSOC => PDO::FETCH_ASSOC,
            ilDBConstants::FETCHMODE_OBJECT => PDO::FETCH_OBJ,
            default => PDO::FETCH_ASSOC,
        };
 
        return $this->pdo->query($query, $type)->fetch();
    }

References ilDBConstants\FETCHMODE_ASSOC, and ilDBConstants\FETCHMODE_OBJECT.

quote()

ilDBPdo::quote	(		$value,
		?string	$type = null
	)

Definition at line 609 of file ilDBPdo.php.

                                                       : string
    {
        if ($value === null) {
            return 'NULL';
        }
 
        $pdo_type = PDO::PARAM_STR;
        switch ($type) {
            case ilDBConstants::T_TIMESTAMP:
            case ilDBConstants::T_DATETIME:
            case ilDBConstants::T_DATE:
                if ($value === '') {
                    return 'NULL';
                }
                if ($value === $this->now()) {
                    return $value;
                }
                $value = (string) $value;
                break;
            case ilDBConstants::T_INTEGER:
                return (string) (int) $value;
            case ilDBConstants::T_FLOAT:
                $pdo_type = PDO::PARAM_INT;
                $value = (string) $value;
                break;
            case ilDBConstants::T_TEXT:
            default:
                $value = (string) $value;
                $pdo_type = PDO::PARAM_STR;
                break;
        }
 
        return $this->pdo->quote((string) $value, $pdo_type);
    }

References ILIAS\Repository\int(), ilDBConstants\T_DATE, ilDBConstants\T_DATETIME, ilDBConstants\T_FLOAT, ilDBConstants\T_INTEGER, ilDBConstants\T_TEXT, and ilDBConstants\T_TIMESTAMP.

Here is the call graph for this function:

quoteIdentifier()

ilDBPdo::quoteIdentifier	(	string	$identifier,
		bool	$check_option = false
	)

Implements ilDBInterface.

Definition at line 176 of file ilDBPdo.php.

                                                                                   : string
    {
        return '`' . preg_replace('/[^a-zA-Z0-9_$]/', '', $identifier) . '`';
    }

Referenced by nextId().

Here is the caller graph for this function:

renameTable()

ilDBPdo::renameTable	(	string	$name,
		string	$new_name
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 1150 of file ilDBPdo.php.

                                                               : bool
    {
        // check table name
        try {
            $this->checkTableName($new_name);
        } catch (ilDatabaseException $e) {
            throw new ilDatabaseException("ilDB Error: renameTable(" . $name . "," . $new_name . ")<br />" . $e->getMessage(), $e->getCode());
        }
 
        $this->manager->alterTable($name, ["name" => $new_name], false);
        if ($this->sequenceExists($name)) {
            $this->manager->alterTable(
                $this->getSequenceName($name),
                ["name" => $this->getSequenceName($new_name)],
                false
            );
        }
        // The abstraction_progress is no longer used in ILIAS, see http://www.ilias.de/mantis/view.php?id=19513
        //              $query = "UPDATE abstraction_progress " . "SET table_name = " . $this->quote($a_new_name, 'text') . " " . "WHERE table_name = "
        //                       . $this->quote($a_name, 'text');
        //              $this->pdo->query($query);
 
        return true;
    }

References Vendor\Package\$e.

renameTableColumn()

ilDBPdo::renameTableColumn	(	string	$table_name,
		string	$column_old_name,
		string	$column_new_name
	)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 435 of file ilDBPdo.php.

                                                                                                           : bool
    {
        // check table name
        if (!$this->checkColumnName($column_new_name)) {
            throw new ilDatabaseException("ilDB Error: renameTableColumn(" . $table_name . "," . $column_old_name . "," . $column_new_name . ")");
        }
 
        $def = $this->reverse->getTableFieldDefinition($table_name, $column_old_name);
 
        $analyzer = new ilDBAnalyzer($this);
        $best_alt = $analyzer->getBestDefinitionAlternative($def);
        $def = $def[$best_alt];
        unset($def["nativetype"]);
        unset($def["mdb2type"]);
 
        $f["definition"] = $def;
        $f["name"] = $column_new_name;
 
        $changes = [
            "rename" => [
                $column_old_name => $f,
            ],
        ];
 
        return $this->manager->alterTable($table_name, $changes, false);
    }

References Vendor\Package\$f.

replace()

ilDBPdo::replace	(	string	$table,
		array	$primary_keys,
		array	$other_columns
	)

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

Returns

int The number of rows affected by the manipulation

Implements ilDBInterface.

Definition at line 853 of file ilDBPdo.php.

                                                                                     : int
    {
        $a_columns = array_merge($primary_keys, $other_columns);
        $fields = [];
        $placeholders = [];
        $types = [];
        $values = [];
 
        foreach ($a_columns as $k => $col) {
            $fields[] = $this->quoteIdentifier($k);
            $placeholders[] = "%s";
            $placeholders2[] = ":$k";
            $types[] = $col[0];
 
            // integer auto-typecast (this casts bool values to integer)
            if ($col[0] === 'integer' && !is_null($col[1])) {
                $col[1] = (int) $col[1];
            }
 
            $values[] = $col[1];
        }
 
        $q = "REPLACE INTO " . $table . " (" . implode(",", $fields) . ") VALUES (" . implode(",", $placeholders) . ")";
 
        return $this->manipulateF($q, $types, $values);
    }

References $q, and ILIAS\Repository\int().

Here is the call graph for this function:

rollback()

ilDBPdo::rollback

(

)

Exceptions

ilDatabaseException

Implements ilDBInterface.

Definition at line 1216 of file ilDBPdo.php.

                              : bool
    {
        if (!$this->supports(self::FEATURE_TRANSACTIONS)) {
            throw new ilDatabaseException("ilDB::beginTransaction: Transactions are not supported.");
        }
 
        return $this->pdo->rollBack();
    }

sanitizeMB4StringIfNotSupported()

ilDBPdo::sanitizeMB4StringIfNotSupported

(

string

$query

)

Parameters

$query

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

Returns

string sanitized query

Implements ilDBInterface.

Definition at line 1459 of file ilDBPdo.php.

                                                                  : string
    {
        if (!$this->doesCollationSupportMB4Strings()) {
            $query_replaced = preg_replace(
                '/[\x{10000}-\x{10FFFF}]/u',
                ilDBConstants::MB4_REPLACEMENT,
                $query
            );
            if (!empty($query_replaced)) {
                return $query_replaced;
            }
        }
 
        return $query;
    }

References ilDBConstants\MB4_REPLACEMENT.

sequenceExists()

ilDBPdo::sequenceExists

(

string

$sequence

)

Implements ilDBInterface.

Definition at line 1064 of file ilDBPdo.php.

                                                    : bool
    {
        return in_array($sequence, $this->listSequences(), true);
    }

setCharset()

ilDBPdo::setCharset

(

string

$charset

)

Definition at line 917 of file ilDBPdo.php.

                                               : void
    {
        $this->charset = $charset;
    }

setDBHost()

ilDBPdo::setDBHost

(

string

$host

)

Implements ilDBInterface.

Definition at line 967 of file ilDBPdo.php.

                                           : void
    {
        $this->setHost($host);
    }

setDbname()

ilDBPdo::setDbname

(

string

$dbname

)

Definition at line 907 of file ilDBPdo.php.

                                             : void
    {
        $this->dbname = $dbname;
    }

Referenced by createDatabase(), and initFromIniFile().

Here is the caller graph for this function:

setDBPassword()

ilDBPdo::setDBPassword

(

string

$password

)

Implements ilDBInterface.

Definition at line 962 of file ilDBPdo.php.

                                                   : void
    {
        $this->setPassword($password);
    }

setDBPort()

ilDBPdo::setDBPort

(

int

$port

)

Implements ilDBInterface.

Definition at line 957 of file ilDBPdo.php.

                                        : void
    {
        $this->setPort($port);
    }

setDBType()

ilDBPdo::setDBType

(

string

$type

)

Definition at line 739 of file ilDBPdo.php.

                                           : void
    {
        $this->db_type = $type;
    }

Referenced by initFromIniFile().

Here is the caller graph for this function:

setDBUser()

ilDBPdo::setDBUser

(

string

$user

)

Implements ilDBInterface.

Definition at line 952 of file ilDBPdo.php.

                                           : void
    {
        $this->setUsername($user);
    }

setFieldDefinition()

ilDBPdo::setFieldDefinition

(

FieldDefinition

$field_definition

)

Definition at line 115 of file ilDBPdo.php.

                                                                         : void
    {
        $this->field_definition = $field_definition;
    }

References $field_definition.

setHost()

ilDBPdo::setHost

(

string

$host

)

Definition at line 897 of file ilDBPdo.php.

                                         : void
    {
        $this->host = $host;
    }

Referenced by initFromIniFile().

Here is the caller graph for this function:

setLimit()

ilDBPdo::setLimit	(	int	$limit,
		int	$offset = 0
	)

Set the Limit for the next Query.

Implements ilDBInterface.

Definition at line 831 of file ilDBPdo.php.

                                                         : void
    {
        $this->limit = $limit;
        $this->offset = $offset;
    }

setPassword()

ilDBPdo::setPassword

(

string

$password

)

Definition at line 937 of file ilDBPdo.php.

                                                 : void
    {
        $this->password = $password;
    }

Referenced by initFromIniFile().

Here is the caller graph for this function:

setPort()

ilDBPdo::setPort

(

int

$port

)

Definition at line 947 of file ilDBPdo.php.

                                      : void
    {
        $this->port = $port;
    }

Referenced by initFromIniFile().

Here is the caller graph for this function:

setStorageEngine()

ilDBPdo::setStorageEngine

(

string

$storage_engine

)

Implements ilDBInterface.

Definition at line 1230 of file ilDBPdo.php.

                                                            : void
    {
        $this->storage_engine = $storage_engine;
    }

setUsername()

ilDBPdo::setUsername

(

string

$username

)

Definition at line 927 of file ilDBPdo.php.

                                                 : void
    {
        $this->username = $username;
    }

Referenced by initFromIniFile().

Here is the caller graph for this function:

substr()

ilDBPdo::substr	(	string	$a_exp,
		int	$a_pos = 1,
		int	$a_len = -1
	)

Definition at line 982 of file ilDBPdo.php.

                                                                          : string
    {
        $lenstr = "";
        if ($a_len > -1) {
            $lenstr = ", " . $a_len;
        }
        return " SUBSTR(" . $a_exp . ", " . $a_pos . $lenstr . ") ";
    }

supports()

ilDBPdo::supports

(

string

$feature

)

Implements ilDBInterface.

Definition at line 1029 of file ilDBPdo.php.

                                             : bool
    {
        return match ($feature) {
            self::FEATURE_TRANSACTIONS => $this->supportsTransactions(),
            self::FEATURE_FULLTEXT => $this->supportsFulltext(),
            self::FEATURE_SLAVE => $this->supportsSlave(),
            default => false,
        };
    }

supportsCollationMigration()

ilDBPdo::supportsCollationMigration

(

)

Implements ilDBPdoInterface.

Definition at line 1320 of file ilDBPdo.php.

                                                : bool
    {
        return true;
    }

supportsEngineMigration()

ilDBPdo::supportsEngineMigration

(

)

Implements ilDBPdoInterface.

Definition at line 1325 of file ilDBPdo.php.

                                             : bool
    {
        return true;
    }

supportsFulltext()

ilDBPdo::supportsFulltext

(

)

Implements ilDBInterface.

Definition at line 1019 of file ilDBPdo.php.

                                      : bool
    {
        return false;
    }

supportsSlave()

ilDBPdo::supportsSlave

(

)

Implements ilDBInterface.

Definition at line 1014 of file ilDBPdo.php.

                                   : bool
    {
        return false;
    }

supportsTransactions()

ilDBPdo::supportsTransactions

(

)

Implements ilDBInterface.

Definition at line 1024 of file ilDBPdo.php.

                                          : bool
    {
        return $this->details->supportsTransactions();
    }

tableColumnExists()

ilDBPdo::tableColumnExists	(	string	$table_name,
		string	$column_name
	)

Implements ilDBInterface.

Definition at line 319 of file ilDBPdo.php.

                                                                              : bool
    {
        return in_array($column_name, $this->manager->listTableFields($table_name), true);
    }

tableExists()

ilDBPdo::tableExists

(

string

$table_name

)

Implements ilDBInterface.

Definition at line 309 of file ilDBPdo.php.

                                                   : bool
    {
        $result = $this->pdo->prepare("SHOW TABLES LIKE :table_name");
        $result->execute(['table_name' => $table_name]);
        $return = $result->rowCount();
        $result->closeCursor();
 
        return $return > 0;
    }

uniqueConstraintExists()

ilDBPdo::uniqueConstraintExists	(	string	$table,
		array	$fields
	)

Implements ilDBPdoInterface.

Definition at line 1402 of file ilDBPdo.php.

                                                                        : bool
    {
        $analyzer = new ilDBAnalyzer();
        $cons = $analyzer->getConstraintsInformation($table);
        foreach ($cons as $c) {
            if ($c["type"] === "unique" && count($fields) === count($c["fields"])) {
                $all_in = true;
                foreach ($fields as $f) {
                    if (!isset($c["fields"][$f])) {
                        $all_in = false;
                    }
                }
                if ($all_in) {
                    return true;
                }
            }
        }
 
        return false;
    }

References $c, and Vendor\Package\$f.

unixTimestamp()

ilDBPdo::unixTimestamp

(

)

Implements ilDBPdoInterface.

Definition at line 1441 of file ilDBPdo.php.

                                   : string
    {
        return "UNIX_TIMESTAMP()";
    }

unlockTables()

ilDBPdo::unlockTables

(

)

Exceptions

ilDatabaseException

Deprecated:

Use ilAtomQuery instead

Implements ilDBInterface.

Definition at line 777 of file ilDBPdo.php.

                                  : void
    {
        $this->pdo->exec($this->manager->getQueryUtils()->unlock());
    }

update()

ilDBPdo::update	(	string	$table_name,
		array	$values,
		array	$where
	)

@description $where MUST contain existing columns only.

statements like [1 => ['integer', 1]] will not work, use a full query and

See also

manipulate() instead in that case.

Returns

int The number of rows affected by the manipulation

Implements ilDBInterface.

Definition at line 491 of file ilDBPdo.php.

                                                                            : int
    {
        $fields = [];
        $field_values = [];
        $placeholders = [];
        $placeholders_full = [];
        $types = [];
        $values = [];
        $lobs = false;
        $lob = [];
        foreach ($columns as $k => $col) {
            $field_value = $col[1];
            $fields[] = $k;
            $placeholders[] = "%s";
            $placeholders_full[] = ":$k";
            $types[] = $col[0];
 
            if (($col[0] === "blob" || $col[0] === "clob" || $col[0] === 'text') && is_string($field_value)) {
                $field_value = $this->sanitizeMB4StringIfNotSupported($field_value);
            }
 
            // integer auto-typecast (this casts bool values to integer)
            if ($col[0] === 'integer' && !is_null($field_value)) {
                $field_value = (int) $field_value;
            }
 
            $values[] = $field_value;
            $field_values[$k] = $field_value;
            if ($col[0] === "blob" || $col[0] === "clob") {
                $lobs = true;
            }
        }
 
        if ($lobs) {
            $q = "UPDATE " . $this->quoteIdentifier($table_name) . " SET ";
            $lim = "";
            foreach ($fields as $k => $field) {
                $q .= $lim . $this->quoteIdentifier($field) . " = " . $placeholders_full[$k];
                $lim = ", ";
            }
            $q .= " WHERE ";
            $lim = "";
            foreach ($where as $k => $col) {
                $q .= $lim . $this->quoteIdentifier($k) . " = " . $this->quote($col[1], $col[0]);
                $lim = " AND ";
            }
 
            $r = $this->prepareManip($q, $types);
            $this->execute($r, $field_values);
 
            $num_affected_rows = $r->rowCount();
 
            $this->free($r);
        } else {
            foreach ($where as $k => $col) {
                $types[] = $col[0];
                $values[] = $col[1];
                $field_values[$k] = $col;
            }
            $q = "UPDATE " . $this->quoteIdentifier($table_name) . " SET ";
            $lim = "";
            foreach ($fields as $k => $field) {
                $q .= $lim . $this->quoteIdentifier($field) . " = " . $placeholders[$k];
                $lim = ", ";
            }
            $q .= " WHERE ";
            $lim = "";
            foreach (array_keys($where) as $k) {
                $q .= $lim . $this->quoteIdentifier($k) . " = %s";
                $lim = " AND ";
            }
 
            $num_affected_rows = $this->manipulateF($q, $types, $values);
        }
 
        return $num_affected_rows;
    }

References $q, and ILIAS\Repository\int().

Here is the call graph for this function:

upper()

ilDBPdo::upper

(

string

$expression

)

Implements ilDBInterface.

Definition at line 972 of file ilDBPdo.php.

                                             : string
    {
        return " UPPER(" . $expression . ") ";
    }

useSlave()

ilDBPdo::useSlave

(

bool

$bool

)

Deprecated:

Implements ilDBInterface.

Definition at line 823 of file ilDBPdo.php.

                                        : bool
    {
        return false;
    }

Field Documentation

$charset

string ilDBPdo::$charset = 'utf8'

private

Definition at line 41 of file ilDBPdo.php.

Referenced by generateDSN().

$db_type

string ilDBPdo::$db_type = ''

private

Definition at line 52 of file ilDBPdo.php.

$dbname

string ilDBPdo::$dbname = ''

private

Definition at line 40 of file ilDBPdo.php.

Referenced by generateDSN().

$dsn

string ilDBPdo::$dsn = ''

private

Definition at line 51 of file ilDBPdo.php.

$error_code

int ilDBPdo::$error_code = 0

private

Definition at line 53 of file ilDBPdo.php.

Referenced by getLastErrorCode().

$field_definition

FieldDefinition ilDBPdo::$field_definition = null

private

Definition at line 54 of file ilDBPdo.php.

Referenced by getFieldDefinition(), and setFieldDefinition().

$host

string ilDBPdo::$host = ''

private

Definition at line 39 of file ilDBPdo.php.

Referenced by generateDSN().

$limit

int ilDBPdo::$limit = null

private

Definition at line 48 of file ilDBPdo.php.

$manager

ilDBManager ilDBPdo::$manager

private

Definition at line 46 of file ilDBPdo.php.

$offset

int ilDBPdo::$offset = null

private

Definition at line 49 of file ilDBPdo.php.

$options

array ilDBPdo::$options = []

Definition at line 33 of file ilDBPdo.php.

$password

string ilDBPdo::$password = ''

private

Definition at line 43 of file ilDBPdo.php.

$pdo

PDO ilDBPdo::$pdo = null

private

Definition at line 45 of file ilDBPdo.php.

$port

int ilDBPdo::$port = 3306

private

Definition at line 44 of file ilDBPdo.php.

Referenced by generateDSN().

$reverse

ilDBReverse ilDBPdo::$reverse

private

Definition at line 47 of file ilDBPdo.php.

$storage_engine

string ilDBPdo::$storage_engine = 'InnoDB'

private

Definition at line 50 of file ilDBPdo.php.

$username

string ilDBPdo::$username = ''

private

Definition at line 42 of file ilDBPdo.php.

FEATURE_FULLTEXT

const ilDBPdo::FEATURE_FULLTEXT = 'fulltext'

Definition at line 36 of file ilDBPdo.php.

FEATURE_SLAVE

const ilDBPdo::FEATURE_SLAVE = 'slave'

Definition at line 37 of file ilDBPdo.php.

FEATURE_TRANSACTIONS

const ilDBPdo::FEATURE_TRANSACTIONS = 'transactions'

Definition at line 35 of file ilDBPdo.php.

SESSION_MODES

const ilDBPdo::SESSION_MODES

private

Initial value:

= [
        'STRICT_TRANS_TABLES',
        'STRICT_ALL_TABLES',
        'IGNORE_SPACE',
        'NO_ZERO_IN_DATE',
        'NO_ZERO_DATE',
        'ERROR_FOR_DIVISION_BY_ZERO',
        'NO_ENGINE_SUBSTITUTION',
    ]

Definition at line 56 of file ilDBPdo.php.

---

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

• components/ILIAS/Database/classes/PDO/ilDBPdo.php