I have a PHP script that polls a database, checks for new entries, and, if a new entry is found, sends out a push notification to iOS devices.
I currently have the php script set up so if you refresh the page constantly, it does what I want. I could also set up a php or javascript refresh and just have the page open, but that wouldn't be very effective if I'm working with a remote server and can't tell what programs are open or when it restarts.
I'm thinking that a windows service would be the best solution to my issue, but I'm not sure how I can compile the php script into a windows service.
Does anybody have any suggestions? Worst case, I guess I could just write everything in C# and make a windows service out of that, but I'm sure there's an easier way.