JDatabaseMySQLi
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]
libraries/joomla/database/database/mysqli.php
Methods[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 |
Importing[edit]
jimport( 'joomla.database.database.mysqli' );
Examples[edit]
Code Examples[edit]