Actions

API17

Difference between revisions of "JDatabaseQuery"

From Joomla! Documentation

(Bulk upload by Doxiki2)
 
m (User contributed notes: bad link repair)
(2 intermediate revisions by one user 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
 
===Subpackage===
 
[[Subpackage Database/11.1|Database]]
 
===Extends===
 
===Extended by===
 
 
===Methods===
 
===Methods===
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
 
|-
 
|-
 +
!Visibility
 
!Method name
 
!Method name
 
!Description
 
!Description
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::__toString/11.1|__toString]]
 
|[[JDatabaseQuery::__toString/11.1|__toString]]
 
|Magic function to convert the query to a string.  
 
|Magic function to convert the query to a string.  
 
|-
 
|-
 +
|public
 +
|[[JDatabaseQuery::auto_increment/11.1|auto_increment]]
 +
|
 +
|-
 +
|public
 +
|[[JDatabaseQuery::castToChar/11.1|castToChar]]
 +
|
 +
|-
 +
|public
 +
|[[JDatabaseQuery::charLength/11.1|charLength]]
 +
|
 +
|-
 +
|public
 
|[[JDatabaseQuery::clear/11.1|clear]]
 
|[[JDatabaseQuery::clear/11.1|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.  
 
|-
 
|-
 +
|public
 +
|[[JDatabaseQuery::concat/11.1|concat]]
 +
|
 +
|-
 +
|public
 
|[[JDatabaseQuery::delete/11.1|delete]]
 
|[[JDatabaseQuery::delete/11.1|delete]]
|Add a table name to the DELETE clause of the query.
+
|
 
|-
 
|-
 +
|public
 +
|[[JDatabaseQuery::dropIfExists/11.1|dropIfExists]]
 +
|
 +
|-
 +
|public
 +
|[[JDatabaseQuery::fields/11.1|fields]]
 +
|
 +
|-
 +
|public
 
|[[JDatabaseQuery::from/11.1|from]]
 
|[[JDatabaseQuery::from/11.1|from]]
|Add a table to the FROM clause of the query.
+
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::group/11.1|group]]
 
|[[JDatabaseQuery::group/11.1|group]]
|Add a grouping column to the GROUP clause of the query.
+
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::having/11.1|having]]
 
|[[JDatabaseQuery::having/11.1|having]]
|A conditions to the HAVING clause of the query.
+
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::innerJoin/11.1|innerJoin]]
 
|[[JDatabaseQuery::innerJoin/11.1|innerJoin]]
|Add an INNER JOIN clause to the query.
+
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::insert/11.1|insert]]
 
|[[JDatabaseQuery::insert/11.1|insert]]
|Add a table name to the INSERT clause of the query.
+
|
 
|-
 
|-
 +
|public
 +
|[[JDatabaseQuery::insertInto/11.1|insertInto]]
 +
|
 +
|-
 +
|public
 
|[[JDatabaseQuery::join/11.1|join]]
 
|[[JDatabaseQuery::join/11.1|join]]
|Add a JOIN clause to the query.
+
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::leftJoin/11.1|leftJoin]]
 
|[[JDatabaseQuery::leftJoin/11.1|leftJoin]]
|Add a LEFT JOIN clause to the query.  
+
|
 +
|-
 +
|public
 +
|[[JDatabaseQuery::length/11.1|length]]
 +
|
 +
|-
 +
|public
 +
|[[JDatabaseQuery::lock/11.1|lock]]
 +
|Method to lock the database table for writing.
 +
|-
 +
|public
 +
|[[JDatabaseQuery::now/11.1|now]]
 +
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::order/11.1|order]]
 
|[[JDatabaseQuery::order/11.1|order]]
|Add a ordering column to the ORDER clause of the query.
+
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::outerJoin/11.1|outerJoin]]
 
|[[JDatabaseQuery::outerJoin/11.1|outerJoin]]
|Add an OUTER JOIN clause to the query.
+
|
 
|-
 
|-
 +
|public
 +
|[[JDatabaseQuery::renameTable/11.1|renameTable]]
 +
|
 +
|-
 +
|public
 
|[[JDatabaseQuery::rightJoin/11.1|rightJoin]]
 
|[[JDatabaseQuery::rightJoin/11.1|rightJoin]]
|Add a RIGHT JOIN clause to the query.
+
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::select/11.1|select]]
 
|[[JDatabaseQuery::select/11.1|select]]
|Add a single column, or array of columns to the SELECT clause of the query.
+
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::set/11.1|set]]
 
|[[JDatabaseQuery::set/11.1|set]]
|Add a single condition string, or an array of strings to the SET clause of the query.
+
|
 
|-
 
|-
 +
|public
 +
|[[JDatabaseQuery::showTables/11.1|showTables]]
 +
|
 +
|-
 +
|public
 +
|[[JDatabaseQuery::unlock/11.1|unlock]]
 +
|Method to unlock the database table for writing.
 +
|-
 +
|public
 
|[[JDatabaseQuery::update/11.1|update]]
 
|[[JDatabaseQuery::update/11.1|update]]
|Add a table name to the UPDATE clause of the query.  
+
|
 +
|-
 +
|public
 +
|[[JDatabaseQuery::values/11.1|values]]
 +
|
 
|-
 
|-
 +
|public
 
|[[JDatabaseQuery::where/11.1|where]]
 
|[[JDatabaseQuery::where/11.1|where]]
|Add a single condition, or an array of conditions to the WHERE clause of the query.
+
|
 
|-
 
|-
 
|}
 
|}
 +
* '''Defined in''' libraries/joomla/database/databasequery.php
 +
* '''Extended by'''
 +
** [[JDatabaseQueryMySQL/11.1|JDatabaseQueryMySQL]]
 +
** [[JDatabaseQueryMySQLi/11.1|JDatabaseQueryMySQLi]]
 +
** [[JDatabaseQuerySQLAzure/11.1|JDatabaseQuerySQLAzure]]
 +
** [[JDatabaseQuerySQLSrv/11.1|JDatabaseQuerySQLSrv]]
 
===Importing===
 
===Importing===
 
<source lang="php">jimport( 'joomla.database.databasequery' );</source>
 
<source lang="php">jimport( 'joomla.database.databasequery' );</source>
 
===See also===
 
===See also===
* [[JDatabaseQuery|Other versions of this class]]
+
* {{JVer|11.1}} '''JDatabaseQuery source code''' on [[jplatform:database/databasequery.php|BitBucket]]
 +
* {{JVer|11.1}} Subpackage [[Subpackage Database/11.1|Database]]
 +
* [[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 84: 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 JClasses]][[Category:Platform 11.1]][[Category:JDatabaseQuery]]</noinclude>

Revision as of 12:34, 29 August 2012

Replacement filing cabinet.png
This Namespace has been archived - Please Do Not Edit or Create Pages in this namespace. Pages contain information for a Joomla! version which is no longer supported. It exists only as a historical reference, will not be improved and its content may be incomplete.

Joomla 11.1 JDatabaseQuery

Description

Description:JDatabaseQuery [Edit Descripton]

Methods

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

jimport( 'joomla.database.databasequery' );

See also

SeeAlso:JDatabaseQuery [Edit See Also]

User contributed notes

<CodeExamplesForm />