From 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.

JDatabaseMySQLi is a concrete database handler class for MySQL. The MySQLi driver can only be used for MySQL 4.1 and higher. The "i" at the end stands for "improved" (faster, better, etc.).

Defined in[edit]



Method name Description
__construct Database object constructor
__destruct Database object destructor
test Test to see if the MySQLi 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 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)
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


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


Code Examples[edit]