joomla database class and Functions |
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. |
joomla database