API17

Difference between revisions of "JDatabaseQuery"

From Joomla! Documentation

(Bulk upload by Doxiki2)
 
(Layout updates)
Line 6: Line 6:
 
===Defined in===
 
===Defined in===
 
libraries/joomla/database/databasequery.php
 
libraries/joomla/database/databasequery.php
 +
* see source code in [[jplatform:database/databasequery.php|BitBucket]]
 
===Subpackage===
 
===Subpackage===
 
[[Subpackage Database/11.1|Database]]
 
[[Subpackage Database/11.1|Database]]
Line 71: Line 72:
 
<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]]
 
* [[JDatabaseQuery|Other versions of this class]]
 
* [[JDatabaseQuery|Other versions of this class]]
 
{{SeeAlso:JDatabaseQuery}}
 
{{SeeAlso:JDatabaseQuery}}

Revision as of 17:51, 23 April 2011

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.

[Edit Descripton] Template:Description:JDatabaseQuery

Defined in[edit]

libraries/joomla/database/databasequery.php

Subpackage[edit]

Database

Extends[edit]

Extended by[edit]

Methods[edit]

Method name Description
__toString Magic function to convert the query to a string.
clear Clear data from the query or a specific clause of the query.
delete Add a table name to the DELETE clause of the query.
from Add a table to the FROM clause of the query.
group Add a grouping column to the GROUP clause of the query.
having A conditions to the HAVING clause of the query.
innerJoin Add an INNER JOIN clause to the query.
insert Add a table name to the INSERT clause of the query.
join Add a JOIN clause to the query.
leftJoin Add a LEFT JOIN clause to the query.
order Add a ordering column to the ORDER clause of the query.
outerJoin Add an OUTER JOIN clause to the query.
rightJoin Add a RIGHT JOIN clause to the query.
select Add a single column, or array of columns to the SELECT clause of the query.
set Add a single condition string, or an array of strings to the SET clause of the query.
update Add a table name to the UPDATE clause of the query.
where Add a single condition, or an array of conditions to the WHERE clause of the query.

Importing[edit]

jimport( 'joomla.database.databasequery' );

See also[edit]

Template:SeeAlso:JDatabaseQuery [Edit See Also]

Examples[edit]

<CodeExamplesForm />