PHP Classes

SQL Statement: Compose database queries without writing SQL

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2006-12-05 (8 years ago) RSS 2.0 feedStarStarStar 50%Total: 728 All time: 4,203 This week: 1,398Up
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: 30
All time rank: 1082144 in United States United States
Week rank: 1647 Down182 in United States United States Down

  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. 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  
 0%Total:728All time:4,203
 This week:0This week:1,398Up
 User Ratings  
 All time