Ken,
Take a look at HTTPGet and HTTPPost in wwIPstuff. It allows you to pull
and push stuff to a website.
Then just write a page on the web-page that does the necessary
processing.
Dan Neuman
-----Original Message-----
From: profoxtech-bounces /at/ leafe .D.OT com [mailto:profoxtech-bounces@leafe.com]
On Behalf Of Ken Watkins
Sent: Wednesday, November 30, 2005 4:04 PM
To: profoxtech /at/ leafe .D.OT com
Subject: PossibleSpam:Communications between a web server and my app
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 Dan Neuman |
