Class Core_DataBase_Mysql

MySQL DataBase driver

Core_DataBase_Mysql

Package: HostCMS\Core\Database
Copyright: © 2005-2021 ООО "Хостмэйк" (Hostmake LLC), http://www.hostcms.ru
Author: Hostmake LLC
Version: 6.x
Located at core/database/mysql.php

Methods summary

`public resource`	# `getConnection( )` Get MySQL connection Get MySQL connection Returns resource
`public boolean`	# `connect( )` Connect to the database Connect to the database Returns boolean Hostcms-event Core_DataBase.onBeforeConnect Core_DataBase.onAfterConnect
`public Core_DataBase_Mysql`	# `selectDb( string $databaseName )` Select MySQL database Select MySQL database Parameters `$databaseName` The name of the database that is to be selected. Returns `Core_DataBase_Mysql` Hostcms-event Core_DataBase.onBeforeSelectDb Core_DataBase.onAfterSelectDb
`public Core_DataBase_Mysql`	# `disconnect( )` Close MySQL connection Close MySQL connection Returns `Core_DataBase_Mysql`
`public string\|null`	# `getVersion( )` Get database version Get database version Returns string\|null
`public Core_DataBase_Mysql`	# `setCharset( string $charset )` Set the client character set Set the client character set Parameters `$charset` A valid character set name. Returns `Core_DataBase_Mysql`
`public string`	# `escape( string $unescapedString )` Escapes special characters in a string for use in an SQL statement Escapes special characters in a string for use in an SQL statement Parameters `$unescapedString` The string that is to be escaped Returns string Escaped string
`public array`	# `getColumnType( string $columnType )` Get extended column type information Get extended column type information Parameters `$columnType` Column type, e.g. 'TINYINT' Returns array array( 'type' => 'fixed' => 'binary' => 'unsigned' => 'zerofill' => 'min' => 'max' => 'max_length' => ); Overrides `Core_DataBase::getColumnType`
`protected Core_DataBase_Mysql`	# `_addQuoteColumnNameCache( string $columnName, string $value )` Insert a quoted column name into cache Insert a quoted column name into cache Parameters `$columnName` column name `$value` quoted column name Returns `Core_DataBase_Mysql`
`public string`	# `quoteTableName( mixed $tableName )` Quote table name, e.g. `tableName` for 'tableName', `tableName` AS `tableNameAlias` for array('tableName', 'tableNameAlias') Quote table name, e.g. `tableName` for 'tableName', `tableName` AS `tableNameAlias` for array('tableName', 'tableNameAlias') Parameters `$tableName` $columnName string\|array Returns string
`public string`	# `quoteColumnName( mixed $columnName )` Quote column name, e.g. `columnName` for 'columnName', `columnName` AS `columnNameAlias` for array('columnName', 'columnNameAlias') Quote column name, e.g. `columnName` for 'columnName', `columnName` AS `columnNameAlias` for array('columnName', 'columnNameAlias') Parameters `$columnName` string or array Returns string
`public Core_DataBase_Mysql`	# `setIsolationLevel( string $IsolationLevel )` Set transaction isolation level Set transaction isolation level Parameters `$IsolationLevel` Isolation level: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, SERIALIZABLE Returns `Core_DataBase_Mysql`
`public Core_DataBase_Mysql`	# `begin( string $IsolationLevel = NULL )` Start SQL-transaction Start SQL-transaction Parameters `$IsolationLevel` Transaction isolation level Returns `Core_DataBase_Mysql`
`public Core_DataBase_Mysql`	# `commit( )` Commit SQL-transaction Commit SQL-transaction Returns `Core_DataBase_Mysql`
`public Core_DataBase_Mysql`	# `rollback( )` Rollback SQL-transaction Rollback SQL-transaction Returns `Core_DataBase_Mysql`
`public array`	# `getTables( mixed $selectionCondition = NULL )` Get list of tables in the database Get list of tables in the database Parameters `$selectionCondition` Selection condition Returns array
`public array`	# `getTablesSchema( mixed $selectionCondition = NULL )` Get tables schema in the database Get tables schema in the database Parameters `$selectionCondition` Selection condition Returns array
`public Core_DataBase_Mysql`	# `query( string $sql )` Send a MySQL query Send a MySQL query Parameters `$sql` An SQL query. The query string should not end with a semicolon. Data inside the query should be properly escaped. Returns `Core_DataBase_Mysql` Hostcms-event Core_DataBase.onBeforeQuery Core_DataBase.onAfterQuery
`public array`	# `result( boolean $bCache = TRUE )` Get last query result rows as an array of associative arrays or as an array of objects Get last query result rows as an array of associative arrays or as an array of objects Parameters `$bCache` use cache Returns array See `Core_DataBase_Mysql::current()`
`protected array`	# `_fetch( $result, boolean $bCache = TRUE )` Fetch query result Fetch query result Parameters `$result` resource `$bCache` use cache Returns array
`public mixed`	# `current( boolean $bCache = TRUE )` Get next row for last query result as an associative array or as an object Get next row for last query result as an associative array or as an object Parameters `$bCache` use cache Returns mixed array or object See `Core_DataBase_Mysql::asAssoc()` `Core_DataBase_Mysql::asObject()` `Core_DataBase_Mysql::result()`
`public resource`	# `getResult( )` Get last query result as resource Get last query result as resource Returns resource
`public Core_DataBase_Mysql`	# `asAssoc( )` Set result type as an array Set result type as an array Returns `Core_DataBase_Mysql`
`public Core_DataBase_Mysql`	# `asObject( mixed $className = NULL )` Set result type as an object with className Set result type as an object with className Parameters `$className` Object class name Returns `Core_DataBase_Mysql`
`protected mixed`	# `_currentAssoc( $result = NULL )` Get mysql_fetch_assoc() last result Get mysql_fetch_assoc() last result Parameters `$result` resource Returns mixed
`protected mixed`	# `_currentObject( $result = NULL, boolean $bCache = TRUE )` Get mysql_fetch_object() last result Get mysql_fetch_object() last result Parameters `$result` resource `$bCache` use cache Returns mixed
`public integer\|null`	# `getNumRows( )` Get number of rows in result Get number of rows in result Returns integer\|null number of rows or NULL
`public integer\|null`	# `getInsertId( )` Get the ID generated in the last query Get the ID generated in the last query Returns integer\|null
`public integer\|null`	# `getAffectedRows( )` Get number of affected rows in previous MySQL operation Get number of affected rows in previous MySQL operation Returns integer\|null number of affected rows or NULL
`public integer\|null`	# `getColumnCount( )` Returns the number of columns in the result set Returns the number of columns in the result set Returns integer\|null number of columns in the result set
`public Core_DataBase_Mysql`	# `free( )` Free last result memory Free last result memory Returns `Core_DataBase_Mysql`
`protected Core_DataBase_Mysql`	# `_free( $result )` Free result memory Free result memory Returns `Core_DataBase_Mysql`

