API17

Difference between revisions of "JDatabaseQuery"

From Joomla! Documentation

(Layout updates)
m (moving preparation)
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
__NOTOC__
 
__NOTOC__
 +
=={{JVer|11.1}} JDatabaseQuery==
 +
===Description===
 +
{{Description:JDatabaseQuery}}
 
<span class="editsection" style="font-size:76%;">
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[Description:JDatabaseQuery|Edit Descripton]]<nowiki>]</nowiki>
 
<nowiki>[</nowiki>[[Description:JDatabaseQuery|Edit Descripton]]<nowiki>]</nowiki>
 
</span>
 
</span>
−
{{Description:JDatabaseQuery}}
 
−
===Defined in===
 
−
libraries/joomla/database/databasequery.php
 
−
* see source code in [[jplatform:database/databasequery.php|BitBucket]]
 
−
===Subpackage===
 
−
[[Subpackage Database/11.1|Database]]
 
−
===Extends===
 
−
===Extended by===
 
 
===Methods===
 
===Methods===
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
 
|-
 
|-
 +
!Visibility
 
!Method name
 
!Method name
 
!Description
 
!Description
 
|-
 
|-
−
|[[JDatabaseQuery::__toString/11.1|__toString]]
+
|public
 +
|[[API17:JDatabaseQuery::__toString|__toString]]
 
|Magic function to convert the query to a string.  
 
|Magic function to convert the query to a string.  
 
|-
 
|-
−
|[[JDatabaseQuery::clear/11.1|clear]]
+
|public
 +
|[[API17:JDatabaseQuery::auto_increment|auto_increment]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::castToChar|castToChar]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::charLength|charLength]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::clear|clear]]
 
|Clear data from the query or a specific clause of the query.  
 
|Clear data from the query or a specific clause of the query.  
 
|-
 
|-
−
|[[JDatabaseQuery::delete/11.1|delete]]
+
|public
−
|Add a table name to the DELETE clause of the query.
+
|[[API17:JDatabaseQuery::concat|concat]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::delete|delete]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::dropIfExists|dropIfExists]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::fields|fields]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::from|from]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::group|group]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::having|having]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::innerJoin|innerJoin]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::insert|insert]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::insertInto|insertInto]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::join|join]]
 +
|
 +
|-
 +
|public
 +
|[[API17:JDatabaseQuery::leftJoin|leftJoin]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::from/11.1|from]]
+
|public
−
|Add a table to the FROM clause of the query.
+
|[[API17:JDatabaseQuery::length|length]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::group/11.1|group]]
+
|public
−
|Add a grouping column to the GROUP clause of the query.  
+
|[[API17:JDatabaseQuery::lock|lock]]
 +
|Method to lock the database table for writing.  
 
|-
 
|-
−
|[[JDatabaseQuery::having/11.1|having]]
+
|public
−
|A conditions to the HAVING clause of the query.
+
|[[API17:JDatabaseQuery::now|now]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::innerJoin/11.1|innerJoin]]
+
|public
−
|Add an INNER JOIN clause to the query.
+
|[[API17:JDatabaseQuery::order|order]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::insert/11.1|insert]]
+
|public
−
|Add a table name to the INSERT clause of the query.
+
|[[API17:JDatabaseQuery::outerJoin|outerJoin]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::join/11.1|join]]
+
|public
−
|Add a JOIN clause to the query.
+
|[[API17:JDatabaseQuery::renameTable|renameTable]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::leftJoin/11.1|leftJoin]]
+
|public
−
|Add a LEFT JOIN clause to the query.
+
|[[API17:JDatabaseQuery::rightJoin|rightJoin]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::order/11.1|order]]
+
|public
−
|Add a ordering column to the ORDER clause of the query.
+
|[[API17:JDatabaseQuery::select|select]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::outerJoin/11.1|outerJoin]]
+
|public
−
|Add an OUTER JOIN clause to the query.
+
|[[API17:JDatabaseQuery::set|set]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::rightJoin/11.1|rightJoin]]
+
|public
−
|Add a RIGHT JOIN clause to the query.
+
|[[API17:JDatabaseQuery::showTables|showTables]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::select/11.1|select]]
+
|public
−
|Add a single column, or array of columns to the SELECT clause of the query.  
+
|[[API17:JDatabaseQuery::unlock|unlock]]
 +
