JDatabaseMySQL - Revision history

JoomlaWikiBot: bad link repair

2012-08-29T18:33:55Z

bad link repair

Doxiki2: Updated to r1448:247ba8d88526

2011-04-27T23:13:15Z

Updated to r1448:247ba8d88526

Doxiki2: Layout updates

2011-04-25T23:16:22Z

Layout updates

Doxiki2: Bulk upload by Doxiki2

2011-04-20T21:01:57Z

Bulk upload by Doxiki2

Doxiki2: Bulk upload by Doxiki2

2011-04-17T21:25:37Z

Bulk upload by Doxiki2

Oc666 at 16:40, 23 February 2010

2010-02-23T16:40:41Z

Batch1211 at 21:03, 10 August 2009

2009-08-10T21:03:44Z

Batch1211: /* Methods */

2009-08-10T21:01:36Z

‎Methods

Batch1211: New page: '''JDatabaseMySQL''' is an concrete database handler class for MySQL. ===Availability=== {{JVer|1.5}} {{JVer|1.6}} ===Defined in=== /libraries/joomla/database/mysql.php ===Extends=== * ...

2009-08-10T20:58:45Z

New page: '''JDatabaseMySQL''' is an concrete database handler class for MySQL. ===Availability=== {{JVer|1.5}} {{JVer|1.6}} ===Defined in=== /libraries/joomla/database/mysql.php ===Extends=== * ...

New page

'''JDatabaseMySQL''' is an concrete database handler class for MySQL.

===Availability===
{{JVer|1.5}} {{JVer|1.6}}

===Defined in===
/libraries/joomla/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.
|-
|[[JDatabase/connected|connected]]
|Determines if the connection to the server is active.
|-
|[[JDatabase/explain|explain]]
|Diagnostic function.
|-
|[[JDatabase/getAffectedRows|getAffectedRows]]
|Get the number of rows affected by the most recent query.
|-
|[[JDatabase/GetCol|GetCol]]
|ADODB compatibility function.
|-
|[[JDatabase/getCollation|getCollation]]
|Get the database collation.
|-
|[[JDatabase/getConnectors|getConnectors]]
|Get the database connectors.
|-
|[[JDatabase/getEscaped|getEscaped]]
|Get a database escaped string.
|-
|[[JDatabase/getNumRows|getNumRows]]
|Get the number of rows returned by the most recent query.
|-
|[[JDatabase/getTableCreate|getTableCreate]]
|Shows the CREATE TABLE statement that creates the given tables.
|-
|[[JDatabase/getTableFields|getTableFields]]
|Retrieves information about the given tables.
|-
|[[JDatabase/getTableList|getTableList]]
|Lists tables in a database.
|-
|[[JDatabase/getVersion|getVersion]]
|Get the version of the database connector.
|-
|[[JDatabase/hasUTF|hasUTF]]
|Determines UTF support.
|-
|[[JDatabase/insertid|insertid]]
|Gets the ID generated from the previous INSERT operation.
|-
|[[JDatabase/insertObject|insertObject]]
|Inserts a row into a table based on an objects properties.
|-
|[[JDatabase/loadAssoc|loadAssoc]]
|Fetch a result row as an associative array.
|-
|[[JDatabase/loadAssocList|loadAssocList]]
|Loads an associative list of database rows.
|-
|[[JDatabase/loadObject|loadObject]]
|Loads the first row of a query into an object.
|-
|[[JDatabase/loadObjectList|loadObjectList]]
|Loads a list of database objects.
|-
|[[JDatabase/loadResult|loadResult]]
|Loads the first field of the first row returned by the query.
|-
|[[JDatabase/loadResultArray|loadResultArray]]
|Loads an array of single field results into an array.
|-
|[[JDatabase/loadRow|loadRow]]
|Loads the first row returned by the query.
|-
|[[JDatabase/loadRowList|loadRowList]]
|Loads a list of database rows (numeric column indexing).
|-
|[[JDatabase/query|query]]
|Execute the query.
|-
|[[JDatabase/queryBatch|queryBatch]]
|Execute a batch query.
|-
|[[JDatabase/select|select]]
|Select a database for use
|-
|[[JDatabase/setUTF|setUTF]]
|Custom settings for UTF support.
|-
|[[JDatabase/test|test]]
|Tests to see if the connector is available.
|-
|[[JDatabase/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>

@@ Line 1: / Line 1: @@
 This class is available in the following Joomla versions:-
 <splist showpath=notparent />
-<noinclude>[[Category:Platform]][[Category:JDatabaseMySQL]]</noinclude>
+<noinclude>[[Category:Platform JClasses]][[Category:JDatabaseMySQL]]</noinclude>

@@ Line 1: / Line 1: @@
 This class is available in the following Joomla versions:-
 <splist showpath=notparent />
-<noinclude>[[Category:Framework]][[Category:JDatabaseMySQL]]</noinclude>
+<noinclude>[[Category:Platform]][[Category:JDatabaseMySQL]]</noinclude>

@@ Line 1: / Line 1: @@
 This class is available in the following Joomla versions:-
 <splist showpath=notparent />
-<noinclude>[[Category:Platform]][[Category:JDatabaseMySQL]]</noinclude>
+<noinclude>[[Category:Framework]][[Category:JDatabaseMySQL]]</noinclude>

@@ Line 1: / Line 1: @@
 This class is available in the following Joomla versions:-
 <splist showpath=notparent />
-<noinclude>[[Category:Framework]][[Category:JDatabaseMySQL]]</noinclude>
+<noinclude>[[Category:Platform]][[Category:JDatabaseMySQL]]</noinclude>

← Older revision		Revision as of 21:03, 10 August 2009
Line 1:		Line 1:
−	'''JDatabaseMySQL''' is an concrete database handler class for MySQL.	+	'''JDatabaseMySQL''' is an concrete database handler class for [http://www.mysql.com/ MySQL].

	===Availability===		===Availability===

@@ 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>