Delete a post after a period of time

Question

I have created a function that gets the time an article was published. The same function checks whether the article is 1 week old and deactivates it.

I don't know what to do here if I have to make the function responsive when I call. I thought of using JavaScript and setting a timeout for the function. that would be too much of looping.

This is the "if" that I used to check the date. Someone with a better idea, please help.

if((time() - $publish_time) > (7*24*60*60)){
  //  if the current timestamp - the time the article was published > 1 week.
  //Execute the query to deactivate the article
}

That snippet is inside a function that I have to call.

why would you use client-side stuff to delete posts. make it time out in your database instead... — Amelia, Jan 19 '13 at 06:14
Its called an EVENT and you can create one with [this tutorial](http://www.sitepoint.com/how-to-create-mysql-events/) — Ricardo Ortega Magaña, Jan 19 '13 at 06:53
i checked and the tutorial is helping. but am still trying to get it. — Busker McGreen Brian, Jan 19 '13 at 10:29

score 0 · Answer 1 · edited May 23 '17 at 10:24

0

Rather than having this inside your site, you should expire your articles with a cronjob, as per this question when using MySQL (*nix-like)
On Windows, you can use mmc.exe and add a Task to execute the script through Task Scheduler)

edited May 23 '17 at 10:24

Community

1
1

answered Jan 19 '13 at 06:27

Amelia

2,967
2
24
39

score 0 · Accepted Answer · answered Jan 20 '13 at 05:53

0

Imagine that [table] has [column] with the date of the post got inserted:

SET GLOBAL event_scheduler = ON;

CREATE
    EVENT 'archive_posts'
    ON SCHEDULE EVERY 1 WEEK
    DO 
        DELETE FROM [table] WHERE [column] < DATE_SUB(NOW(), INTERVAL 1 WEEK);

answered Jan 20 '13 at 05:53

Ricardo Ortega Magaña

2,403
16
23

Delete a post after a period of time

2 Answers2