PHP Classes

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

Recommend this page to a friend!
     
  Info   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 1,183 All time: 3,205 This week: 206Up
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: 5 packages by
Country: Macedonia Macedonia
Age: 40
All time rank: 13991 in Macedonia Macedonia
Week rank: 164 Up1 in Macedonia Macedonia Equal
Innovation award
Innovation award
Nominee: 1x

  Files folder image Files (2)  
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

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
 Version Control Unique User Downloads Download Rankings  
 0%
Total:1,183
This week:0
All time:3,205
This week:206Up