Login   Register  
PHP Classes

sql_query_generator: Generates SQL SELECT statements from form data

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Info   View files View files (3)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2003-05-22 (11 years ago) RSS 2.0 feedStarStarStar 58%Total: 1,746 This week: 1All time: 2,080 This week: 1,410Up
Version License PHP version Categories  
tfmsqlquery 0.5MIT/X Consortium License4.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
Age: ???
All time rank: 15061 in Ireland Ireland
Week rank: 1096 Up1 in Ireland Ireland Equal

  Files folder image Files  
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

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,746All time:2,080
 This week:1This week:1,410Up
 User Ratings  
 All time