Login   Register  
PHP Classes
elePHPant
Icontem

phpSQL: Run SQL queries defined programmatically

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 (1)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2007-03-28 (7 years ago) RSS 2.0 feedNot enough user ratingsTotal: 510 All time: 5,247 This week: 1,788Up
Version License PHP version Categories  
phpsql 1.0GNU General Public Lice...4Databases
Description Author  

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.

Picture of Wesley de Souza
Name: Wesley de Souza <contact>
Classes: 1 package by
Country: Brazil Brazil
Age: 28
All time rank: 2923223 in Brazil Brazil
Week rank: 1721 Up144 in Brazil Brazil Up

  Files folder image Files  
File Role Description
Plain text file phpSQL.php Class Main Class

 Version Control Unique User Downloads Download Rankings  
 0%Total:510All time:5,247
 This week:0This week:1,788Up