PHP Classes

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

Recommend this page to a friend!
     
  Info   View files View files (4)   DownloadInstall with Composer Download .zip   Reputation   Support forum (2)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2024-01-09 (4 days ago) RSS 2.0 feedStarStarStar 59%Total: 581 All time: 5,302 This week: 103Up
Version License PHP version Categories
mysql-undo 1.10GNU General Publi...5PHP 5, Databases
Collaborate with this project 

Author

Ovunc Tukenmez

MYSQLUndo - github.com

Description

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
  Performance   Level  
Name: Ovunc Tukenmez <contact>
Classes: 14 packages by
Country: Turkey Turkey

Level 1 Star

 Innovation award
Innovation award
Nominee: 6x

Details

MYSQLUndo
=========

This PHP class is used to make possible to undo unwanted data changes in the MYSQL database.
* Logging must be enabled for the table in order to track changes.
* It class creates triggers to store current state of the inserted/updated/deleted row in the time of change.
* Also a stored procedure for the table is created to make possible to get previous state of the rows before the specified time span defined with start_date and end_date parameters.

  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

Downloadmysql-undo-2024-01-09.zip
Downloadmysql-undo-2024-01-09.tar.gz
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:581
This week:0
All time:5,302
This week:103Up
User Ratings User Comments (2)
 All time
Utility:91%StarStarStarStarStar
Consistency:91%StarStarStarStarStar
Documentation:-
Examples:-
Tests:50%StarStarStar
Videos:-
Overall:59%StarStarStar
Rank:1388
 
Very nice code
10 years ago (Rakesh Kumar)		70%StarStarStarStar
very nice work.
10 years ago (Ashok kumar kashyap)		70%StarStarStarStar
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.