Login   Register  
PHP Classes
elePHPant
Icontem

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
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: 701 users
All time rank: 3834
Week users: 0 users
Week rank: 2329
 

  Author  
Picture of Ryan Lovelett
Name: Ryan Lovelett <e-mail contact>
Packages: 2 Browse all classes by Ryan Lovelett Browse all classes by
Country: United States United States - PHP jobs in United States
Age: 28
All time rank: 1050140 in United States United States
Week rank: 691 Up64 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   Rate classes User ratings   Dependencies   Applications   Files Files  

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


  User ratings  
Ratings
Utility
Consistency
Documentation
Examples
Tests
Videos
Overall
Rank
All time:
Good (81.2%)
Good (93.8%)
-
-
-
-
Not sure (50.0%)
1492
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.