Login   Register  
PHP Classes
elePHPant
Icontem

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

  Author Author  
Picture of Toby Allen
Name: Toby Allen <e-mail contact>
Packages: 1 Browse all classes by Toby Allen Browse all classes by
Country: Ireland Ireland - PHP jobs in Ireland
Age: ???
All time rank: 14761 in Ireland Ireland
Week rank: 2007 Down1 in Ireland Ireland Equal


  Detailed description   Download Download .zip .tar.gz  
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.

  Classes of Toby Allen  >  sql_query_generator  >  Download Download .zip .tar.gz  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: sql_query_generator
Base name: tfmsqlquery
Description: Generates SQL SELECT statements from form data
Version: 0.5
PHP version: 4.0
License: MIT/X Consortium License
All time users: 1743 users
All time rank: 2061
Week users: 0 users
Week rank: 1335 Equal
 
  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes


  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Sufficient (75.0%) Sufficient (75.0%) Not sure (58.3%) Sufficient (75.0%) - - Not sure (58.3%) 994
Month: Not yet rated by the users

  Applications that use this class  
Link Description
github Project github.com/tobya/tfmsqlgenerator
Add link image If you know an application of this package, send a message to the author to add a link here.
  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

Download Download all files: tfmsqlquery.tar.gz tfmsqlquery.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.