Home Joomla development joomla database class and Functions

VirtueMart Shopping Cart

VirtueMart
Your Cart is currently empty.

Newsletter

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.
 
Copyright © 2017 JoomlaVM. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.

Joomla!® name is used under a limited license from Open Source Matters in the United States and other countries.

joomlavm.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.