Methods inherited from Core_DataBase

__construct(), __destruct(), _getDriverName(), dump(), escapeLike(), getCollations(), getColumnTypeAndLength(), getColumns(), getConfig(), getFullColumns(), getIndexes(), getLastQuery(), getQueryType(), highlightSql(), instance(), quote(), setConfig(), setQueryType(), unbuffered()

Properties summary

`protected resource\|null`	`$_result` Result of query Result of query	# `NULL`
`protected static integer`	`$_maxObjects` Maximum number of objects Максимальное количество объектов в кэше Maximum number of objects Максимальное количество объектов в кэше	# `256`
`protected array`	`$_quoteColumnNameCache` Quoted column name cache Quoted column name cache	# `array()`

Properties inherited from Core_DataBase

$_asObject, $_collations, $_colors, $_columnQuoteCharacter, $_config, $_connection, $_lastQuery, $_likeReplacements, $_queryType, $_separator, $_tableQuoteCharacter, $_unbuffered, $_words, $instance

Classes

Exceptions

Functions

Class Core_DataBase_Mysql

Methods summary

Returns

Returns

Hostcms-event

Parameters

Returns

Hostcms-event

Returns

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Overrides

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Returns

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Hostcms-event

Parameters

Returns

See

Parameters

Returns

Parameters

Returns

See

Returns

Returns

Parameters

Returns

Parameters

Returns

Parameters

Returns

Returns

Returns

Returns

Returns

Returns

Returns

Methods inherited from Core_DataBase

Properties summary

Properties inherited from Core_DataBase