JDatabaseMySQL
| API | Package | Subpackage | Class | Reference | Last reviewed | Doc status |
|---|---|---|---|---|---|---|
 Home |
 Joomla.Framework |
Database |
 JDatabaseMySQL |
 JDatabaseMySQL |
Never | Work in Progress |
MySQL database driver
Methods
| Method | Description |
|---|---|
 __construct | Database object constructor |
| __destruct | Database object destructor |
| connected | Determines if the connection to the server is active. |
| explain | Diagnostic function |
| getAffectedRows | |
| getCollation | Assumes database collation in use by sampling one text field in one table |
| getEscaped | Get a database escaped string |
| getNumRows | |
| getTableCreate | |
| getTableFields | |
| getTableList | |
| getVersion | |
| hasUTF | Determines UTF support |
| insertid | |
| insertObject | Inserts a row into a table based on an objects properties |
| loadAssoc | Fetch a result row as an associative array<p>return array</p> |
| loadAssocList | Load a assoc list of database rows |
| loadObject | This global function loads the first row of a query into an object<p>return object</p> |
| loadObjectList | Load a list of database objects |
| 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 |
| loadRow | |
| loadRowList | Load 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 | Test to see if the MySQL connector is available |
| updateObject | Document::db_updateObject() |