How to Autodelete Rows in PhpmyAdmin

#1

I am looking for a way to auto delete rows in the database after 24 hours. I am not sure how to use cron job in the phpmyadmin. Is there a way to auto delete rows in the database from Phpmyadmin?

Thanks

#2

You actually shouldn’t be deleting rows from a database, for a production system. And you are combining things that are not related at all.

  1. Write a script that selects what you want to delete.
  2. In your web host interface go to the cron scheduler.
  3. Direct it to run that file (with the full path to that file)
#3

I understand. How can I create a cron job in php to auto delete? I was thinking of using a countdown timer but not sure if it would work.

#4

You don’t create a cron job in php, that is part of the server. Follow the steps I outlined first.

Sponsor our Newsletter | Privacy Policy | Terms of Service