PHP Classes

sql_query_generator: Generates SQL SELECT statements from form data

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 58%Total: 1,762 All time: 2,230 This week: 455Up
Version License PHP version Categories
tfmsqlquery 0.5MIT/X Consortium ...4.0Databases
Description 

Author

This class can generate a large range of SQL SELECT queries from a submitted form.

It provides means to generate 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.

Picture of Toby Allen
Name: Toby Allen <contact>
Classes: 1 package by
Country: Ireland Ireland

 

  Files folder image Files (3)  
File Role Description
Plain text file class.tfm.sqlquery.inc Class Class File
Accessible without login HTML file index.html Doc. HTML Example page
Accessible without login Plain text file showresults.php Example Sample Script for results of index.html

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,762
This week:0
All time:2,230
This week:455Up
 User Ratings  
 
 All time
Utility:75%StarStarStarStar
Consistency:75%StarStarStarStar
Documentation:58%StarStarStar
Examples:75%StarStarStarStar
Tests:-
Videos:-
Overall:58%StarStarStar
Rank:1447