JDatabaseMySQL/1.5

From Joomla! Documentation
< JDatabaseMySQL(Difference between revisions)
Jump to: navigation, search
(Bulk upload by Doxiki2)
 
(Layout updates)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
 +
=={{JVer|1.5}} JDatabaseMySQL==
 +
===Description===
 +
{{Description:JDatabaseMySQL}}
 
<span class="editsection" style="font-size:76%;">
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[Description:JDatabaseMySQL|Edit Descripton]]<nowiki>]</nowiki>
 
<nowiki>[</nowiki>[[Description:JDatabaseMySQL|Edit Descripton]]<nowiki>]</nowiki>
 
</span>
 
</span>
−
{{Description:JDatabaseMySQL}}
 
−
===Defined in===
 
−
libraries/joomla/database/database/mysql.php
 
−
===Subpackage===
 
−
[[Subpackage Database/1.5|Database]]
 
−
===Extends===
 
−
[[JDatabase/1.5|JDatabase]]
 
−
===Extended by===
 
 
===Methods===
 
===Methods===
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
 
|-
 
|-
 +
!Visibility
 
!Method name
 
!Method name
 
!Description
 
!Description
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::__construct/1.5|__construct]]
 
|[[JDatabaseMySQL::__construct/1.5|__construct]]
 
|Database object constructor.  
 
|Database object constructor.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::__destruct/1.5|__destruct]]
 
|[[JDatabaseMySQL::__destruct/1.5|__destruct]]
 
|Database object destructor.  
 
|Database object destructor.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::connected/1.5|connected]]
 
|[[JDatabaseMySQL::connected/1.5|connected]]
 
|Determines if the connection to the server is active.  
 
|Determines if the connection to the server is active.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::explain/1.5|explain]]
 
|[[JDatabaseMySQL::explain/1.5|explain]]
 
|Diagnostic function.  
 
|Diagnostic function.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::getAffectedRows/1.5|getAffectedRows]]
 
|[[JDatabaseMySQL::getAffectedRows/1.5|getAffectedRows]]
 
|Description.  
 
|Description.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::getCollation/1.5|getCollation]]
 
|[[JDatabaseMySQL::getCollation/1.5|getCollation]]
 
|Assumes database collation in use by sampling one text field in one table.  
 
|Assumes database collation in use by sampling one text field in one table.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::getEscaped/1.5|getEscaped]]
 
|[[JDatabaseMySQL::getEscaped/1.5|getEscaped]]
 
|Get a database escaped string.  
 
|Get a database escaped string.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::getNumRows/1.5|getNumRows]]
 
|[[JDatabaseMySQL::getNumRows/1.5|getNumRows]]
 
|Description.  
 
|Description.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::getTableCreate/1.5|getTableCreate]]
 
|[[JDatabaseMySQL::getTableCreate/1.5|getTableCreate]]
 
|Shows the CREATE TABLE statement that creates the given tables.  
 
|Shows the CREATE TABLE statement that creates the given tables.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::getTableFields/1.5|getTableFields]]
 
|[[JDatabaseMySQL::getTableFields/1.5|getTableFields]]
 
|Retrieves information about the given tables.  
 
|Retrieves information about the given tables.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::getTableList/1.5|getTableList]]
 
|[[JDatabaseMySQL::getTableList/1.5|getTableList]]
 
|Description.  
 
|Description.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::getVersion/1.5|getVersion]]
 
|[[JDatabaseMySQL::getVersion/1.5|getVersion]]
 
|Description.  
 
|Description.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::hasUTF/1.5|hasUTF]]
 
|[[JDatabaseMySQL::hasUTF/1.5|hasUTF]]
 
|Determines UTF support.  
 
|Determines UTF support.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::insertid/1.5|insertid]]
 
|[[JDatabaseMySQL::insertid/1.5|insertid]]
 
|Description.  
 
|Description.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::insertObject/1.5|insertObject]]
 
|[[JDatabaseMySQL::insertObject/1.5|insertObject]]
 
|Inserts a row into a table based on an objects properties.  
 
|Inserts a row into a table based on an objects properties.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::loadAssoc/1.5|loadAssoc]]
 
|[[JDatabaseMySQL::loadAssoc/1.5|loadAssoc]]
 
|Fetch a result row as an associative array.  
 
|Fetch a result row as an associative array.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::loadAssocList/1.5|loadAssocList]]
 
|[[JDatabaseMySQL::loadAssocList/1.5|loadAssocList]]
 
|Load a assoc list of database rows.  
 
|Load a assoc list of database rows.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::loadObject/1.5|loadObject]]
 
|[[JDatabaseMySQL::loadObject/1.5|loadObject]]
 
|This global function loads the first row of a query into an object.  
 
|This global function loads the first row of a query into an object.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::loadObjectList/1.5|loadObjectList]]
 
|[[JDatabaseMySQL::loadObjectList/1.5|loadObjectList]]
 
|Load a list of database objects.  
 
|Load a list of database objects.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::loadResult/1.5|loadResult]]
 
|[[JDatabaseMySQL::loadResult/1.5|loadResult]]
 
|This method loads the first field of the first row returned by the query.  
 
|This method loads the first field of the first row returned by the query.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::loadResultArray/1.5|loadResultArray]]
 
|[[JDatabaseMySQL::loadResultArray/1.5|loadResultArray]]
 
|Load an array of single field results into an array.  
 
|Load an array of single field results into an array.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::loadRow/1.5|loadRow]]
 
