Generic database connector class.

An instance of this class, called $database, is created using the current Joomla configuration variables when each page is loaded. Therefore you do not generally need to create new instance of this object.  If you need to access to $database within a function then remember to declare it as global.

Beginning with version 1.1, Joomla is being adapted to use the ADOdb database abstraction library (adodb.sourceforge.net).  Some new methods have been added and some minor changes to existing methods have been made in order to accommodate this and these changes have been documented appropriately.  Joomla versions prior to 1.1 support the MySQL database (www.mysql.com) only.

Joomla version

Unknown

Defined in

includes/database.php

Functions

database

Constructor for the database class.

explain

Performs an SQL EXPLAIN on the current SQL query string.

getErrorMsg

Returns the most recent database error message.

getErrorNum

Returns the most recent database error code.

getEscaped

Escapes characters with special meaning for the database.

getNullDate

Returns the string to be used to represent a null date. This method was introduced in Joomla 1.1.

getNumRows

Returns the number of rows returned by a database query.

getPrefix

Returns the current database table prefix code. This method was introduced in Joomla 1.1.

getQuery

Returns the current value of the internal SQL query string.

getTableCreate

Creates one or more tables in the database.

getTableFields

Returns a list of fields given a list of tables.

getTableList

Returns a list of all the tables in the database.

insertid

Returns the unique record number of the last record to be inserted into a database table.

insertObject

Inserts an object into a database table.

loadAssocList

Loads an associative list of database rows.

loadObject

Loads an object with fields from the first row returned by the current SQL query.

loadObjectList

Returns an array of database objects using the current SQL query.

loadResult

Returns the first field of the first row returned by the database query.

loadResultArray

Returns an array containing a single field from all the rows returned by the database query.

loadRow

Returns the first row of the current query as an array.

loadRowList

Returns an array of database rows with numeric column indexing.

NameQuote

Quotes an identifier such as a database table name, field name, etc., using database-specific quote marks. This method was introduced in Joomla 1.1.

query

Executes the current SQL query string.

query_batch

Executes the current SQL query string as a single transaction.

Quote

Returns a quoted string with characters escaped.

setQuery

Sets the SQL query string for later execution.

schemaUpdate

Updates the AXMLS schema. This method was introduced in Joomla 1.1.

stderr

Returns the last database error message in a standard format.

updateObject

Updates a database table row using data contained in an object.

Please report any errors on this page to the Developer Documentation Forum.