Difference between revisions of "JDatabaseMySQL"

From Joomla! Documentation

(Bulk upload by Doxiki2)
(Layout updates)
Line 6: Line 6:
===Defined in===
===Defined in===
* see source code in [[jplatform:database/database/mysql.php|BitBucket]]
[[Subpackage Database/11.1|Database]]
[[Subpackage Database/11.1|Database]]
Line 120: Line 121:
<source lang="php">jimport( 'joomla.database.database.mysql' );</source>
<source lang="php">jimport( 'joomla.database.database.mysql' );</source>
===See also===
===See also===
* JDatabaseMySQL source code in [[jplatform:database/database/mysql.php|BitBucket]]
* [[JDatabaseMySQL|Other versions of this class]]
* [[JDatabaseMySQL|Other versions of this class]]

Revision as of 17:51, 23 April 2011

Replacement filing cabinet.png
This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

[Edit Descripton] JDatabaseMySQL is a concrete database handler class for MySQL.

Defined in






Extended by


Method name Description
__construct Database object constructor.
__destruct Database object destructor.
connected Determines if the connection to the server is active.
explain Diagnostic function.
getCollation Assumes database collation in use by sampling one text field in one table.
getEscaped Get a database escaped string.
getExporter Gets an exporter class object.
getImporter Gets an exporter class object.
getNumRows Description.
getTableCreate Shows the CREATE TABLE statement that creates the given tables.
getTableFields Retrieves information about the given tables.
getTableList Description.
getVersion Description.
hasUTF Determines UTF support.
insertid Description.
insertObject Inserts a row into a table based on an objects properties.
loadAssoc Fetch a result row as an associative array.
loadAssocList Load a assoc list of database rows.
loadNextObject Load the next row returned by the query.
loadNextRow Load the next row returned by the query.
loadObject This global function loads the first row of a query into an object.
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 Description.
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 Description.


jimport( 'joomla.database.database.mysql' );

See also

SeeAlso:JDatabaseMySQL [Edit See Also]


<CodeExamplesForm />