|[[JDatabaseMySQL::loadRow/1.5|loadRow]]
 
|Description.  
 
|Description.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::loadRowList/1.5|loadRowList]]
 
|[[JDatabaseMySQL::loadRowList/1.5|loadRowList]]
 
|Load a list of database rows (numeric column indexing).  
 
|Load a list of database rows (numeric column indexing).  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::query/1.5|query]]
 
|[[JDatabaseMySQL::query/1.5|query]]
 
|Execute the query.  
 
|Execute the query.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::queryBatch/1.5|queryBatch]]
 
|[[JDatabaseMySQL::queryBatch/1.5|queryBatch]]
 
|Execute a batch query.  
 
|Execute a batch query.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::select/1.5|select]]
 
|[[JDatabaseMySQL::select/1.5|select]]
 
|Select a database for use.  
 
|Select a database for use.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::setUTF/1.5|setUTF]]
 
|[[JDatabaseMySQL::setUTF/1.5|setUTF]]
 
|Custom settings for UTF support.  
 
|Custom settings for UTF support.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::updateObject/1.5|updateObject]]
 
|[[JDatabaseMySQL::updateObject/1.5|updateObject]]
 
|Description.  
 
|Description.  
 
|-
 
|-
 +
|public
 
|[[JDatabaseMySQL::test/1.5|test]]
 
|[[JDatabaseMySQL::test/1.5|test]]
 
|Test to see if the MySQL connector is available.  
 
|Test to see if the MySQL connector is available.  
 
|-
 
|-
 
|}
 
|}
 +
* '''Defined in''' libraries/joomla/database/database/mysql.php
 +
* '''Extends''' [[JDatabase/1.5|JDatabase]]
 
===Importing===
 
===Importing===
 
<source lang="php">jimport( 'joomla.database.database.mysql' );</source>
 
<source lang="php">jimport( 'joomla.database.database.mysql' );</source>
 
===See also===
 
===See also===
 +
* {{JVer|1.5}} '''JDatabaseMySQL''' on [http://api.joomla.org/Joomla-Framework/Database/JDatabaseMySQL.html api.joomla.org]
 +
* {{JVer|1.5}} '''JDatabaseMySQL source code''' on [[jframework15:database/database/mysql.php|JoomlaCode]]
 +
* {{JVer|1.5}} Subpackage [[Subpackage Database/1.5|Database]]
 +
* [[JDatabaseMySQL|Other versions of JDatabaseMySQL]]
 +
{{SeeAlso:JDatabaseMySQL}}
 
<span class="editsection" style="font-size:76%;">
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[SeeAlso:JDatabaseMySQL|Edit See Also]]<nowiki>]</nowiki>
 
<nowiki>[</nowiki>[[SeeAlso:JDatabaseMySQL|Edit See Also]]<nowiki>]</nowiki>
 
</span>
 
</span>
−
{{SeeAlso:JDatabaseMySQL}}
+
===User contributed notes===
−
* [[JDatabaseMySQL|Other versions of this class]]
+
−
* [http://api.joomla.org/Joomla-Framework/Database/JDatabaseMySQL.html JDatabaseMySQL on api.joomla.org]
+
−
===Examples===
+
 
<CodeExamplesForm />
 
<CodeExamplesForm />
 
<dpl>
 
<dpl>
Line 122: Line 151:
 
category=ClassExample
 
category=ClassExample
 
include=*
 
include=*
 +
namespace=CodeExample
 
format= ,,,
 
format= ,,,
 
</dpl>
 
</dpl>
 
<noinclude>[[Category:Framework]][[Category:Framework 1.5]][[Category:JDatabaseMySQL]]</noinclude>
 
<noinclude>[[Category:Framework]][[Category:Framework 1.5]][[Category:JDatabaseMySQL]]</noinclude>

Revision as of 18:07, 25 April 2011

Joomla 1.5 JDatabaseMySQL

Description

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

Methods

Visibility Method name Description
public __construct Database object constructor.
public __destruct Database object destructor.
public connected Determines if the connection to the server is active.
public explain Diagnostic function.
public getAffectedRows Description.
public getCollation Assumes database collation in use by sampling one text field in one table.
public getEscaped Get a database escaped string.
public getNumRows Description.
public getTableCreate Shows the CREATE TABLE statement that creates the given tables.
public getTableFields Retrieves information about the given tables.
public getTableList Description.
public getVersion Description.
public hasUTF Determines UTF support.
public insertid Description.
public insertObject Inserts a row into a table based on an objects properties.
public loadAssoc Fetch a result row as an associative array.
public loadAssocList Load a assoc list of database rows.
public loadObject This global function loads the first row of a query into an object.
public loadObjectList Load a list of database objects.
public loadResult This method loads the first field of the first row returned by the query.
public loadResultArray Load an array of single field results into an array.
public loadRow Description.
public loadRowList Load a list of database rows (numeric column indexing).
public query Execute the query.
public queryBatch Execute a batch query.
public select Select a database for use.
public setUTF Custom settings for UTF support.
public updateObject Description.
public test Test to see if the MySQL connector is available.
  • Defined in libraries/joomla/database/database/mysql.php
  • Extends JDatabase

Importing

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

See also

SeeAlso:JDatabaseMySQL [Edit See Also]

User contributed notes

<CodeExamplesForm />


Retrieved from "http://docs.joomla.org/index.php?title=JDatabaseMySQL/1.5&oldid=51019"
Personal tools
Namespaces

Variants
Actions
Navigation
Joomla! Sites
Toolbox