Techniques for closing up record ID gaps in a relational database table

Certain database operations such as the creation of new records, often result in skipped primary key numbers. This often happens in some database engine types and result in tables with non-consecutive record ID numbers or record ID gaps. more

   0 likes

---

Handling Pagination (PHP/MySQL)

In this tutorial, I am documenting how I handle pagination of viewed records. more

   0 likes

---

Dealing with Delete Implementation in PHP/MySQL

When deleting records, I prefer a lossless approach, a way of removing a record from the view of the end-user without completely removing the record from the database. This tutorial is my best implementation of an earlier article I wrote on more

   0 likes

---