Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : Foxpro to MySql

[Vinayak_Sharma]

Hey I am a newbie with php, 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).

Thanks

[anantatman]

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.

[Vinayak_Sharma]

I can't use XML, as I don't know it.

So is there an easy way out.

[Lats]

Shouldn't be too hard

A quick search on google brought up this.


Lats...

[anantatman]

google. the way you get **** done fast.