Run PHP Script at Certain Time on Windows Server Via Database

[mfgoalie]

Is it possible to have a script run at a specific time by lists in a database?

 

For example, have a database input page where a user selects a time and date and puts in their email address. That is then sent to a database. Then, at that certain time, a script is run which calls that email address associated with it and sends the email to it?

 

I am on a windows iis7 server with mysql 5.

 

Any help would be greatly appreciated!

 

Thanks,

 

Mike

 

 

[ozestretch]

You could set a cron to run at certain intervals that executes the script to get the data from database, see if email is there to send, then send an email

[nankoweap]

you could use the windows scheduler to run a php script at any interval. the script would scan whatever table(s) and send email when required.

[redarrow]

Most holsters use cron, it a program to do some think at set times.

 

most host are under unix/linux but there is a windows version free here

 

http://cronw.sourceforge.net/

 

 

 

 

[mfgoalie]

Wow guys, thanks for the help so quick! Now I just have to figure out how to actually go about using cron! I am hoping it isn't too hard but, I can look around for some tutorials for how to set up a mysql table correctly for it to get the correct time on windows! If you know of any tutorials like that, please let me know! If not, thanks for all your help.

[redarrow]

nice one

http://clickmojo.com/code/cron-tutorial.html

 

bit advance

http://www.unixgeeks.org/security/newbie/unix/cron-1.html

 

fun full one

http://www.thefactory.ro/support/documentation/the-factory---a-simple-cron-tutorial..html

 

cron via video, look for the link

http://www.siteground.com/tutorials/cpanel/cron_jobs.htm

 

very use full

http://www.webmasterworld.com/forum23/80.htm

 

nice example powewrfull

http://www.linuxhelp.net/guides/cron/