You scenario.. how should I say this.. sounds quite klunky.
You want to update a page on demand. like if a quantity is sold, you want to
display the quantity left in stock. that second. So you web users are
given real data when they visit your site.
Could you, and I am just thinking here, change your application for that
one table to make that one table a remote cursor, where you users are no
longer reading from a dbf. but now reading from an odbc cursor.
that way is the cursor is updated, the server (web server with mysql) is
updated. Then your php script running on that web server would be reading
"live data"
MySql and PHP .. work together very easy. search google and I am sure you
can get write a php script to read a mysql table in about 10 minutes.
Depending on what you want to do.. it might be quite simple to have odbc
connection to your mysql database, for that one table and the rest of your
application stays on your local network.
Bob Lee
----- Original Message -----
From: "Ken Watkins" <kwat /at/ floodcity .DO.T net>
To: <profoxtech@leafe.com>
Sent: Wednesday, November 30, 2005 7:03 PM
Subject: 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
>
>
[excessive quoting removed by server]
©2005 Bob Lee |
