API17

JDatabaseQuery: Difference between revisions

From Joomla! Documentation

← Older edit
Doxiki2 (talk | contribs)
Bots
18,905 edits
Layout updates
m preparing for archive only
 
(6 intermediate revisions by 2 users not shown)
Line 1: Line 1:
__NOTOC__
__NOTOC__
<span class="editsection" style="font-size:76%;">
=={{JVer|11.1}} JDatabaseQuery==
<nowiki>[</nowiki>[[Description:JDatabaseQuery|Edit Descripton]]<nowiki>]</nowiki>
===Description===
</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]]
{{SeeAlso:JDatabaseQuery}}
* [[API17:JDatabaseQuery|Other versions of JDatabaseQuery]]
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[SeeAlso:JDatabaseQuery|Edit See Also]]<nowiki>]</nowiki>
 
</span>
===User contributed notes===
===Examples===
=== Code Examples ===
<CodeExamplesForm />
<dpl>
<dpl>
noresultsheader=\n
noresultsheader=\n
category=JDatabaseQuery
category=JDatabaseQuery
category=CodeExample
namespace=CodeExample
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>

Latest revision as of 02:42, 25 March 2017

Joomla 11.1 JDatabaseQuery

Description

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


User contributed notes

Code Examples


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