Automatic Event Scheduler
Posted: Mon May 15, 2006 12:27 pm
I'm designing a site that allows subscribers to use a service/tool. Each user has their own line in a database that keeps track of their user data. Each time they use the program, a counter is actuated to show that they used the program again, and it's written to the table. At the end of the month, the user is to be charged for all of their uses for that month, then the table field for the counter is reset to 0 for the next month.
I need to make a code that automatically charges all of the users in the database at a certain time of a certain date every month. For example, the users will know that at 11:59PM on the 25th of each month, their account will be charged. Now, I don't want to be awake at 11:59 on the 25th of every month to press a button to charge everyone. I need to make it automatic.
However, I'm not sure how to set up an automatic event like that. Is it even possible without activating the page first? I can see a number of cumbersome ways to code such a tool, but they would use a lot of wasted energy, and probably wouldn't work on their own without being prompted. Anyone know what commands I should look at for something like this?
I need to make a code that automatically charges all of the users in the database at a certain time of a certain date every month. For example, the users will know that at 11:59PM on the 25th of each month, their account will be charged. Now, I don't want to be awake at 11:59 on the 25th of every month to press a button to charge everyone. I need to make it automatic.
However, I'm not sure how to set up an automatic event like that. Is it even possible without activating the page first? I can see a number of cumbersome ways to code such a tool, but they would use a lot of wasted energy, and probably wouldn't work on their own without being prompted. Anyone know what commands I should look at for something like this?