如何使用PHP / MySQL每周更新数据库？

Question

I have a MySQL database in which I have to update a certain field weekly.

Once the user lands on a particular page on my website on a Wednesday, it will need to check the current date.

If the day lands on a Wednesday then all records containing value a will be reset to value c, but all records containing value b will remain as they are.

This process can be run only once on the Wednesday. Afterwards the user will be able to freely input either value a or b until the next Wednesday.

How would this be accomplished in PHP/MySQL? I would appreciate any pointers in the correct direction.

Answer 1

If you have permission on the server (or can get it setup some other way), your best bet would be a cron job (assuming your server is on Linux).

http://en.wikipedia.org/wiki/Cron

http://community.contractwebdevelopment.com/cron-job-mysql