Results 1 to 2 of 2
Thread: transfer my foxpro data
03-24-2003, 12:37 AM #1PenguinGuest
my problem is to transfer my foxpro data residing on my comp to MySql database residing on one of the host servers, and this is to be done regularly, as data is feeded every day on the foxpro package.
So can any one explain me how to do it, with some php residing on the web server, as my host won't allow remote connection to the MySql server (like using Myfrontend).
04-01-2003, 12:56 AM #2HamalGuest
create an XML webservice with php which takes a SQL statement, or CSV text on your host. .. You can also do this with a regular PHP script, look through phpmyadmin code to see how.
then on your end, you can have a windows service that exports data and uses HTTP to connect to the XML ws, or the php script.