Login   Register  
PHP Classes
elePHPant
Icontem

Keep edit and delete database archive: Access tables keeping deleted records archived

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us

  Author Author  
Picture of majid ramzani
Name: majid ramzani <e-mail contact>
Packages: 4 Browse all classes by majid ramzani Browse all classes by
Country: Iran Iran - PHP jobs in Iran
Age: 22
All time rank: 118710 in Iran Iran
Week rank: 710 Up11 in Iran Iran Down
Innovation award
Innovation award
Nominee: 1x

Winner: 1x


  Detailed description   Download Download .zip .tar.gz  
This class can access MySQL tables keeping deleted records archived.

It can execute common queries to manipulate records of a MySQL table but record deletion is emulated by setting a field with the data of the soft-deletion of the record.

The class can execute SQL INSERT, UPDATE, DELETE and SELECT queries ignoring rows there are soft-deleted.

  Classes of majid ramzani  >  Keep edit and delete database archive  >  Download Download .zip .tar.gz  >  Support forum Support forum (2)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Keep edit and delete database archive
Base name: archive-edit-delete
Description: Access tables keeping deleted records archived
Version: -
PHP version: 5.0
License: GNU General Public License (GPL)
All time users: 543 users
All time rank: 4939
Week users: 0 users
Week rank: 1665 Equal
 
  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 winner
January 2013
Winner
Permanently deleting database records may be a dangerous operation to execute from an application.

If a Web site that performs record deletion has its user accounts compromised, the attacker may cause irreversible damage by executing operations that delete important information records.

A more secure alternative is to implement what is called soft-deletion of records.

In practice this means that records are not really deleted. Instead they have a field that is used to mark deleted records.

This way, if there is a security breach and records are marked as deleted, the records that were affected may be undeleted.

This class implements access to MySQL database table records with soft-deletion support.

The delete operation just sets the field to mark the records as deleted. The table access operations ignore records marked as deleted.

Manuel Lemos

  User ratings  
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
Accessible without login Plain text file index.php Example usage
Plain text file KEDA.class.php Class class file
Accessible without login Plain text file news.sql Data table structure
Accessible without login Plain text file readme.txt Doc. read me

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