Login   Register  
PHP Classes
elePHPant
Icontem

Class: phpSQL

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Wesley de Souza  >  phpSQL  >  Download .tar.gz .zip  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: phpSQL
Base name: phpsql
Description: Run SQL queries defined programmatically
Related classes: , ,
Version: -
PHP version: 4
License: GNU General Public License (GPL)
All time users: 496 users
All time rank: 4531
Week users: 0 users
Week rank: 2555
Picture of Wesley de Souza
Author: Wesley de Souza <e-mail contact>
Packages: 1 Browse this author's classes Browse this author's classes
Country: Brazil Brazil - PHP jobs in Brazil
Age: 25
All time rank: 2539193 in Brazil Brazil
Week rank: 2255 Up175 in Brazil Brazil Up


  Detailed description  
This package can compose SQL queries defined programatically to be executed with ADODb.

There is a query class that can compose the query adding the WHERE condition clause,

The conditions can be made of multiple clauses combined with logical operators AND, and OR.

This class supports column alias, adding tables to the queries, switch/case statements, math operators, aggregating expressions like SUM, AVG, MIN, MAX, column sorting.

The composed queries can be executed with or without restricting the range of rows to be returned.

There is also another class that provides functionality to combine data from multiple tables, like performing joins.

 

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

  Rate classes User ratings   Applications   Files Files  

  User ratings  
There are not enough user ratings to display for this class.

  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 phpSQL.php Class Main Class

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