how to update database on a weekly basis, using 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.

zsalzbank · Accepted Answer · 2010-12-16 02:25:55Z

3

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

answered Dec 16, 2010 at 2:25

zsalzbank

9,8611 gold badge28 silver badges39 bronze badges

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

1 Comment

zsalzbank Over a year ago

do you have control over the server on the network? is it Linux? cron is built into Linux. doesn't really have much to do with the web application or database. it can be used for anything that you want to do at a specific interval of time.

deceze · Accepted Answer · 2010-12-16 02:26:24Z

2

The usual way to do this is to run a weekly cron job at some ungodly hour where it won't disturb anybody. Don't rely on users visiting websites to do regular tasks.

answered Dec 16, 2010 at 2:26

deceze♦

525k89 gold badges806 silver badges954 bronze badges

Collectives™ on Stack Overflow

how to update database on a weekly basis, using PHP/MySQL?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related