|Method to unlock the database table for writing.  
 
|-
 
|-
−
|[[JDatabaseQuery::set/11.1|set]]
+
|public
−
|Add a single condition string, or an array of strings to the SET clause of the query.
+
|[[API17:JDatabaseQuery::update|update]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::update/11.1|update]]
+
|public
−
|Add a table name to the UPDATE clause of the query.
+
|[[API17:JDatabaseQuery::values|values]]
 +
|
 
|-
 
|-
−
|[[JDatabaseQuery::where/11.1|where]]
+
|public
−
|Add a single condition, or an array of conditions to the WHERE clause of the query.
+
|[[API17:JDatabaseQuery::where|where]]
 +
|
 
|-
 
|-
 
|}
 
|}
 +
* '''Defined in''' libraries/joomla/database/databasequery.php
 +
* '''Extended by'''
 +
** [[API17:JDatabaseQueryMySQL|JDatabaseQueryMySQL]]
 +
** [[API17:JDatabaseQueryMySQLi|JDatabaseQueryMySQLi]]
 +
** [[API17:JDatabaseQuerySQLAzure|JDatabaseQuerySQLAzure]]
 +
** [[API17:JDatabaseQuerySQLSrv|JDatabaseQuerySQLSrv]]
 
===Importing===
 
===Importing===
 
<source lang="php">jimport( 'joomla.database.databasequery' );</source>
 
<source lang="php">jimport( 'joomla.database.databasequery' );</source>
 
===See also===
 
===See also===
−
* JDatabaseQuery source code in [[jplatform:database/databasequery.php|BitBucket]]
+
* {{JVer|11.1}} '''JDatabaseQuery source code''' on [[jplatform:database/databasequery.php|BitBucket]]
−
* [[JDatabaseQuery|Other versions of this class]]
+
* {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]]
 +
* [[API17:JDatabaseQuery|Other versions of JDatabaseQuery]]
 
{{SeeAlso:JDatabaseQuery}}
 
{{SeeAlso:JDatabaseQuery}}
 
<span class="editsection" style="font-size:76%;">
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[SeeAlso:JDatabaseQuery|Edit See Also]]<nowiki>]</nowiki>
 
<nowiki>[</nowiki>[[SeeAlso:JDatabaseQuery|Edit See Also]]<nowiki>]</nowiki>
 
</span>
 
</span>
−
===Examples===
+
===User contributed notes===
 
<CodeExamplesForm />
 
<CodeExamplesForm />
 
<dpl>
 
<dpl>
Line 86: Line 162:
 
category=ClassExample
 
category=ClassExample
 
include=*
 
include=*
 +
namespace=CodeExample
 
format= ,,,
 
format= ,,,
 
</dpl>
 
</dpl>
−
<noinclude>[[Category:Platform]][[Category:Platform 11.1]][[Category:JDatabaseQuery]]</noinclude>
+
<noinclude>[[Category:Platform 11.1]][[Category:Archived pages API17]]</noinclude>

Revision as of 20:13, 11 May 2013

The "API17" namespace is an archived namespace. This page contains information for a Joomla! version which is no longer supported. It exists only as a historical reference, it will not be improved and its content may be incomplete and/or contain broken links.

Joomla 11.1 JDatabaseQuery[edit]

Description[edit]

Template:Description:JDatabaseQuery [Edit Descripton]

Methods[edit]

Visibility Method name Description
public __toString Magic function to convert the query to a string.
public auto_increment
public castToChar
public charLength
public clear Clear data from the query or a specific clause of the query.
public concat
public delete
public dropIfExists
public fields
public from
public group
public having
public innerJoin
public insert
public insertInto
public join
public leftJoin
public length
public lock Method to lock the database table for writing.
public now
public order
public outerJoin
public renameTable
public rightJoin
public select
public set
public showTables
public unlock Method to unlock the database table for writing.
public update
public values
public where

Importing[edit]

jimport( 'joomla.database.databasequery' );

See also[edit]

Template:SeeAlso:JDatabaseQuery [Edit See Also]

User contributed notes[edit]

<CodeExamplesForm />


Retrieved from "https://docs.joomla.org/index.php?title=API17:JDatabaseQuery&oldid=95293"