API17:JDatabaseMySQL

Defined in

libraries/joomla/database/database/mysql.php

• see source code in BitBucket

Subpackage

Database

Extends

JDatabase

Methods

Method name	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.
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.

Importing

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

See also

• JDatabaseMySQL source code in BitBucket
• Other versions of this class

Examples

<CodeExamplesForm />