JDatabaseMySQL
From Joomla! Documentation
JDatabaseMySQL is an concrete database handler class for MySQL.
Contents |
Availability
Defined in
/libraries/joomla/database/mysql.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. |
| GetCol | ADODB compatibility function. |
| getCollation | Get the database collation. |
| getConnectors | Get the database connectors. |
| 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.mysql' );
