SQL Statement: Compose database queries without writing SQL

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
StarStarStar 50%Total: 733 All time: 4,513 This week: 794Up
Version License PHP version Categories
sqlstatement 0.8GNU Lesser Genera...5.0Databases
Description Author

This package can be used to compose SQL database query statements without writing SQL manually.

It can compose the SELECT, INSERT, UPDATE and DELETE queries from a list of table field names and the respective values.

The main class can also associate conditions, order and grouping clauses to the queries. A separate class can be used to associate join condition clauses.

The main class returns SQL strings that can be executed separately.

Picture of Ryan Lovelett
Name: Ryan Lovelett <contact>
Classes: 2 packages by
Country: United States United States
Age: 37
All time rank: 1162160 in United States United States
Week rank: 512 Up64 in United States United States Up


  Files folder image Files  
File Role Description
Plain text file class.SQLJoins.php Class This class is utilized by the SQLStatement class to create the different type of SQL join statements that exist.
Plain text file class.SQLStatement.php Class This is the base class file. Declare new objects using this file.

Downloadsqlstatement-2006-12-05.zip 4KB
Downloadsqlstatement-2006-12-05.tar.gz 3KB
Install with ComposerInstall with Composer
Needed packages  
Class DownloadWhy it is needed Dependency
Error Class Download .zip .tar.gz When errors are generated by creation of new SQL strings they can now automatically notify an administrator. Required
 Version Control Unique User Downloads Download Rankings  
This week:0
All time:4,513
This week:794Up
 User Ratings  
 All time

For more information send a message to info at phpclasses dot org.