API17

JDatabaseQuery: Difference between revisions

From Joomla! Documentation

← Older edit
Doxiki2 (talk | contribs)
Bots
18,905 edits
Updated to r1448:247ba8d88526
m preparing for archive only
 
(5 intermediate revisions by the same user not shown)
Line 2: Line 2:
=={{JVer|11.1}} JDatabaseQuery==
=={{JVer|11.1}} JDatabaseQuery==
===Description===
===Description===
{{Description:JDatabaseQuery}}
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[Description:JDatabaseQuery|Edit Descripton]]<nowiki>]</nowiki>
</span>
===Methods===
===Methods===
{| class="wikitable sortable"
{| class="wikitable sortable"
Line 14: Line 12:
|-
|-
|public  
|public  
|[[JDatabaseQuery::__toString/11.1|__toString]]
|[[API17:JDatabaseQuery::__toString|__toString]]
|Magic function to convert the query to a string.  
|Magic function to convert the query to a string.  
|-
|-
|public  
|public  
|[[JDatabaseQuery::auto_increment/11.1|auto_increment]]
|[[API17:JDatabaseQuery::auto_increment|auto_increment]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::castToChar/11.1|castToChar]]
|[[API17:JDatabaseQuery::castToChar|castToChar]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::charLength/11.1|charLength]]
|[[API17:JDatabaseQuery::charLength|charLength]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::clear/11.1|clear]]
|[[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.  
|-
|-
|public  
|public  
|[[JDatabaseQuery::concat/11.1|concat]]
|[[API17:JDatabaseQuery::concat|concat]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::delete/11.1|delete]]
|[[API17:JDatabaseQuery::delete|delete]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::dropIfExists/11.1|dropIfExists]]
|[[API17:JDatabaseQuery::dropIfExists|dropIfExists]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::fields/11.1|fields]]
|[[API17:JDatabaseQuery::fields|fields]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::from/11.1|from]]
|[[API17:JDatabaseQuery::from|from]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::group/11.1|group]]
|[[API17:JDatabaseQuery::group|group]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::having/11.1|having]]
|[[API17:JDatabaseQuery::having|having]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::innerJoin/11.1|innerJoin]]
|[[API17:JDatabaseQuery::innerJoin|innerJoin]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::insert/11.1|insert]]
|[[API17:JDatabaseQuery::insert|insert]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::insertInto/11.1|insertInto]]
|[[API17:JDatabaseQuery::insertInto|insertInto]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::join/11.1|join]]
|[[API17:JDatabaseQuery::join|join]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::leftJoin/11.1|leftJoin]]
|[[API17:JDatabaseQuery::leftJoin|leftJoin]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::length/11.1|length]]
|[[API17:JDatabaseQuery::length|length]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::lock/11.1|lock]]
|[[API17:JDatabaseQuery::lock|lock]]
|Method to lock the database table for writing.  
|Method to lock the database table for writing.  
|-
|-
|public  
|public  
|[[JDatabaseQuery::now/11.1|now]]
|[[API17:JDatabaseQuery::now|now]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::order/11.1|order]]
|[[API17:JDatabaseQuery::order|order]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::outerJoin/11.1|outerJoin]]
|[[API17:JDatabaseQuery::outerJoin|outerJoin]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::renameTable/11.1|renameTable]]
|[[API17:JDatabaseQuery::renameTable|renameTable]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::rightJoin/11.1|rightJoin]]
|[[API17:JDatabaseQuery::rightJoin|rightJoin]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::select/11.1|select]]
|[[API17:JDatabaseQuery::select|select]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::set/11.1|set]]
|[[API17:JDatabaseQuery::set|set]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::showTables/11.1|showTables]]
|[[API17:JDatabaseQuery::showTables|showTables]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::unlock/11.1|unlock]]
|[[API17:JDatabaseQuery::unlock|unlock]]
|Method to unlock the database table for writing.  
|Method to unlock the database table for writing.  
|-
|-
|public  
|public  
|[[JDatabaseQuery::update/11.1|update]]
|[[API17:JDatabaseQuery::update|update]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::values/11.1|values]]
|[[API17:JDatabaseQuery::values|values]]
|
|
|-
|-
|public  
|public  
|[[JDatabaseQuery::where/11.1|where]]
|[[API17:JDatabaseQuery::where|where]]
|
|
|-
|-
Line 140: Line 138:
* '''Defined in''' libraries/joomla/database/databasequery.php
* '''Defined in''' libraries/joomla/database/databasequery.php
* '''Extended by'''
* '''Extended by'''
** [[JDatabaseQueryMySQL/11.1|JDatabaseQueryMySQL]]
** [[API17:JDatabaseQueryMySQL|JDatabaseQueryMySQL]]
** [[JDatabaseQueryMySQLi/11.1|JDatabaseQueryMySQLi]]
** [[API17:JDatabaseQueryMySQLi|JDatabaseQueryMySQLi]]
** [[JDatabaseQuerySQLAzure/11.1|JDatabaseQuerySQLAzure]]
** [[API17:JDatabaseQuerySQLAzure|JDatabaseQuerySQLAzure]]
** [[JDatabaseQuerySQLSrv/11.1|JDatabaseQuerySQLSrv]]
** [[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===
* {{JVer|11.1}} '''JDatabaseQuery source code''' on [[jplatform:database/databasequery.php|BitBucket]]
* {{JVer|11.1}} '''JDatabaseQuery source code''' on [[jplatform:database/databasequery.php|BitBucket]]
* {{JVer|11.1}} Subpackage [[Subpackage Database/11.1|Database]]
* {{JVer|11.1}} Subpackage [[API17:Subpackage Database|Database]]
* [[JDatabaseQuery|Other versions of JDatabaseQuery]]
* [[API17:JDatabaseQuery|Other versions of JDatabaseQuery]]
{{SeeAlso:JDatabaseQuery}}
 
<span class="editsection" style="font-size:76%;">
 
<nowiki>[</nowiki>[[SeeAlso:JDatabaseQuery|Edit See Also]]<nowiki>]</nowiki>
</span>
===User contributed notes===
===User contributed notes===
<CodeExamplesForm />
=== Code Examples ===
<dpl>
<dpl>
noresultsheader=\n
noresultsheader=\n
category=JDatabaseQuery
category=JDatabaseQuery
category=CodeExample
namespace=CodeExample
category=ClassExample
category=ClassExample
include=*
include=*
Line 165: Line 161:
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"