Difference between revisions of "JDatabaseQuery"
From Joomla! Documentation
m (Security Vulnerability - Fixed) |
|||
Line 108: | Line 108: | ||
$query->from('#__pt_building AS b'); | $query->from('#__pt_building AS b'); | ||
$query->leftJoin('#__pt_unit AS u ON b.building_id = u.building_id'); | $query->leftJoin('#__pt_unit AS u ON b.building_id = u.building_id'); | ||
− | $query->where('b.property_id = '.$property_id); | + | $query->where('b.property_id = '. (int) $property_id); |
$db->setQuery($query); | $db->setQuery($query); | ||
return $db->loadResult(); | return $db->loadResult(); | ||
} | } | ||
</source> | </source> |
Revision as of 01:23, 15 January 2011
The "API16" 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
Methods[edit]
Method name | Description |
---|---|
clear | Clear data from the query or a specific clause of the query. |
select | |
delete | |
insert | |
update | |
from | |
join | |
innerJoin | |
outerJoin | |
leftJoin | |
rightJoin | |
set | |
where | |
group | |
having | |
order | |
__toString | string The completed query |
Importing[edit]
jimport( 'joomla.database.databasequery' );
[Edit See Also] Template:SeeAlso:JDatabaseQuery
Examples[edit]
<CodeExamplesForm />
Simple Example
The following is a very simple use of the JDatabaseQuery class:
function getListQuery()
{
$query = new JDatabaseQuery();
$query->select('*');
$query->from('#__categories');
return $query;
}
Complex Example
Consider a case in which we have three tables called "property", "building" and "unit". The primary keys for these tables are "property_id", "building_id" and "unit_id", respectively. We want to build a method which returns the number of units associated with a property_id which is passed to our method. The unit table has no direct relationship to the property table. It does have a relationship to the building table, which in turn has a relationship to the property table. The following method will build the query and execute it, returning the value for which we're looking.
function countUnits($property_id)
{
$db =& JFactory::getDBO();
$query = new JDatabaseQuery();
$query->select('count(*)');
$query->from('#__pt_building AS b');
$query->leftJoin('#__pt_unit AS u ON b.building_id = u.building_id');
$query->where('b.property_id = '. (int) $property_id);
$db->setQuery($query);
return $db->loadResult();
}