Actions

API16

Difference between revisions of "JDatabaseMySQL"

From Joomla! Documentation

(New page: <span class="editsection" style="font-size:76%;"> <nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki> </span> {{Description:JDatabaseMySQL}} ===Define...)
 
m (Reverted edits by MaxineBlankenship (talk) to last revision by Doxiki)
 
(2 intermediate revisions by 2 users not shown)
Line 107: Line 107:
 
|Retrieves information about the given tables
 
|Retrieves information about the given tables
 
|}
 
|}
 +
 
===Importing===
 
===Importing===
 
<source lang="php">jimport( 'joomla.database.database.mysql' );</source>
 
<source lang="php">jimport( 'joomla.database.database.mysql' );</source>

Latest revision as of 11:55, 17 January 2012

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.

Contents

Defined in

libraries/joomla/database/database/mysql.php

Methods

Method name Description
__construct Database object constructor
__destruct Database object destructor
test Test to see if the MySQL connector is available
connected Determines if the connection to the server is active.
select Select a database for use
hasUTF Determines UTF support
setUTF Custom settings for UTF support
getEscaped Get a database escaped string
query Execute the query
getAffectedRows int The number of affected rows in the previous operation

1.0.5

queryBatch Execute a batch query
explain Diagnostic function
getNumRows Description
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
loadAssoc Fetch a result row as an associative array
loadAssocList Load a assoc list of database rows.
loadObject This global function loads the first row of a query into an object.
loadObjectList Load a list of database objects
loadRow Description
loadRowList Load a list of database rows (numeric column indexing)
loadNextRow Load the next row returned by the query.
loadNextObject Load the next row returned by the query.
insertObject Inserts a row into a table based on an objects properties
updateObject Description
insertid Description
getVersion Description
getCollation Assumes database collation in use by sampling one text field in one table
getTableList Description
getTableCreate Shows the CREATE TABLE statement that creates the given tables
getTableFields Retrieves information about the given tables

Importing

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

[Edit See Also] SeeAlso:JDatabaseMySQL

Examples

<CodeExamplesForm />