|
|
| Line 1: |
Line 1: |
| − | '''JDatabaseMySQL''' is an concrete database handler class for [http://www.mysql.com/ MySQL].
| + | This class is available in the following Joomla versions:- |
| − | | + | <splist showpath=notparent /> |
| − | ===Availability===
| + | <noinclude>[[Category:Framework]][[Category:JDatabaseMySQL]]</noinclude> |
| − | {{JVer|1.5}} {{JVer|1.6}}
| + | |
| − | | + | |
| − | ===Defined in===
| + | |
| − | /libraries/joomla/database/database/mysql.php
| + | |
| − | | + | |
| − | ===Extends===
| + | |
| − | * [[JObject]]
| + | |
| − | * [[JDatabase]]
| + | |
| − | | + | |
| − | ===Methods===
| + | |
| − | Properties which do not have specific get or set methods listed here can be retrieved or set using the inherited [[JObject/get|JObject->get]] method.
| + | |
| − | {| class="wikitable"
| + | |
| − | |-
| + | |
| − | !Method name
| + | |
| − | !Description
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/__construct|__construct]]
| + | |
| − | |Constrctor. Takes database login information, and tries to connecto with the database.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/__destruct|__destruct]]
| + | |
| − | |Destructor. Makes sure database connection is closed at the end of script.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/connected|connected]]
| + | |
| − | |Determines if the connection to the server is active.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/explain|explain]]
| + | |
| − | |Diagnostic function.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/getAffectedRows|getAffectedRows]]
| + | |
| − | |Get the number of rows affected by the most recent query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/getCollation|getCollation]]
| + | |
| − | |Get the database collation.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/getEscaped|getEscaped]]
| + | |
| − | |Get a database escaped string.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/getNumRows|getNumRows]]
| + | |
| − | |Get the number of rows returned by the most recent query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/getTableCreate|getTableCreate]]
| + | |
| − | |Shows the CREATE TABLE statement that creates the given tables.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/getTableFields|getTableFields]]
| + | |
| − | |Retrieves information about the given tables.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/getTableList|getTableList]]
| + | |
| − | |Lists tables in a database.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/getVersion|getVersion]]
| + | |
| − | |Get the version of the database connector.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/hasUTF|hasUTF]]
| + | |
| − | |Determines UTF support.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/insertid|insertid]]
| + | |
| − | |Gets the ID generated from the previous INSERT operation.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/insertObject|insertObject]]
| + | |
| − | |Inserts a row into a table based on an objects properties.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/loadAssoc|loadAssoc]]
| + | |
| − | |Fetch a result row as an associative array.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/loadAssocList|loadAssocList]]
| + | |
| − | |Loads an associative list of database rows.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/loadObject|loadObject]]
| + | |
| − | |Loads the first row of a query into an object.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/loadObjectList|loadObjectList]]
| + | |
| − | |Loads a list of database objects.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/loadResult|loadResult]]
| + | |
| − | |Loads the first field of the first row returned by the query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/loadResultArray|loadResultArray]]
| + | |
| − | |Loads an array of single field results into an array.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/loadRow|loadRow]]
| + | |
| − | |Loads the first row returned by the query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/loadRowList|loadRowList]]
| + | |
| − | |Loads a list of database rows (numeric column indexing).
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/query|query]]
| + | |
| − | |Execute the query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/queryBatch|queryBatch]]
| + | |
| − | |Execute a batch query.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/select|select]]
| + | |
| − | |Select a database for use
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/setUTF|setUTF]]
| + | |
| − | |Custom settings for UTF support.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/test|test]]
| + | |
| − | |Tests to see if the connector is available.
| + | |
| − | |-
| + | |
| − | |[[JDatabaseMySQL/updateObject|updateObject]]
| + | |
| − | |Updates an object in the database.
| + | |
| − | |}
| + | |
| − | | + | |
| − | ===Importing===
| + | |
| − | <source lang="php">jimport( 'joomla.database.mysql' );</source> | + | |
| − | | + | |
| − | ===See also===
| + | |
| − | * [[How to use the database classes in your script]]
| + | |
| − | * [http://api.joomla.org/Joomla-Framework/Database/JDatabaseMySQL.html JDatabaseMySQL on api.joomla.org]
| + | |
| − | * [[JDatabaseMySQL]]
| + | |
| − | * [[JDatabaseMySQLi]]
| + | |
| − | <noinclude>[[Category:Development]][[Category:Framework]][[Category:JDatabase]]</noinclude> | + | |
