Login   Register  
PHP Classes
elePHPant
Icontem

Class: SQL Statement

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ryan Lovelett  >  SQL Statement  >  Download .tar.gz .zip  >  Support forum Support forum  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: SQL Statement
Support forum Support forum
Base name: sqlstatement
Description: Compose database queries without writing SQL
Version: 0.8
PHP version: 5.0
License: GNU Lesser General Public License (LGPL)
All time users: 691 users
All time rank: 3791
Week users: 0 users
Week rank: 2664
Picture of Ryan Lovelett
Author: Ryan Lovelett <e-mail contact>
Packages: 2 Browse this author's classes Browse this author's classes
Country: United States United States - PHP jobs in United States
Age: 27
All time rank: 1059140 in United States United States
Week rank: 836 Up90 in United States United States Up


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

 

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

  Rate classes User ratings   Dependencies   Applications   Files Files  

  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (81.2%)
Good (93.8%)
-
-
-
-
Not sure (50.0%)
1479
Month:
Not yet rated by the users

  Packages needed by this class  
Class Dependency Why it is needed
Error Class
Required
 When errors are generated by creation of new SQL strings they can now automatically notify an administrator.

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

Download all files: sqlstatement.tar.gz sqlstatement.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.