Difference between revisions of "JDatabaseMySQLi"
From Joomla! Documentation
(New page: <span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki>
</span>
{{Description:JDatabaseMySQLi}}
===Defi...) |
m (preparing for archive only) |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | + | [[JDatabaseMySQLi]] is a concrete database handler class for [http://www.mysql.com/ 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=== | ===Defined in=== | ||
Line 99: | Line 96: | ||
|Test to see if the MySQLi connector is available | |Test to see if the MySQLi connector is available | ||
|} | |} | ||
+ | |||
===Importing=== | ===Importing=== | ||
<source lang="php">jimport( 'joomla.database.database.mysqli' );</source> | <source lang="php">jimport( 'joomla.database.database.mysqli' );</source> | ||
− | + | ||
− | + | ||
− | |||
− | |||
===Examples=== | ===Examples=== | ||
− | + | === Code Examples === | |
<dpl> | <dpl> | ||
noresultsheader=\n | noresultsheader=\n | ||
category=JDatabaseMySQLi | category=JDatabaseMySQLi | ||
− | + | namespace=CodeExample | |
category=ClassExample | category=ClassExample | ||
include=* | include=* | ||
format= ,,, | format= ,,, | ||
</dpl> | </dpl> |
Latest revision as of 19:28, 24 March 2017
The "API15" 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 |
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) |
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 |
test | Test to see if the MySQLi connector is available |
Importing[edit]
jimport( 'joomla.database.database.mysqli' );
Examples[edit]
Code Examples[edit]