API17:JDatabaseQuery

Defined in

libraries/joomla/database/databasequery.php

• see source code in BitBucket

Subpackage

Database

Methods

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

jimport( 'joomla.database.databasequery' );

See also

• JDatabaseQuery source code in BitBucket
• Other versions of this class

Examples

<CodeExamplesForm />