PHP Classes

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,542 This week: 794Up
Version License PHP version Categories
sqlstatement 0.8GNU Lesser Genera...5.0Databases


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: 38
All time rank: 1169168 in United States United States
Week rank: 483 Up46 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.
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,542
This week:794Up
 User Ratings  
 All time