Database
Provides a standardized interface to connect to database servers like MySQL and MariaDB.
See the Database guide to learn how to work with the Database module.
Configuration
providers
A hash array of the available database providers, where the key is the name of the database provider, and the value is a hash array with the following possible keys:providerClassName
The name of the cache provider class, from the available ones:DatabaseProviderMysql
To connect to MySQL or MariaDB database servers.
config
A hash array of configuration options for the database provider, where each different cache provider has different available config keys:For
DatabaseProviderMysql
:host
The host name or IP of the server.user
The user namepassword
The passworddatabase
The name of the databasecharset
The character set to use. One of the available here: https://dev.mysql.com/doc/refman/8.0/en/charset-charsets.html.cacheKeyPrefix
The cache prefix to use when caching data from the database. Default:Database
cacheDefaultTtl
The default TTL to use when caching data from the database. Default:CACHE_TTL_NORMAL
cacheProviderName
The default cache provider name to use when caching data from the database. Default:engine
Constants
DATABASE_FIELD_TYPE_INTEGER
DATABASE_FIELD_TYPE_TINYINT
DATABASE_FIELD_TYPE_FLOAT
DATABASE_FIELD_TYPE_DATE
DATABASE_FIELD_TYPE_DATETIME
DATABASE_FIELD_TYPE_TIMESTAMP
DATABASE_FIELD_TYPE_TIME
DATABASE_FIELD_TYPE_YEAR
DATABASE_FIELD_TYPE_STRING
DATABASE_FIELD_TYPE_TEXT
DATABASE_FIELD_TYPE_BLOB
DATABASE_FIELD_TYPE_BOOLEAN
DATABASE_FIELD_TYPE_IP
DATABASE_FIELD_TYPE_SERIALIZED
DATABASE_FIELD_TYPE_COLOR
DATABASE_FIELD_DEFAULT_VALUE
DATABASE_FIELD_DEFAULT_VALUE_DATE
DATABASE_FIELD_DEFAULT_VALUE_DATETIME
DATABASE_FIELD_DEFAULT_VALUE_TIMESTAMP
DATABASE_FIELD_DEFAULT_VALUE_TIME
DATABASE_FIELD_DEFAULT_VALUE_YEAR
DATABASE_FIELD_DEFAULT_VALUE_IP
DATABASE_FIELD_DEFAULT_VALUE_AVAILABLE_URL_SHORT_CODE
Last updated