API16:JDatabaseMySQLi
From Joomla! Documentation
(Difference between revisions)
(New page: <span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki>
</span>
{{Description:JDatabaseMySQLi}}
===Defi...) |
|||
| Line 105: | Line 105: | ||
|Retrieves information about the given tables | |Retrieves information about the given tables | ||
|} | |} | ||
| + | |||
===Importing=== | ===Importing=== | ||
<source lang="php">jimport( 'joomla.database.database.mysqli' );</source> | <source lang="php">jimport( 'joomla.database.database.mysqli' );</source> | ||
Latest revision as of 05:04, 30 March 2010
[Edit Descripton] 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.).
Contents |
[edit] Defined in
libraries/joomla/database/database/mysqli.php
[edit] Methods
| 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 |
[edit] Importing
jimport( 'joomla.database.database.mysqli' );
[Edit See Also] SeeAlso:JDatabaseMySQLi
[edit] Examples
<CodeExamplesForm />
