Joomla! Documentation™

The "API16" 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

libraries/joomla/database/database/mysql.php

Methods

Method name	Description
__construct	Database object constructor
__destruct	Database object destructor
test	Test to see if the MySQL connector is available
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	int The number of affected rows in the previous operation 1.0.5
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)
loadNextRow	Load the next row returned by the query.
loadNextObject	Load the next row returned by the query.
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

Importing

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