Automatic delete entries by day, hours, minute etc...
This only work on Linux server, or you can use same idea on Windows Server.
- Connecting via SSH to your server
- Create sql file on your server nano drop_formidable_entries.sql and save it on any location that you want. exp: /home/formidable
- Insert example the following queries inside the sql file:
DELETE FROM wp_frm_items WHERE form_id=x and created_at < (NOW() - INTERVAL 1 MINUTE);
wordpress: it's database name.
wp_frm_items: it's table name
form_id=x: input form id that you wanted delete entries from it.
1 MINUTE: in this case will delete all entries from form id x older than 1 minute. You can change it into HOUR, DAY, WEEK or etc. For more value click here
- Save it
- In command line type crontab -e to add cron job into system, with following command.
*/30 * * * * /usr/bin/mysql < /home/formidable/drop_formidable_entries.sql >/dev/null 2>&1
Here */30 mean every 30 minutes will delete entries. You can change it as you want. For crontab generator click here
NB: If you have cPanel or Plesk you can simple create file and cron job inside cPanel or Plesk control panel. It's easy as command line.