data from local to web server
Hi All,
need some suggestions here, i'm building web page on my website to list calendar appointments which i can query from an sql database on my local server. The first idea came to mind mind was load data to the remote mySql database via a desktop application that runs on a scheduler, query the sql data und updates the remote MySql data tables, but then i realised our host block external connections for security reasons, and for the same reason i wouldn't establish a connection to my local server from an external page.
so i thought ok, i wite data into xml and ftp it to a folder on the host server, which in turn i loaded to a php page. this works but to tideous and any updates i make requires changes in all three steps..
any better suggestions
much appreciated :)