Automatically execute MySQL query or PHP script without cron

Question

So, I have a forum and I want to reward users who donated automatically with a special membergoup, I can do this by adding it into forum's MySQL database. What I need now is to remove such usergroup when a month has passed, automatically. What I would like to know is if it would be possible to make it purely on PHP for example, or another similar alternative.

Thanks in advance

run the script yourself (or get another site with cron to open the script page). Or when a user logs in, check their status and update accordingly — Waygood
– Waygood, Commented Sep 10, 2012 at 15:43
Is there any specific reason you can't use a cron job? That really would be the best solution... — Lix
– Lix, Commented Sep 10, 2012 at 15:44

Marc B · Accepted Answer · 2012-09-10 15:43:38Z

5

php has no job scheduling mechanism built into it, unless you run a script as a daemon. MySQL has its own scheduling mechanism: http://dev.mysql.com/doc/refman/5.1/en/events-overview.html

answered Sep 10, 2012 at 15:43

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

Comments

Sakis Vtdk · Accepted Answer · 2012-09-10 15:59:11Z

1

You could store the date that the donation was made, and then, you could check the difference between that date and the current date.

If the result is > month then the user should not be in that membergroup.

Also, to avoid calculating that difference every single time, you could have an extra field in your database for each user, which would indicate if that user should be considered a donator.

answered Sep 10, 2012 at 15:59

Sakis Vtdk

5931 gold badge6 silver badges15 bronze badges

Collectives™ on Stack Overflow

Automatically execute MySQL query or PHP script without cron

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related