Fake Delete

This PHPMaker 2024 project will show you how to implement Fake Delete which will update the record as Deleted along with Date and Time when the record is deleted. In other words, the record will not be deleted physically from database, but only updated in database.

The deleted records will not be displayed again in the current normal table. You will learn how to filter records for tables that contain the deleted records, simply by using Recordset_Selecting server event. In addition, we use Database View for displaying the deleted records. No need to create separated table for this!

By using this PHPMaker 2024 project, then you will be able to know how to write PHP code in Row_Deleting server event in order to ignore the Deleting process, and update the related fields. After the updating process is successfully done, then system will redirect End-Users back to the List Page.

This ability is one of the flexibilities you can find and enjoy as Web Developer while working with PHPMaker 2024. You may implement Fake Delete simply by writing a few lines of code from Row_Deleting server event only. You cannot find this ability in another similar tools.

If your database/table supports Transaction, then you may also write only two lines of PHP code to commit the changes to database. For example, if you are using MySQL database, and your table uses InnoDB, then you should commit the changes in database, since this table supports transaction.

However, by using this project, I will keep show you how to write PHP code both for tables that support Transaction (Inno DB) and not support Transaction (My ISAM). You will see the same code that will handle for both tables. So, there is nothing to worry about it.

This project also will show you how to restore the deleted records, either for a single record or for multiple-records. We use Page_Load, ListOptions_Load, ListOptions_Rendered, and Row_CustomAction server events for this.

Last but not least, you will also learn how to implement both Multiple-Delete along with Delete a Record. For Multiple-Delete, we may simply write a few lines in Page_Load server event. For Delete a Record, then we may simply use the built-in feature from PHPMaker.