JDatabaseQuery
From Joomla! Documentation
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
- see source code in BitBucket
Subpackage[edit]
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]
- JDatabaseQuery source code in BitBucket
- Other versions of this class
Template:SeeAlso:JDatabaseQuery [Edit See Also]
Examples[edit]
<CodeExamplesForm />