Joomla! API

Connects to the database if needed.

connect() : void

since	2.0.0
throws	`\RuntimeException`

Determines if the connection to the server is active.

connected() : bool

since	2.0.0

Response

bool

Create a new database using information from $options object.

createDatabase(\stdClass options, bool utf = true) : bool|resource

since	2.0.0
throws	`\RuntimeException`

Arguments

options: \stdClassObject used to pass user and database name to database driver. This object must have "db_name" and "db_user" set.
utf: boolTrue if the database supports the UTF-8 character set.

Response

bool|resource

Replace special placeholder representing binary field with the original string.

decodeBinary(string|resource data) : string

since	1.7.0

Arguments

data: string|resourceEncoded string or resource.

Response

stringThe original string.

Disconnects the database.

disconnect() : void

since	2.0.0

Drops a table from the database.

dropTable(string table, bool ifExists = true) : $this

since	2.0.0
throws	`\RuntimeException`

Arguments

table: stringThe name of the database table to drop.
ifExists: boolOptionally specify that the table must exist before it is dropped.

Response

$this

Escapes a string for usage in an SQL statement.

escape(string text, bool extra = false) : string

since	2.0.0

Arguments

text: stringThe string to be escaped.
extra: boolOptional parameter to provide extra escaping.

Response

stringThe escaped string.

Execute the SQL statement.

execute() : bool

since	2.0.0
throws	`\RuntimeException`

Response

bool

Get the number of affected rows for the previous executed SQL statement.

getAffectedRows() : int

since	2.0.0

Response

int

Method to get the database collation in use by sampling a text field of a table in the database.

getCollation() : string|bool

since	2.0.0

Response

string|boolThe collation in use by the database or boolean false if not supported.

Method that provides access to the underlying database connection.

getConnection() : resource

since	2.0.0

Response

resourceThe underlying database connection resource.

Method to get the database connection collation, as reported by the driver.

getConnectionCollation() : string

If the connector doesn't support reporting this value please return an empty string.

since	2.0.0

Response

string

Method to get the database encryption details (cipher and protocol) in use.

getConnectionEncryption() : string

since	2.0.0

Response

stringThe database encryption details.

Get the total number of SQL statements executed by the database driver.

getCount() : int

since	2.0.0

Response

int

Returns a PHP date() function compliant date format for the database driver.

getDateFormat() : string

since	2.0.0

Response

string

Get the minimum supported database version.

getMinimum() : string

since	2.0.0

Response

string

Get the name of the database driver.

getName() : string

since	2.0.0

Response

string

Get the null or zero representation of a timestamp for the database driver.

getNullDate() : string

since	2.0.0

Response

string

Get the number of returned rows for the previous executed SQL statement.

getNumRows() : int

since	2.0.0

Response

int

Get the current query object or a new QueryInterface object.

getQuery(bool new = false) : \Joomla\Database\QueryInterface

since	2.0.0
throws	`\RuntimeException`

Arguments

new: boolFalse to return the current query object, True to return a new QueryInterface object.

Response

\Joomla\Database\QueryInterface

Get the server family type.

getServerType() : string

since	2.0.0

Response

string

Retrieves field information about the given tables.

getTableColumns(string table, bool typeOnly = true) : array

since	2.0.0
throws	`\RuntimeException`

Arguments

table: stringThe name of the database table.
typeOnly: boolTrue (default) to only return field types.

Response

array

Retrieves field information about the given tables.

getTableKeys(mixed tables) : array

since	2.0.0
throws	`\RuntimeException`

Arguments

tables: mixedA table name or a list of table names.

Response

array

Method to get an array of all tables in the database.

getTableList() : array

since	2.0.0
throws	`\RuntimeException`

Response

array

Get the version of the database connector.

getVersion() : string

since	2.0.0

Response

string

Determine whether or not the database engine supports UTF-8 character encoding.

hasUtfSupport() : bool

since	2.0.0

Response

boolTrue if the database engine supports UTF-8 character encoding.

Method to get the auto-incremented value from the last INSERT statement.

insertid() : mixed

since	2.0.0

Response

