set up expiration

How to Set up Expiration on MySQL Row in PHP/MySQLi

Submitted by nurhodelta_17 on
This tutorial will show you how to set up expiration on mysql row in PHP/MySQLi. In this tutorial, I've set up to update the expired row but in case that you wanted to delete the row, I've added the delete code in the comment. So feel free to switch it. This tutorial also has two mysqli methods that I've included in the comments as well so you can switch between them.

Creating our Database

I've created a sample database that we are going to use in this tutorial. 1. Open phpMyAdmin. 2. Click databases, create a database and name it as "expiration". 3.