PHP Classes
elePHPant
Icontem

PHP MySQL Caching Wrapper: Execute MySQL queries and cache results in files

Recommend this page to a friend!
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2010-12-31 (5 years ago) RSS 2.0 feedNot yet rated by the usersTotal: 515 This week: 1All time: 5,455 This week: 1,047Up
Version License PHP version Categories
mysql-cache-wrapper 0.2BSD License4.2Databases, Cache
Description Author

This class can be used to execute MySQL queries and cache results in files.
It can connect to a MySQL server and execute given SQL queries.
The class can also retrieve the query results and store them in cache files.
The Class also returns cached queries on Database connection errors,
it can also handle events like sending mail on database errors.

Picture of Bilge Hauser
Name: Bilge Hauser <contact>
Classes: 1 package by
Country: Germany Germany

Details
This is my first contribution, i took several classes from here and would like to give some back. Maybe someone can use as i did.
I needed for some customer projects a mysql wrapper who caches mysql database queries. Another approach was that if database connection fails , the cached result will be returned.

The class had to be runable under php4/5.
So this is a quick result. use it as you like.

if you use this with php < 5.2 you need json.class.php
http://pear.php.net/pepr/pepr-proposal-show.php?id=198


History:
     08.12.2010 - Version 0.1 finished
     12.12.2010 - Implemented Class Registry
     31.12.2010 - Implemented Event Handling -> v 0.2


Todo:

	Blacklist queries who cannot be cached


  Files folder image Files  
File Role Description
Accessible without login Plain text file example.php Example Example usage
Accessible without login Plain text file LICENSE.txt Lic. BSD License
Plain text file phpMysqlCachingWrapper.class.php Class Wrapper and cache class
Accessible without login Plain text file README.txt Doc. Readme

 Version Control Unique User Downloads Download Rankings  
 0%
Total:515
This week:1
All time:5,455
This week:1,047Up