mixedThe value of the auto-increment field from the last inserted row.

Inserts a row into a table based on an object's properties.

insertObject(string table, object &object, string key = null) : bool

since	2.0.0
throws	`\RuntimeException`

Arguments

table: stringThe name of the database table to insert into.
object: objectA reference to an object whose public properties match the table fields.
key: stringThe name of the primary key. If provided the object property is updated.

Response

bool

Method to test if the database TLS connections encryption are supported.

isConnectionEncryptionSupported() : bool

since	2.0.0

Response

boolWhether the database supports TLS connections encryption.

Method to check whether the installed database version is supported by the database driver

isMinimumVersion() : bool

since	2.0.0

Response

boolTrue if the database version is supported

Test to see if the connector is available.

isSupported() : bool

static

since	1.0

Response

bool

Method to get the first row of the result set from the database query as an associative array of ['field_name' => 'row_value'].

loadAssoc() : mixed

since	2.0.0
throws	`\RuntimeException`

Response

mixedThe return value or null if the query failed.

Method to get an array of the result set rows from the database query where each row is an associative array of ['field_name' => 'row_value']. The array of rows can optionally be keyed by a field name, but defaults to a sequential numeric array.

loadAssocList(string key = null, string column = null) : mixed

NOTE: Choosing to key the result array by a non-unique field name can result in unwanted behavior and should be avoided.

since	2.0.0
throws	`\RuntimeException`

Arguments

key: stringThe name of a field on which to key the result array.
column: stringAn optional column name. Instead of the whole row, only this column value will be in the result array.

Response

mixedThe return value or null if the query failed.

Method to get an array of values from the $offset field in each row of the result set from the database query.

loadColumn(int offset) : mixed

since	2.0.0
throws	`\RuntimeException`

Arguments

offset: intThe row offset to use to build the result array.

Response

mixedThe return value or null if the query failed.

Method to get the first row of the result set from the database query as an object.

loadObject(string class = stdClass::class) : mixed

since	2.0.0
throws	`\RuntimeException`

Arguments

class: stringThe class name to use for the returned row object.

Response

mixedThe return value or null if the query failed.

Method to get an array of the result set rows from the database query where each row is an object. The array of objects can optionally be keyed by a field name, but defaults to a sequential numeric array.

loadObjectList(string key = '', string class = stdClass::class) : mixed

NOTE: Choosing to key the result array by a non-unique field name can result in unwanted behavior and should be avoided.

since	2.0.0
throws	`\RuntimeException`

Arguments

key: stringThe name of a field on which to key the result array.
class: stringThe class name to use for the returned row objects.

Response

mixedThe return value or null if the query failed.

Method to get the first field of the first row of the result set from the database query.

loadResult() : mixed

since	2.0.0
throws	`\RuntimeException`

Response

mixedThe return value or null if the query failed.

Method to get the first row of the result set from the database query as an array.

loadRow() : mixed

Columns are indexed numerically so the first column in the result set would be accessible via $row[0], etc.

since	2.0.0
throws	`\RuntimeException`

Response

mixedThe return value or null if the query failed.

Method to get an array of the result set rows from the database query where each row is an array. The array of objects can optionally be keyed by a field offset, but defaults to a sequential numeric array.

loadRowList(string key = null) : mixed

NOTE: Choosing to key the result array by a non-unique field can result in unwanted behavior and should be avoided.

since	2.0.0
throws	`\RuntimeException`

Arguments

key: stringThe name of a field on which to key the result array.

Response

mixedThe return value or null if the query failed.

Locks a table in the database.

lockTable(string tableName) : $this

since	2.0.0
throws	`\RuntimeException`

Arguments

tableName: stringThe name of the table to unlock.

Response

$this

Quotes and optionally escapes a string to database requirements for use in database queries.

quote(array|string text, bool escape = true) : string

since	2.0.0

Arguments

text: array|stringA string or an array of strings to quote.
escape: boolTrue (default) to escape the string, false to leave it unchanged.

Response

string

Quotes a binary string to database requirements for use in database queries.

quoteBinary(string data) : string

since	1.7.0

Arguments

