 |
|
Innovation award
Nominee: 1x
Winner: 1x |
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.
|
|
| 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: |
525 users |
| All time rank: |
4812 |
| Week users: |
2 users |
| Week rank: |
1400  |
| |
|
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 |
| There are not enough user ratings to display for this class. |
| |
Applications that use this class |
|
|
No application links were specified for this class.
If you know an application of this package, send a message to the
author to add a link here.
| |
 Files |
|
|
Stumble It!
Bookmark in del.icio.us
Support forum (2)
Blog
Latest changes
User ratings
Files
