The "API15" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

JDatabaseMySQL is a concrete database handler class for MySQL.

Defined in



Method name Description
__construct Database object constructor
__destruct Database object destructor
connected Determines if the connection to the server is active.
select Select a database for use
hasUTF Determines UTF support
setUTF Custom settings for UTF support
getEscaped Get a database escaped string
query Execute the query
getAffectedRows Description
queryBatch Execute a batch query
explain Diagnostic function
getNumRows Description
loadResult This method loads the first field of the first row returned by the query.
loadResultArray Load an array of single field results into an array
loadAssoc Fetch a result row as an associative array
loadAssocList Load a assoc list of database rows
loadObject This global function loads the first row of a query into an object
loadObjectList Load a list of database objects
loadRow Description
loadRowList Load a list of database rows (numeric column indexing)
insertObject Inserts a row into a table based on an objects properties
updateObject Description
insertid Description
getVersion Description
getCollation Assumes database collation in use by sampling one text field in one table
getTableList Description
getTableCreate Shows the CREATE TABLE statement that creates the given tables
getTableFields Retrieves information about the given tables
test Test to see if the MySQL connector is available


jimport( 'joomla.database.database.mysql' );


Code Examples