Level 3
Yeah, I think a cron job is the way to go with PHP... You could maybe make the check happen every hour but it would still not be right away.
Apr 5, 2017
4
Level 1
Automatically delete blog post when it pass its expiry date
In my Laravel app I upload blog posts. All posts have a unix expiry date eg 1492425121
What I want to do is to automatically delete all posts that pass its expiry date.
Right now I am running a cron job each night that checks for old posts then deletes them, but is there any other way I can delete them right away?
Level 3
If the issue of importance is just that the blog post shouldn't display when it has expired - then you can put a global query scope in your post model which filters all results which haven't expired.
https://laravel.com/docs/5.4/eloquent#global-scopes
Then the cron job in the background wouldn't be a problem.
Level 67
You could also check to see if any posts have expired whenever a call is made to posts, and delete any posts that have expired before showing anything. It would also eliminate the cron job. It could be as simple as delete from posts where expire_date >= current_timestamp
1 like
Level 1
@CRONIX - I believe this is the best solution for this question, am going to use this option. How did i not think about this!? Thanks a lot! Be blessed!
Please or to participate in this conversation.