JoomlaWikiBot: /* See also */fixing link to API

2013-02-13T19:17:30Z

‎See also: fixing link to API

Doxiki2: Layout updates

2011-04-25T23:07:00Z

Layout updates

Show changes

Doxiki2: Bulk upload by Doxiki2

2011-04-17T21:16:35Z

Bulk upload by Doxiki2

New page

__NOTOC__
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>[[Description:JDatabase|Edit Descripton]]<nowiki>]</nowiki>
</span>
{{Description:JDatabase}}
===Defined in===
libraries/joomla/database/database.php
===Subpackage===
[[Subpackage Database/1.5|Database]]
===Extends===
[[JObject/1.5|JObject]]
===Extended by===
* [[JDatabaseMySQL/1.5|JDatabaseMySQL]]
* [[JDatabaseMySQLi/1.5|JDatabaseMySQLi]]
===Methods===
{| class="wikitable sortable"
|-
!Method name
!Description
|-
|[[JDatabase::__construct/1.5|__construct]]
|Database object constructor.
|-
|[[JDatabase::__destruct/1.5|__destruct]]
|Database object destructor.
|-
|[[JDatabase::addQuoted/1.5|addQuoted]]
|Adds a field or array of field names to the list that are to be quoted.
|-
|[[JDatabase::BeginTrans/1.5|BeginTrans]]
|ADODB compatability function.
|-
|[[JDatabase::CommitTrans/1.5|CommitTrans]]
|ADODB compatability function.
|-
|[[JDatabase::connected/1.5|connected]]
|Determines if the connection to the server is active.
|-
|[[JDatabase::debug/1.5|debug]]
|Sets the debug level on or off.
|-
|[[JDatabase::ErrorMsg/1.5|ErrorMsg]]
|ADODB compatability function.
|-
|[[JDatabase::ErrorNo/1.5|ErrorNo]]
|ADODB compatability function.
|-
|[[JDatabase::Execute/1.5|Execute]]
|ADODB compatability function.
|-
|[[JDatabase::explain/1.5|explain]]
|Diagnostic function.
|-
|[[JDatabase::GenID/1.5|GenID]]
|ADODB compatability function.
|-
|[[JDatabase::getAffectedRows/1.5|getAffectedRows]]
|Get the affected rows by the most recent query.
|-
|[[JDatabase::GetCol/1.5|GetCol]]
|ADODB compatability function.
|-
|[[JDatabase::getCollation/1.5|getCollation]]
|Get the database collation.
|-
|[[JDatabase::getConnectors/1.5|getConnectors]]
|Get the database connectors.
|-
|[[JDatabase::getErrorMsg/1.5|getErrorMsg]]
|Get the error message.
|-
|[[JDatabase::getErrorNum/1.5|getErrorNum]]
|Get the error number.
|-
|[[JDatabase::getEscaped/1.5|getEscaped]]
|Get a database escaped string.
|-
|[[JDatabase::getInstance/1.5|getInstance]]
|Returns a reference to the global Database object, only creating it if it doesn't already exist.
|-
|[[JDatabase::getLog/1.5|getLog]]
|Get a database error log.
|-
|[[JDatabase::getNullDate/1.5|getNullDate]]
|Get the database null date.
|-
|[[JDatabase::getNumRows/1.5|getNumRows]]
|Get the number of rows returned by the most recent query.
|-
|[[JDatabase::GetOne/1.5|GetOne]]
|ADODB compatability function.
|-
|[[JDatabase::getPrefix/1.5|getPrefix]]
|Get the database table prefix.
|-
|[[JDatabase::getQuery/1.5|getQuery]]
|Get the active query.
|-
|[[JDatabase::GetRow/1.5|GetRow]]
|ADODB compatability function.
|-
|[[JDatabase::getTableCreate/1.5|getTableCreate]]
|Shows the CREATE TABLE statement that creates the given tables.
|-
|[[JDatabase::getTableFields/1.5|getTableFields]]
|Retrieves information about the given tables.
|-
|[[JDatabase::getTableList/1.5|getTableList]]
|List tables in a database.
|-
|[[JDatabase::getTicker/1.5|getTicker]]
|Get the total number of queries made.
|-
|[[JDatabase::getUTFSupport/1.5|getUTFSupport]]
|Get the database UTF-8 support.
|-
|[[JDatabase::getVersion/1.5|getVersion]]
|Get the version of the database connector.
|-
|[[JDatabase::hasUTF/1.5|hasUTF]]
|Determines UTF support.
|-
|[[JDatabase::insertid/1.5|insertid]]
|Get the ID generated from the previous INSERT operation.
|-
|[[JDatabase::insertObject/1.5|insertObject]]
|Inserts a row into a table based on an objects properties.
|-
|[[JDatabase::isQuoted/1.5|isQuoted]]
|Checks if field name needs to be quoted.
|-
|[[JDatabase::loadAssoc/1.5|loadAssoc]]
|Fetch a result row as an associative array.
|-
|[[JDatabase::loadAssocList/1.5|loadAssocList]]
|Load a associactive list of database rows.
|-
|[[JDatabase::loadObject/1.5|loadObject]]
|This global function loads the first row of a query into an object.
|-
|[[JDatabase::loadObjectList/1.5|loadObjectList]]
|Load a list of database objects.
|-
|[[JDatabase::loadResult/1.5|loadResult]]
|This method loads the first field of the first row returned by the query.
|-
|[[JDatabase::loadResultArray/1.5|loadResultArray]]
|Load an array of single field results into an array.
|-
|[[JDatabase::loadRow/1.5|loadRow]]
|Load the first row returned by the query.
|-
|[[JDatabase::loadRowList/1.5|loadRowList]]
|Load a list of database rows (numeric column indexing).
|-
|[[JDatabase::nameQuote/1.5|nameQuote]]
|Quote an identifier name (field, table, etc).
|-
|[[JDatabase::PageExecute/1.5|PageExecute]]
|ADODB compatability function.
|-
|[[JDatabase::query/1.5|query]]
|Execute the query.
|-
|[[JDatabase::queryBatch/1.5|queryBatch]]
|Execute a batch query.
|-
|[[JDatabase::Quote/1.5|Quote]]
|Get a quoted database escaped string.
|-
|[[JDatabase::replacePrefix/1.5|replacePrefix]]
|This function replaces a string identifier with the string held is the class variable.
|-
|[[JDatabase::RollbackTrans/1.5|RollbackTrans]]
|ADODB compatability function.
|-
|[[JDatabase::SelectLimit/1.5|SelectLimit]]
|ADODB compatability function.
|-
|[[JDatabase::setQuery/1.5|setQuery]]
|Sets the SQL query string for later execution.
|-
|[[JDatabase::setUTF/1.5|setUTF]]
|Custom settings for UTF support.
|-
|[[JDatabase::splitSql/1.5|splitSql]]
|Splits a string of queries into an array of individual queries.
|-
|[[JDatabase::stderr/1.5|stderr]]
|Print out an error statement.
|-
|[[JDatabase::updateObject/1.5|updateObject]]
|Update an object in the database.
|-
|[[JDatabase::test/1.5|test]]
|Test to see if the MySQLi connector is available.
|-
|}
===Importing===
<source lang="php">jimport( 'joomla.database.database' );</source>
===See also===
<span class="editsection" style="font-size:76%;">
<nowiki>[</nowiki>[[SeeAlso:JDatabase|Edit See Also]]<nowiki>]</nowiki>
</span>
{{SeeAlso:JDatabase}}
* [[JDatabase|Other versions of this class]]
* [http://api.joomla.org/Joomla-Framework/Database/JDatabase.html JDatabase on api.joomla.org]
===Examples===
<CodeExamplesForm />
<dpl>
noresultsheader=\n
category=JDatabase
category=CodeExample
category=ClassExample
include=*
format= ,,,
</dpl>
<noinclude>[[Category:Framework]][[Category:Framework 1.5]][[Category:JDatabase]]</noinclude>

@@ Line 258: / Line 258: @@
 <source lang="php">jimport( 'joomla.database.database' );</source>
 ===See also===
-* {{JVer|1.5}} '''JDatabase''' on [http://api.joomla.org/Joomla-Framework/Database/JDatabase.html api.joomla.org]
+* {{JVer|1.5}} '''JDatabase''' on [http://api.joomla.org/1.5/Joomla-Framework/Database/JDatabase.html api.joomla.org]
 * {{JVer|1.5}} '''JDatabase source code''' on [[jframework15:database/database.php|JoomlaCode]]
 * {{JVer|1.5}} Subpackage [[Subpackage Database/1.5|Database]]

JDatabase/1.5 - Revision history

JoomlaWikiBot: /* See also */fixing link to API

Doxiki2: Layout updates

Doxiki2: Bulk upload by Doxiki2