PHP Classes

MySQL query, paging and caching helper: Query and cache MySQL results to be paginated

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in Bookmark in
  Info   View files View files (2)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2011-06-13 (4 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 1,078 All time: 3,288 This week: 1,121Up
Version License PHP version Categories  
mysql-paging-cache 0.1Free for non-comm...5PHP 5, Databases, Cache
Description Author  

This class can query and cache MySQL results to be paginated.

It can execute arbitrary SQL queries or assemble SELECT, INSERT, UPDATE and DELETE queries from lists of parameters that define tables, fields, field values and condition clauses.

The SELECT query results may be cached in files with the stored values encoded in JSON format.

The class can also generate links to browse pages of query result listings split over multiple pages of a limited number of results per page.

Picture of Mihajlo Siljanoski
  Performance   Level  
Name: Mihajlo Siljanoski <contact>
Classes: 2 packages by
Country: Macedonia Macedonia
Age: 31
All time rank: 19911 in Macedonia Macedonia
Week rank: 922 Up1 in Macedonia Macedonia Equal

  Files folder image Files  
File Role Description
Plain text file db.class.php Class The db class
Accessible without login Plain text file example.php Example Example of usage

 Version Control Unique User Downloads Download Rankings  
 0%Total:1,078All time:3,288
 This week:0This week:1,121Up