Difference between revisions of "JDatabaseMySQL"
From Joomla! Documentation
m (preparing for archive only) |
|||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | [[JDatabaseMySQL]] is a concrete database handler class for [http://www.mysql.com/ MySQL]. | |
| − | |||
| − | |||
| − | |||
===Defined in=== | ===Defined in=== | ||
| Line 63: | Line 60: | ||
|- | |- | ||
|[[API16:JDatabaseMySQL/loadAssocList|loadAssocList]] | |[[API16:JDatabaseMySQL/loadAssocList|loadAssocList]] | ||
| − | |Load a assoc list of database rows | + | |Load a assoc list of database rows. |
|- | |- | ||
|[[API16:JDatabaseMySQL/loadObject|loadObject]] | |[[API16:JDatabaseMySQL/loadObject|loadObject]] | ||
| Line 111: | Line 108: | ||
<source lang="php">jimport( 'joomla.database.database.mysql' );</source> | <source lang="php">jimport( 'joomla.database.database.mysql' );</source> | ||
| − | + | ||
| − | + | ||
| − | |||
| − | |||
===Examples=== | ===Examples=== | ||
| − | + | === Code Examples === | |
<dpl> | <dpl> | ||
noresultsheader=\n | noresultsheader=\n | ||
category=JDatabaseMySQL | category=JDatabaseMySQL | ||
| − | + | namespace=CodeExample | |
category=ClassExample | category=ClassExample | ||
include=* | include=* | ||
format= ,,, | format= ,,, | ||
</dpl> | </dpl> | ||
Latest revision as of 20:27, 24 March 2017
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.
JDatabaseMySQL is a concrete database handler class for MySQL.
Defined in[edit]
libraries/joomla/database/database/mysql.php
Methods[edit]
| Method name | Description |
|---|---|
| __construct | Database object constructor |
| __destruct | Database object destructor |
| test | Test to see if the MySQL 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 | int The number of affected rows in the previous operation
1.0.5 |
| 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.mysql' );
Examples[edit]
Code Examples[edit]