JDatabaseMySQLi/1.5

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

libraries/joomla/database/database/mysqli.php

Subpackage

Database

Extends

JDatabase

Methods

Method name	Description
__construct	Database object constructor.
__destruct	Database object destructor.
connected	Determines if the connection to the server is active.
explain	Diagnostic function.
getAffectedRows	Description.
getCollation	Assumes database collation in use by sampling one text field in one table.
getEscaped	Get a database escaped string.
getNumRows	Description.
getTableCreate	Shows the CREATE TABLE statement that creates the given tables.
getTableFields	Retrieves information about the given tables.
getTableList	Description.
getVersion	Description.
hasUTF	Determines UTF support.
insertid	Description.
insertObject	Inserts a row into a table based on an objects properties.
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.
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.
loadRow	Description.
loadRowList	Load a list of database rows (numeric column indexing).
query	Execute the query.
queryBatch	Execute a batch query.
select	Select a database for use.
setUTF	Custom settings for UTF support.
updateObject	Description.
test	Test to see if the MySQLi connector is available.

Importing

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

See also

• Other versions of this class
• JDatabaseMySQLi on api.joomla.org

Examples

<CodeExamplesForm />