CODEWITHSUNDEEP
phpmysqldatecron
neeko
neeko

Reputation: 2000

php - how to store expiry date in a database and run a (delete) script at date

I have a simple website where users can post ads, i want to set an expiry date based in a mysql table when the user uploads an ad, say in one months time and then when that date is reached then my delete script will be automatically run to remove the ad

any help much appreciated!!

Upvotes: 0

Views: 3070

Answers (3)

Teena Thomas
Teena Thomas

Reputation: 5239

add query:

INSERT INTO ads (expires_on, ...)
VALUES (now() + INTERVAL 1 MONTH, ...)

delete query:

DELETE from ads 
WHERE expires_on <= now()

And run them in cron jobs, as others mentioned.

Upvotes: 0

Matt S
Matt S

Reputation: 15374

  1. Write a script which queries the database and deletes/flags any expired ads based on a timestamp set when the ad is created.
  2. Call this script from a cron job set to run nightly.

Better yet, if the data set is small, ignore the expired ads in your main code instead of deleting them at all.

Upvotes: 2

Marc B
Marc B

Reputation: 360632

add script:

INSERT INTO ads (expires_on, ...)
VALUES (now() + INTERVAL 1 MONTH, ...)

delete script:

SELECT ...
WHERE expires_on <= now()

Simply have your delete script run once a day (e.g. cron job)

Upvotes: 3

Related Questions