Login   Register  
PHP Classes
elePHPant
Icontem

SQL Statement: Compose database queries without writing SQL

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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 This week: 1All time: 4,187 This week: 1,398Up
Version License PHP version Categories  
sqlstatement 0.8GNU Lesser General Publ...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: 1080143 in United States United States
Week rank: 444 Up47 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  
 0%Total:728All time:4,187
 This week:1This week:1,398Up
 User Ratings  
 
 All time
Utility:81%StarStarStarStarStar
Consistency:93%StarStarStarStarStar
Documentation:-
Examples:-
Tests:-
Videos:-
Overall:50%StarStarStar
Rank:1622