JDatabaseMySQLi
From Joomla! Documentation
JDatabaseMySQLi is an 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.)
Contents |
Availability
Defined in
/libraries/joomla/database/mysqli.php
Extends
Methods
Properties which do not have specific get or set methods listed here can be retrieved or set using the inherited JObject->get method.
| Method name | Description |
|---|---|
| __construct | Constrctor. Takes database login information, and tries to connecto with the database. |
| __destruct | Destructor. Makes sure database connection is closed at the end of script. |
| connected | Determines if the connection to the server is active. |
| explain | Diagnostic function. |
| getAffectedRows | Get the number of rows affected by the most recent query. |
| getCollation | Get the database collation. |
| getEscaped | Get a database escaped string. |
| getNumRows | Get the number of rows returned by the most recent query. |
| getTableCreate | Shows the CREATE TABLE statement that creates the given tables. |
| getTableFields | Retrieves information about the given tables. |
| getTableList | Lists tables in a database. |
| getVersion | Get the version of the database connector. |
| hasUTF | Determines UTF support. |
| insertid | Gets the ID generated from the previous INSERT operation. |
| insertObject | Inserts a row into a table based on an objects properties. |
| loadAssoc | Fetch a result row as an associative array. |
| loadAssocList | Loads an associative list of database rows. |
| loadObject | Loads the first row of a query into an object. |
| loadObjectList | Loads a list of database objects. |
| loadResult | Loads the first field of the first row returned by the query. |
| loadResultArray | Loads an array of single field results into an array. |
| loadRow | Loads the first row returned by the query. |
| loadRowList | Loads 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. |
| test | Tests to see if the connector is available. |
| updateObject | Updates an object in the database. |
Importing
jimport( 'joomla.database.mysqli' );
