I want to setup a webpage that shows some real-time
data when a user clicks a button. The webserver is running
on my ISP's site - not on my network. The webserver
has PHP and MySQL capabilities.
The data that the page should show is located in one
of the tables in my VFP app on my local machine. The
app is running 24/7.
How would I go about updating a webpage on demand?
I have envisioned a scenario where a PHP script on the
webserver creates a SQL query and writes it out to a text
file and ftps the file to my local machine. Of course, I'd
have to be running an ftp host too. The VFP app polls that
folder, finds the file, acts on the query, and returns a text
file (XML?) containing the data. It then ftps the file back
to the webserver. In the meantime, the webserver is polling
for a file itself, and when the results come back, it displays
the webpage.
BTW - I own the wwipstuff from West-Wind if this helps.
Is this a reasonable way to approach this problem?
Is there any other way that I can have PHP and VFP
communicate with each other? (I could do it via email,
but that would be too slow.)
I'm not worried about security/encryption/validation
at this point. I just want to know how to pass data
back and forth.
Thanks for any suggestions.
Ken Watkins
©2005 Ken Watkins |
