Joomla! Documentation™

JDatabaseMySQL is a concrete database handler class for MySQL.

Defined in

libraries/joomla/database/database/mysql.php

Methods

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

Importing

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