data: stringA binary string to quote.

Response

stringThe binary quoted input string.

Wrap an SQL statement identifier name such as column, table or database names in quotes to prevent injection risks and reserved word conflicts.

quoteName(array|string name, array|string as = null) : array|string

since	2.0.0

Arguments

name: array|stringThe identifier name to wrap in quotes, or an array of identifier names to wrap in quotes. Each type supports dot-notation name.
as: array|stringThe AS query part associated to $name. It can be string or array, in latter case it has to be same length of $name; if is null there will not be any AS part for string or array element.

Response

array|stringThe quote wrapped name, same type of $name.

Renames a table in the database.

renameTable(string oldTable, string newTable, string backup = null, string prefix = null) : $this

since	2.0.0
throws	`\RuntimeException`

Arguments

oldTable: stringThe name of the table to be renamed
newTable: stringThe new name for the table.
backup: stringTable prefix
prefix: stringFor the table - used to rename constraints in non-mysql databases

Response

$this

This function replaces a string identifier with the configured table prefix.

replacePrefix(string sql, string prefix = '#__') : string

since	2.0.0

Arguments

sql: stringThe SQL statement to prepare.
prefix: stringThe table prefix.

Response

stringThe processed SQL statement.

Select a database for use.

select(string database) : bool

since	2.0.0
throws	`\RuntimeException`

Arguments

database: stringThe name of the database to select for use.

Response

bool

Sets the SQL statement string for later execution.

setQuery(mixed query, int offset, int limit) : $this

since	2.0.0

Arguments

query: mixedThe SQL statement to set either as a Query object or a string.
offset: intThe affected row offset to set. {@deprecated Use LimitableInterface::setLimit() instead}
limit: intThe maximum affected rows to set. {@deprecated Use LimitableInterface::setLimit() instead}

Response

$this

Method to commit a transaction.

transactionCommit(bool toSavepoint = false) : void

since	2.0.0
throws	`\RuntimeException`

Arguments

toSavepoint: boolIf true, commit to the last savepoint.

Method to roll back a transaction.

transactionRollback(bool toSavepoint = false) : void

since	2.0.0
throws	`\RuntimeException`

Arguments

toSavepoint: boolIf true, rollback to the last savepoint.

Method to initialize a transaction.

transactionStart(bool asSavepoint = false) : void

since	2.0.0
throws	`\RuntimeException`

Arguments

asSavepoint: boolIf true and a transaction is already active, a savepoint will be created.

Method to truncate a table.

truncateTable(string table) : void

since	2.0.0
throws	`\RuntimeException`

Arguments

table: stringThe table to truncate

Unlocks tables in the database.

unlockTables() : $this

since	2.0.0
throws	`\RuntimeException`

Response

$this

Updates a row in a table based on an object's properties.

updateObject(string table, object &object, array|string key, bool nulls = false) : bool

since	2.0.0
throws	`\RuntimeException`

Arguments

table: stringThe name of the database table to update.
object: objectA reference to an object whose public properties match the table fields.
key: array|stringThe name of the primary key.
nulls: boolTrue to update null fields or false to ignore them.

Response

bool

since	1.0
package	Joomla Framework

DatabaseInterface

Methods

connect

connected

Response

createDatabase

Arguments

Response

decodeBinary

Arguments

Response

disconnect

dropTable

Arguments

Response

escape

Arguments

Response

execute

Response

getAffectedRows

Response

getCollation

Response

getConnection

Response

getConnectionCollation

Response

getConnectionEncryption

Response

getCount

Response

getDateFormat

Response

getMinimum

Response

getName

Response

getNullDate

Response

getNumRows

Response

getQuery

Arguments

Response

getServerType

Response

getTableColumns

Arguments

Response

getTableKeys

Arguments

Response

getTableList

Response

getVersion

Response

hasUtfSupport

Response

insertid

Response

insertObject

Arguments

Response

isConnectionEncryptionSupported

Response

isMinimumVersion

Response

isSupported

Response

loadAssoc

Response

loadAssocList

Arguments

Response

loadColumn

Arguments

Response

loadObject

Arguments