PHP - How do i delete data from database automatically after 24 hour of insertion

Question

I want to delete data from database after every 24hours insertion.

For example: A user is added today and he is not active, after 24hours the user will be automatically deleted.

I intend doing this without cron because cron is not in my local/offline server.

Please i really need your help.

the only way you can do this with php is in the database row have a last logged on time stamp. if the user comes back after 24 hours delete the record. PHP is only run when the webpage is loaded and will not run behind the scenes — NoLiver92
– NoLiver92, Commented Feb 11, 2017 at 21:09
MySQL has scheduled events (see dev.mysql.com/doc/refman/5.7/en/create-event.html), you might be able to use these - log a date in the database and every day schedule something like DELETE FROM yourtable WHERE date=... — toastrackengima
– toastrackengima, Commented Feb 11, 2017 at 21:21

ScaisEdge · Accepted Answer · 2017-02-11 21:45:29Z

2

You could simply use

DELETE FROM your_table 
WHERE your_date_col < DATE_SUB(NOW(), INTERVAL 1 DAY))

and use the mysql scheduled events

could be somethings like this

CREATE EVENT my_dayly_event
    ON SCHEDULE
      EVERY 1 DAY
    COMMENT 'delete old values.'
    DO
    DELETE FROM your_table 
    WHERE your_date_col < DATE_SUB(NOW(), INTERVAL 1 DAY))

anyway take a look a this doc. https://dev.mysql.com/doc/refman/5.7/en/create-event.html ... could be useful

edited Feb 11, 2017 at 21:45

answered Feb 11, 2017 at 21:22

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

JBoy Over a year ago

i don't know how to use the scheduler event please can you write it for me?

JBoy Over a year ago

ok bro that means with this i will have to wait for 1 day before i see the result. right?

ScaisEdge Over a year ago

This is a sample ... you can study the doc and try what is better for you .. you can change the frequence ( 1 HOUR or 1 MINUTE) for debugging or test ..

Collectives™ on Stack Overflow

PHP - How do i delete data from database automatically after 24 hour of insertion

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related