PHP Classes

Chain Query Builder: Compose MySQL queries chaining functions

Recommend this page to a friend!
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,131 This week: 1All time: 3,312 This week: 429Up
Version License PHP version Categories
chain-query-builder 1.1MIT/X Consortium ...5PHP 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: 161828 in Ukraine Ukraine
Week rank: 370 Up6 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,131
This week:1
All time:3,312
This week:429Up
User Comments (1)
 
For more information send a message to info at phpclasses dot org.