Login   Register  
PHP Classes
elePHPant
Icontem

PHP MYSQL Undo Query: Log changes to tables to revert the changes later

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 (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings  
2014-04-14 (8 months ago) RSS 2.0 feedStarStarStar 59%Total: 497 This week: 1All time: 5,326 This week: 1,384Up
Version License PHP version Categories  
mysql-undo 1.1GNU General Public Lice...5PHP 5, Databases
Description Author  

This class can log changes to MySQL tables to revert the changes later.

It creates a log table that will record the changes done to a given table using triggers also created by the class.

The class can undo the changes done to the tables by looking up the log table.

It can revert the all the changes that were done since logging was enabled or just up to a given period of time.

Innovation Award  
PHP Programming Innovation award nominee
December 2013
Number 2


Prize: One copy of the Zend Studio
Database transactions are useful to revert a set of changes done to the database records in case part of the operation fails due to an unexpected reason.

However, transactions are usually made of a set of changes done in a short period of time.

This class provides a solution to revert changes done to MySQL database table records eventually performed across multiple database transactions.

Manuel Lemos
Picture of Ovunc Tukenmez
Name: Ovunc Tukenmez <contact>
Classes: 9 packages by
Country: Turkey Turkey
Age: 28
All time rank: 87919 in Turkey Turkey
Week rank: 568 Up11 in Turkey Turkey Up
Innovation award
Innovation award
Nominee: 4x

  Files folder image Files  
File Role Description
Plain text file MYSQLUndo.php Class base class file.
Accessible without login Plain text file example.php Test examples
Accessible without login Plain text file LICENSE.md Data Auxiliary data
Accessible without login Plain text file README.md Data Auxiliary data

 Version Control Unique User Downloads Download Rankings  
 100%Total:497All time:5,326
 This week:1This week:1,384Up
User Ratings User Comments (2)  
 All time
Utility:91%StarStarStarStarStar
Consistency:91%StarStarStarStarStar
Documentation:-
Examples:-
Tests:50%StarStarStar
Videos:-
Overall:59%StarStarStar
Rank:910
 
Very nice code
1 year ago (Rakesh Kumar)
70%StarStarStarStar
very nice work.
1 year ago (Ashok kumar kashyap)
70%StarStarStarStar