Class Core_DataBase
Abstract DataBase
Direct known subclasses
Package: HostCMS\Core\Database
Copyright: © 2005-2021 ООО "Хостмэйк" (Hostmake LLC), http://www.hostcms.ru
Author: Hostmake LLC
Version: 6.x
Located at core/database.php
Methods summary
abstract public
boolean
|
|
abstract public
|
|
abstract public
string|null
|
|
abstract public
|
|
abstract public
string
|
#
escape( string $unescapedString )
Escapes special characters in a string for use in an SQL statement |
abstract public
array
|
|
abstract public
array
|
|
abstract protected
array
|
|
public
array
|
#
getColumns( string $tableName, mixed $selectionCondition = NULL )
Get list of columns in the table |
public
array
|
#
getFullColumns( string $tableName, mixed $selectionCondition = NULL )
Get list of columns in the table |
public
array
|
#
getIndexes( string $tableName, mixed $selectionCondition = NULL )
Get list of indexes in the table |
abstract public
string
|
#
quoteColumnName( mixed $columnName )
Quote column name, e.g. |
abstract public
string
|
#
quoteTableName( mixed $tableName )
Quote table name, e.g. |
abstract public
|
|
abstract public
|
|
abstract public
|
|
abstract public
|
|
abstract public
array
|
#
result( boolean $bCache = TRUE )
Get last query result rows as an array of associative arrays or as an array of objects |
abstract public
resource
|
|
abstract public
|
|
abstract public
|
|
abstract public
mixed
|
#
current( boolean $bCache = TRUE )
Get next row for last query result as an associative array or as an object |
abstract public
integer|null
|
|
abstract public
integer|null
|
|
abstract public
integer|null
|
|
abstract public
|
|
public
string
|
|
public
|
|
public
integer
|
|
public
|
|
public
|
|
public
array
|
|
public
|
|
public
|
|
protected static
srting
|
|
public static
object
|
|
public
string
|
|
public
|
|
public
array
|
|
public
array
|
|
public
string
|
|
public
string
|
|
public
array
|
Properties summary
public static
mixed
|
$instance
The singleton instances. |
#
array()
|
protected
|
$_config
Driver's configuration |
#
NULL
|
protected
|
$_connection
Driver's connection |
#
NULL
|
protected
|
$_lastQuery
Last executed query |
#
NULL
|
protected
|
$_queryType
Type of query: 0 - SELECT 1 - INSERT 2 - UPDATE 3 - DELETE 4 - RENAME 5 - ALTER 6 - DROP 7 - TRUNCATE 8 - OPTIMIZE 9 - SHOW 10 - LOCK 99 - OTHER |
#
NULL
|
protected
boolean
|
$_asObject
Get result as object |
#
FALSE
|
protected
string
|
$_columnQuoteCharacter
|
#
'`'
|
protected
string
|
$_tableQuoteCharacter
|
#
'`'
|
protected
array
|
$_separator
Array of allowed separators, e.g. table.field => |
#
array('.', ' + ', ' - ', ' / ', ' * ')
|
protected static
array
|
$_colors
Colors array |
#
array(
'orange' , 'blue' , 'green' , 'brown'
)
|
protected static
array
|
$_words
Words array |
#
array(
array('AND', 'IS', '&&', 'LOG', 'NOT','NOW', 'MIN', '!', '\|\|', 'OR', 'OCT', 'TAN',
'STD', 'SHA', 'ORD', 'XOR', 'ASC', 'DESC'),
array('SELECT', 'UPDATE', 'INSERT', 'DELETE', 'USING', 'LIMIT', 'OFFSET', 'SET' ),
array('DATE', 'INTO', 'FROM', 'THEN', 'WHEN', 'WHERE', 'LEFT JOIN', 'LEFT OUTER JOIN', 'RIGHT JOIN', 'RIGHT OUTER JOIN', 'INNER JOIN', 'JOIN', 'ELSE', 'ORDER BY', 'GROUP BY', 'HAVING', 'ON'),
array('ABS', 'ACOS', 'ADDDATE', 'ADDTIME', 'AES_DECRYPT', 'AES_ENCRYPT', '&&', 'ASCII', 'ASIN', 'ATAN2', 'ATAN',
'AVG', 'BETWEEN', 'BIN', 'BINARY', 'BIT_AND', 'BIT_LENGTH', 'BIT_OR', 'BIT_XOR', 'CASE',
'CAST', 'CEIL', 'CEILING', 'CHAR_LENGTH', 'CHAR', 'CHARACTER_LENGTH', 'CHARSET', 'COALESCE',
'COERCIBILITY', 'COLLATION', 'COMPRESS', 'CONCAT_WS', 'CONCAT', 'CONNECTION_ID', 'CONV',
'CONVERT_TZ', 'Convert', 'COS', 'COT', 'COUNT', 'COUNT', 'COUNT(DISTINCT)', 'DISTINCT', 'CRC32',
'CURDATE', 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'CURRENT_USER', 'CURTIME',
'DATABASE', 'DATE_ADD', 'DATE_FORMAT', 'DATE_SUB', 'DATEDIFF', 'DAY ', 'DAYNAME', 'DAYOFMONTH',
'DAYOFWEEK', 'DAYOFYEAR', 'DECODE', 'DEFAULT', 'DEGREES', 'DES_DECRYPT', 'DES_ENCRYPT', 'DIV',
'ELT', 'ENCODE', 'ENCRYPT', '<=>', 'EXP()', 'EXPORT_SET', 'EXTRACT', 'FIELD', 'FIND_IN_SET',
'FLOOR', 'FORMAT', 'SQL_CALC_FOUND_ROWS ', 'FOUND_ROWS', 'STRAIGHT_JOIN', 'FROM_DAYS', 'FROM_UNIXTIME', 'GET_FORMAT', 'GET_LOCK',
'GREATEST', 'GROUP_CONCAT', 'HEX ', 'HOUR', ' IF ', 'IFNULL', ' IN ', 'INET_ATON', 'INET_NTOA',
'INSTR', 'IS_FREE_LOCK', 'IS NOT NULL', 'IS NOT', 'IS NULL', 'IS_USED_LOCK', 'ISNULL',
'LAST_DAY', 'LAST_INSERT_ID', 'LCASE', 'LEAST', '<<', 'LEFT', 'LENGTH', 'LIKE', 'LN',
'LOAD_FILE', 'LOCALTIME', 'LOCALTIMESTAMP', 'LOCATE', 'LOG10', 'LOG2', 'LOWER', 'LPAD',
'LTRIM', 'MAKE_SET', 'MAKEDATE', 'MAKETIME', 'MASTER_POS_WAIT', 'MATCH', 'MAX', 'MD5', 'MICROSECOND',
'MID', 'MINUTE', 'MOD', '%', 'MONTH', 'MONTHNAME', 'NOT BETWEEN', '!=', 'NOT IN', 'NOT LIKE',
'NOT REGEXP', 'NULLIF', 'OCTET_LENGTH', 'OLD_PASSWORD', 'ORD', 'PASSWORD', 'PERIOD_ADD', 'PERIOD_DIFF',
'PI', '\+', 'POSITION', 'POW', 'POWER', 'PROCEDURE ANALYSE', 'QUARTER', 'QUOTE', 'RADIANS',
'RAND', 'REGEXP', 'RELEASE_LOCK', 'REPEAT', 'REPLACE', 'REVERSE', '>>', 'RIGHT', 'RLIKE',
'ROUND', 'ROW_COUN', 'RPAD', 'RTRIM', 'SCHEMA', 'SEC_TO_TIME', 'SECOND', 'SESSION_USER',
'SHA1', 'SIGN', 'SLEEP', 'SOUNDEX', 'SOUNDS LIKE', 'SPACE', 'SQRT', 'STDDEV_POP', 'STDDEV_SAMP',
'STDDEV', 'STR_TO_DATE', 'SUBDATE', 'SUBSTR', 'SUBSTRING_INDEX', 'SUBSTRING', 'SUBTIME',
'SUM', 'SYSDATE', 'SYSTEM_USER', 'TIME_FORMAT', 'TIME_TO_SEC', 'TIME', 'TIMEDIFF', '\*',
'TIMESTAMP', 'TIMESTAMPADD', 'TIMESTAMPDIFF', 'TO_DAYS', 'TRIM', 'TRUNCATE', 'UCASE', 'UNCOMPRESS',
'UNCOMPRESSED_LENGTH', 'UNHEX', 'UNIX_TIMESTAMP', 'UPPER', 'USER', 'UTC_DATE', 'UTC_TIME',
'UTC_TIMESTAMP', 'UUID', 'VALUES', 'VAR_POP', 'VAR_SAMP', 'VARIANCE', 'VERSION', 'WEEK',
'WEEKDAY', 'WEEKOFYEAR', 'YEAR', 'YEARWEE')
)
|
protected
boolean
|
$_unbuffered
Query without fetching and buffering the result rows |
#
FALSE
|
protected
array
|
$_likeReplacements
Array of replacements for LIKE |
#
array(
'%' => '\%',
'_' => '\_',
'\\' => '\\\\'
)
|
protected
null|array
|
$_collations
Cache for getCollations() |
#
NULL
|