Databases: sql_query_generator
Toby Allen (contact me)
This class will generate a large range of SQL SELECT queries from a submitted form.
It provides facilites for simple queries on one field on a table, joins, selection of fields to be returned, aliasing of fields (eg. SUM(Price) AS Total), ORDER BY, even multiple queries from one form.
Comes with a basic demo file, which I hope to update in time. GROUP BY and HAVING are also provided, but not entirely reliable.
Demo file provides overview of creating forms necessary to generate results.
| Utility
| Consistency
| Docs
| Examples
| Tests
| Videos
| Overall
| Rank
|
| Sufficient (75.0%)
| Sufficient (75.0%)
| Not sure (58.3%)
| Sufficient (75.0%)
| -
| -
| Not sure (58.3%)
| 760 |
Click here for detailed information about this class on phpclasses.org
Php Handleiding