I've been trying to connect to a mysql db through a php script. All the code is perfect and everything is well. I upload all the content and scripts to my site and it seems that my hosting provider have blocked all access to connecting to remote db's.
After contacting them, they seem to say that they cannot alter the block, under any circumstances but they do offer me some alternatives to get me through what i'm trying to do.
Now I've done some research on the two alternatives suggested but still don't understand how they work and how i would go about using them for what i'm trying to do (simply connect to a mysql db).
Changing hosting providers is out of my option so i cant just switch. Need to find a way round this.
they are trying to say you need to use http to make query on remote mysql. You can make a call in php to
http://remotesite.com/query_user_list.php
and query_user_list.php can create an xml file you can use that xml on your current hosting account.