Class ilDBPdoMySQLMyISAM. More...

Inheritance diagram for ilDBPdoMySQLMyISAM:

Collaboration diagram for ilDBPdoMySQLMyISAM:

Public Member Functions

supportsFulltext ()

Public Member Functions inherited from ilDBPdoMySQL

supportsTransactions ()

initHelpers ()

supportsEngineMigration ()

migrateAllTablesToEngine ($engine=ilDBConstants::MYSQL_ENGINE_INNODB)

migrateAllTablesToCollation ($collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4)

supportsCollationMigration ()

nextId ($table_name)

doesCollationSupportMB4Strings ()

Public Member Functions inherited from ilDBPdo

connect ($return_false_for_error=false)

initHelpers ()

getFieldDefinition ()

setFieldDefinition ($field_definition)

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

getLastErrorCode ()

initFromIniFile ($tmpClientIniFile=null)

generateDSN ()

quoteIdentifier ($identifier, $check_option=false)

nextId ($table_name)

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

checkColumnName ($a_name)

addPrimaryKey ($table_name, $primary_keys)

dropIndexByFields ($table_name, $fields)

getPrimaryKeyIdentifier ()

createSequence ($table_name, $start=1)

tableExists ($table_name)

tableColumnExists ($table_name, $column_name)

addTableColumn ($table_name, $column_name, $attributes)

dropTable ($table_name, $error_if_not_existing=true)

query ($query)

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, $columns, $where)

manipulate ($query)

fetchAssoc ($query_result)

numRows ($query_result)

quote ($value, $type=null)

indexExistsByFields ($table_name, $fields)

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

addFulltextIndex ($a_table, $a_fields, $a_name="in")

dropFulltextIndex ($a_table, $a_name)

Drop fulltext index. More...

isFulltextIndex ($a_table, $a_name)

Is index a fulltext index? More...

getIndexName ($index_name_base)

getSequenceName ($table_name)

constraintName ($a_table, $a_constraint)

Determine contraint name by table name and constraint name. More...

getDSN ()

getDBType ()

setDBType ($type)

lockTables ($tables)

unlockTables ()

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

queryF ($query, $types, $values)

manipulateF ($query, $types, $values)

useSlave ($bool)

setLimit ($limit, $offset=0)

Set the Limit for the next Query. More...

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

now ()

replace ($table, $primaryKeys, $otherColumns)

Replace into method. More...

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

getHost ()

setHost ($host)

getDbname ()

setDbname ($dbname)

getCharset ()

setCharset ($charset)

getUsername ()

setUsername ($username)

getPassword ()

setPassword ($password)

getPort ()

setPort ($port)

setDBUser ($user)

setDBPort ($port)

setDBPassword ($password)

setDBHost ($host)

upper ($a_exp)

lower ($a_exp)

substr ($a_exp, $a_pos=1, $a_len=-1)

prepareManip ($query, $types=null)

prepare ($query, $types=null, $result_types=null)

enableResultBuffering ($a_status)

supportsSlave ()

supportsFulltext ()

supportsTransactions ()

supports ($feature)

listTables ()

loadModule ($module)

getAllowedAttributes ()

Returns: array

More...

sequenceExists ($sequence)

listSequences ()

concat (array $values, $allow_null=true)

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

modifyTableColumn ($table, $a_column, $a_attributes)

renameTable ($a_name, $a_new_name)

checkTableName ($a_name)

beginTransaction ()

commit ()

rollback ()

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

setStorageEngine ($storage_engine)

getStorageEngine ()

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

queryRow ($query, $types=null, $fetchmode=ilDBConstants::FETCHMODE_DEFAULT)

getServerVersion ($native=false)

escape ($value, $escape_wildcards=false)

escapePattern ($text)

migrateAllTablesToEngine ($engine=ilDBConstants::MYSQL_ENGINE_INNODB)

migrateAllTablesToCollation ($collation=ilDBConstants::MYSQL_COLLATION_UTF8MB4)

supportsCollationMigration ()

supportsEngineMigration ()

checkIndexName ($name)

addUniqueConstraint ($table, $fields, $name="con")

dropUniqueConstraint ($a_table, $a_name="con")

dropUniqueConstraintByFields ($a_table, $a_fields)

getLastInsertId ()

buildAtomQuery ()

uniqueConstraintExists ($table, array $fields)

dropPrimaryKey ($table_name)

executeMultiple ($stmt, $a_data)

fromUnixtime ($a_expr, $a_to_text=true)

unixTimestamp ()

autoExecute ($tablename, $fields, $mode=ilDBConstants::MDB2_AUTOQUERY_INSERT, $where=false)

Generate an insert, update or delete query and call prepare() and execute() on it. More...

getDBVersion ()

sanitizeMB4StringIfNotSupported ($query)

Parameters

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

Returns: string sanitized query

More...

doesCollationSupportMB4Strings ()

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

Parameters

string	$a_field_name
string	$a_seperator
string	$a_order

Returns: string

More...

cast ($a_field_name, $a_dest_type)

Parameters

string	$a_field_name
string	$a_dest_type

Returns: string;

More...

Public Member Functions inherited from ilDBInterface

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

substr ($a_exp)

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

free ($a_st)

Protected Attributes
	$storage_engine = 'MyISAM'

Protected Attributes inherited from ilDBPdo
	$host = ''

	$dbname = ''

	$charset = 'utf8'

	$username = ''

	$password = ''

	$port = 3306

	$pdo

	$manager

	$reverse

	$limit = null

	$offset = null

	$storage_engine = 'MyISAM'

	$dsn = ''

	$attributes

	$db_type = ''

	$error_code = 0

	$field_definition

Additional Inherited Members
Static Public Member Functions inherited from ilDBPdo
static	isReservedWord ($a_word)

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

Data Fields inherited from ilDBPdo
const	FEATURE_TRANSACTIONS = 'transactions'

const	FEATURE_FULLTEXT = 'fulltext'

const	FEATURE_SLAVE = 'slave'

Protected Member Functions inherited from ilDBPdoMySQL
	initSQLMode ()

	getAdditionalAttributes ()

Protected Member Functions inherited from ilDBPdo
	initSQLMode ()

	getAttributes ()

	getAdditionalAttributes ()

	checkTableColumns ($a_cols)

	checkColumn ($a_col, $a_def)

	checkColumnDefinition ($a_def, $a_modify_mode=false)

	appendLimit ($query)

	autoPrepare ($table, $table_fields, $mode=ilDBConstants::MDB2_AUTOQUERY_INSERT, $where=false, $types=null, $result_types=ilDBConstants::MDB2_PREPARE_MANIP)

	buildManipSQL ($table, $table_fields, $mode, $where=false)