SelectQuery class - Documentation for Pelzini

Info Page:

Page options:

class SelectQuery

This class simplifies the creation of select queries

Name	Visibility	Description
__construct	public
addFields	public	Generic method for adding fields to the query
addInnerJoin	public	Adds an INNER JOIN
addLeftJoin	public	Adds a LEFT JOIN
addProjectWhere	public	Adds the required WHERE clauses for multiple-project support
addWhere	public	Adds a WHERE clause. Where clauses are ANDed together
buildQuery	public	This creates the SQL query
setFrom	public	Sets the FROM clause for the query
setGroupBy	public	Sets a GROUP BY clause.
setOrderBy	public	Sets an ORDER BY clause.

void $SelectQuery->__construct ( );

This function does not have a description

void $SelectQuery->addFields ( string $fields );

Generic method for adding fields to the query

void $SelectQuery->addInnerJoin ( mixed $join );

Adds an INNER JOIN

void $SelectQuery->addLeftJoin ( mixed $join );

Adds a LEFT JOIN

void $SelectQuery->addProjectWhere ( );

Adds the required WHERE clauses for multiple-project support

void $SelectQuery->addWhere ( mixed $where );

Adds a WHERE clause. Where clauses are ANDed together

unknown $SelectQuery->buildQuery ( );

This creates the SQL query

void $SelectQuery->setFrom ( mixed $from );

Sets the FROM clause for the query

void $SelectQuery->setGroupBy ( mixed $group_by );

Sets a GROUP BY clause.

void $SelectQuery->setOrderBy ( mixed $order_by );

Sets an ORDER BY clause.