Login   Register  
PHP Classes
elePHPant
Icontem

Chain Query Builder: Compose MySQL queries chaining functions

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 (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2010-12-03 (3 years ago) RSS 2.0 feedNot enough user ratingsTotal: 1,026 This week: 1All time: 3,304 This week: 1,463Up
Version License PHP version Categories  
chain-query-builder 1.1MIT/X Consortium License5PHP 5, Databases
Description Author  

This class can be used to compose MySQL queries chaining functions that define query parameters.

It can create and compose the SQL statement of a query by performing chained calls to different functions of the class that take parameters to define different values of the queries.

The class provides functions for defining the type of query (SELECT, INSERT, UPDATE and DELETE), involved fields and field values, condition clauses, result grouping and ordering, and the result set row range.

1.1
added JOIN, LEFT JOIN, RIGHT JOIN, USING, ON
added IN to the where method as a valid operand

Picture of Arthur Borisow
Name: Arthur Borisow <contact>
Classes: 3 packages by
Country: Ukraine Ukraine
Age: ???
All time rank: 154727 in Ukraine Ukraine
Week rank: 1113 Up23 in Ukraine Ukraine Up
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files  
File Role Description
Plain text file chainquerybuilder.class.php Class The class
Accessible without login Plain text file test.php Example Example

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,026All time:3,304
 This week:1This week:1,463Up
 User Comments (1)