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

  Author Author  
Picture of Ovunc Tukenmez
Name: Ovunc Tukenmez <e-mail contact>
Packages: 9 Browse all classes by Ovunc Tukenmez Browse all classes by
Country: Turkey Turkey - PHP jobs in Turkey
Age: 28
All time rank: 89018 in Turkey Turkey
Week rank: 16 Up1 in Turkey Turkey Up
Innovation award
Innovation award
Nominee: 4x


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
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.

  Classes of Ovunc Tukenmez  >  PHP MYSQL Undo Query  >  Download Download .zip .tar.gz  >  Support forum Support forum (2)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: PHP MYSQL Undo Query
Base name: mysql-undo
Description: Log changes to tables to revert the changes later
Version: 1.1
PHP version: 5
License: GNU General Public License (GPL)
All time users: 469 users
All time rank: 5356
Week users: 57 users
Week rank: 15 Up
 
  Groups   Rate classes User ratings   Applications   Files Files  

  Groups  
Group folder image PHP 5 Classes using PHP 5 specific features View top rated classes
Group folder image Databases Database management, accessing and searching View top rated classes


  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

  User ratings  
RatingsUtility Consistency Documentation Examples Tests Videos Overall Rank
All time: Good (91.7%) Good (91.7%) - - Not sure (50.0%) - Not sure (60.0%) 892
Month: There are not enough user ratings to display for this class.

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  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

Install with Composer Install with Composer - Download Download all files: mysql-undo.tar.gz mysql-undo.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.