API17

JDatabaseQuery

From Joomla! Documentation

Revision as of 17:51, 23 April 2011 by Doxiki2 (talk | contribs) (Layout updates)

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 />