Login   Register  
PHP Classes
elePHPant
Icontem

Class: sql_query_generator

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Toby Allen  >  sql_query_generator  >  Download .tar.gz .zip  >  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
Related classes: , , , ,
Version: -
PHP version: -
License: Freeware
All time users: 1704 users
All time rank: 1913
Week users: 0 users
Week rank: 2517
Picture of Toby Allen
Author: Toby Allen <e-mail contact>
Packages: 1 Browse this author's classes Browse this author's classes
Country: Ireland Ireland - PHP jobs in Ireland
Age: ???
All time rank: 13251 in Ireland Ireland
Week rank: 2255 Down2 in Ireland Ireland Down


  Detailed description  
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.

 

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

  Rate classes User ratings   Applications   Files Files  

  User ratings  
Ratings
Utility
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%)
924
Month:
Not yet rated by the users

  Applications that use this class  
No application links were specified for this class.
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
HTML file index.html Doc. HTML Example page
Plain text file showresults.php Example Sample Script for results of index.html

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.