Pelzini

This is the code documentation for the Pelzini project

Page options:

Inherited members

class SelectQuery

This class simplifies the creation of select queries

Authors

Variables

NameVisibilityDescription
$fields 
$from 
$group 
$joins 
$order 
$where 

Functions

NameVisibilityDescription
__constructpublic 
addFieldspublicGeneric method for adding fields to the query
addInnerJoinpublicAdds an INNER JOIN
addLeftJoinpublicAdds a LEFT JOIN
addProjectWherepublicAdds the required WHERE clauses for multiple-project support
addWherepublicAdds a WHERE clause. Where clauses are ANDed together
buildQuerypublicThis creates the SQL query
setFrompublicSets the FROM clause for the query
setGroupBypublicSets a GROUP BY clause.
setOrderBypublicSets an ORDER BY clause.

public __construct

void $SelectQuery->__construct ( );

This function does not have a description

public addFields

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

Generic method for adding fields to the query

public addInnerJoin

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

Adds an INNER JOIN

public addLeftJoin

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

Adds a LEFT JOIN

public addProjectWhere

void $SelectQuery->addProjectWhere ( );

Adds the required WHERE clauses for multiple-project support

public addWhere

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

Adds a WHERE clause. Where clauses are ANDed together

public buildQuery

unknown $SelectQuery->buildQuery ( );

This creates the SQL query

public setFrom

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

Sets the FROM clause for the query

public setGroupBy

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

Sets a GROUP BY clause.

public setOrderBy

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

Sets an ORDER BY clause.