There is a query class that can compose the query adding the WHERE condition clause, the conditions can be made of multiple clauses combined with logical operators AND, and OR.
phpSQL supports column alias, adding tables to the queries, switch/case statements, math operators, aggregating expressions like SUM, AVG, MIN, MAX, column sorting.
The composed queries can be executed with or without restricting the range of rows to be returned.
Another class for combining data from multiple tables is also included.
PHP 4.0 or higher
More popular Database Tool
- 31.8 KB
- 11/25/2008 14:26:18