API16:JDatabaseMySQL - Revision history

Chris Davenport: Reverted edits by MaxineBlankenship (talk) to last revision by Doxiki

2012-01-17T16:55:28Z

Reverted edits by MaxineBlankenship (talk) to last revision by Doxiki

MaxineBlankenship at 10:33, 17 January 2012

2012-01-17T10:33:08Z

Doxiki at 10:04, 30 March 2010

2010-03-30T10:04:02Z

Doxiki: New page: [Edit Descripton] {{Description:JDatabaseMySQL}} ===Define...

2010-03-22T22:40:39Z

New page: <nowiki>[</nowiki>Edit Descripton<nowiki>]</nowiki> {{Description:JDatabaseMySQL}} ===Define...

New page

<nowiki>[</nowiki>[[Description:JDatabaseMySQL|Edit Descripton]]<nowiki>]</nowiki>

{{Description:JDatabaseMySQL}}

===Defined in===
libraries/joomla/database/database/mysql.php
===Methods===
{| class="wikitable sortable"
|-
!Method name
!Description
|-
|[[API16:JDatabaseMySQL/__construct|__construct]]
|Database object constructor
|-
|[[API16:JDatabaseMySQL/__destruct|__destruct]]
|Database object destructor
|-
|[[API16:JDatabaseMySQL/test|test]]
|Test to see if the MySQL connector is available
|-
|[[API16:JDatabaseMySQL/connected|connected]]
|Determines if the connection to the server is active.
|-
|[[API16:JDatabaseMySQL/select|select]]
|Select a database for use
|-
|[[API16:JDatabaseMySQL/hasUTF|hasUTF]]
|Determines UTF support
|-
|[[API16:JDatabaseMySQL/setUTF|setUTF]]
|Custom settings for UTF support
|-
|[[API16:JDatabaseMySQL/getEscaped|getEscaped]]
|Get a database escaped string
|-
|[[API16:JDatabaseMySQL/query|query]]
|Execute the query
|-
|[[API16:JDatabaseMySQL/getAffectedRows|getAffectedRows]]
|int The number of affected rows in the previous operation
1.0.5

|-
|[[API16:JDatabaseMySQL/queryBatch|queryBatch]]
|Execute a batch query
|-
|[[API16:JDatabaseMySQL/explain|explain]]
|Diagnostic function
|-
|[[API16:JDatabaseMySQL/getNumRows|getNumRows]]
|Description
|-
|[[API16:JDatabaseMySQL/loadResult|loadResult]]
|This method loads the first field of the first row returned by the query.
|-
|[[API16:JDatabaseMySQL/loadResultArray|loadResultArray]]
|Load an array of single field results into an array
|-
|[[API16:JDatabaseMySQL/loadAssoc|loadAssoc]]
|Fetch a result row as an associative array
|-
|[[API16:JDatabaseMySQL/loadAssocList|loadAssocList]]
|Load a assoc list of database rows.
|-
|[[API16:JDatabaseMySQL/loadObject|loadObject]]
|This global function loads the first row of a query into an object.
|-
|[[API16:JDatabaseMySQL/loadObjectList|loadObjectList]]
|Load a list of database objects
|-
|[[API16:JDatabaseMySQL/loadRow|loadRow]]
|Description
|-
|[[API16:JDatabaseMySQL/loadRowList|loadRowList]]
|Load a list of database rows (numeric column indexing)
|-
|[[API16:JDatabaseMySQL/loadNextRow|loadNextRow]]
|Load the next row returned by the query.
|-
|[[API16:JDatabaseMySQL/loadNextObject|loadNextObject]]
|Load the next row returned by the query.
|-
|[[API16:JDatabaseMySQL/insertObject|insertObject]]
|Inserts a row into a table based on an objects properties
|-
|[[API16:JDatabaseMySQL/updateObject|updateObject]]
|Description
|-
|[[API16:JDatabaseMySQL/insertid|insertid]]
|Description
|-
|[[API16:JDatabaseMySQL/getVersion|getVersion]]
|Description
|-
|[[API16:JDatabaseMySQL/getCollation|getCollation]]
|Assumes database collation in use by sampling one text field in one table
|-
|[[API16:JDatabaseMySQL/getTableList|getTableList]]
|Description
|-
|[[API16:JDatabaseMySQL/getTableCreate|getTableCreate]]
|Shows the CREATE TABLE statement that creates the given tables
|-
|[[API16:JDatabaseMySQL/getTableFields|getTableFields]]
|Retrieves information about the given tables
|}
===Importing===
<source lang="php">jimport( 'joomla.database.database.mysql' );</source>


<nowiki>[</nowiki>[[SeeAlso:JDatabaseMySQL|Edit See Also]]<nowiki>]</nowiki>

{{SeeAlso:JDatabaseMySQL}}

===Examples===
<CodeExamplesForm />
<dpl>
noresultsheader=\n
category=JDatabaseMySQL
category=CodeExample
category=ClassExample
include=*
format= ,,,
</dpl>

@@ Line 63: / Line 63: @@
 |-
 |[[API16:JDatabaseMySQL/loadAssocList|loadAssocList]]
-|Load a assoc list of database rows. EssaysExperts.Com is the company which first and main priority was, is and will be customers� satisfaction with the [http://www.essaysexperts.com essays online]. If you still have no idea where to buy your writing tasks, this company is the best option for you.
+|Load a assoc list of database rows.
 |-
 |[[API16:JDatabaseMySQL/loadObject|loadObject]]

@@ Line 107: / Line 107: @@
 |Retrieves information about the given tables
 |}
 ===Importing===
 <source lang="php">jimport( 'joomla.database.database.mysql' );</source>