Autodelete

[sindiswa_99]

Hi All

Im currently working on PHP project. How do I go about doing the Autodelete.Can somebody send me the tutorial where I coul learn on how perform an autodelete on my website.

Ok! here is the scenario, I have to post a notice to my noticeboard, this post should be there for 3 months after that it should be deleted/archived.

Pls help me

[auricle]

Since this question is about:
1. Saving posts with a timestamp
2. Checking the timestamp against the current time (to work out age)
3. Issuing commands to the database or filesystem to delete posts
...it's most appropriate for the Basic PHP forum.

Edit: Oh, it's been moved. Thanks, moderators.

[Dan Grossman]

auricle's got the basics for ya. In your database table containing the posts, you should store the date and time of the post (a datetime field or timestamp). Then a single database query can tell you what posts are 3 months old, so that you can delete or archive them.

[siteguru]

It's basically what's sometimes called Garbage Collection. I use that same process on a website I created to make sure inactive users are logged off. It's a very fast script that runs on every PHP page that uses a database connection (which is most of them).

There's no point in trying to give you code - the process is already outlined above.

[sindiswa_99]

thank you very much for your reply.

dont u have an example where I could be able to reference to?

thank you

[Dan Grossman]

SELECT * FROM posts WHERE TO_DAYS(CURDATE()) - TO_DAYS(post_date) > 90 

What else do you want an example of?

[siteguru]

 DELETE FROM posts WHERE TO_DAYS(CURDATE()) - TO_DAYS(post_date) > 90 

[sindiswa_99]

ok! thank you very much for your response.

[sindiswa_99]

thank for your eample

[sindiswa_99]

thank you for your example