[douffle]

Can anyone tell me if you can code a script running on one server to access a MySQL database on remote server?

I want to have a script compare the domain name that the script is running on to the domain name that is stored in a MySQL database on a remote server.

I am pretty sure that it can be done and if it can be, could someone show me a sample of the code that would be needed to achieve this?

I know how to get the domain name of the server that the script is running on using the $domain=$_SERVER['HTTP_HOST']; function but I need to know how to access the MySQL database on the remote server to compare it to.

Thanks

[UnrealEd]

It's pretty easy: have a look at the mysql_connect function. The 1st parameter you have to enter is the name of the server the MySQL server is running on. So if you want to connect to a remote server, simply enter the domain where the MySQL is running on:

PHP Code:

mysql_connect ('mysql.on_remote_host.com', 'username', 'password') or die (mysql_error ()); 

There might be a chance that this won't work as there's an option in the MySQL server configuration that, if set to true, only allow connections via localhost to it's server. In that case, you'll have to write a php script that runs on the remmote server, and that will grab the data from the MySQL server. Instead of connecting to the remote MySQL server, you'll have to fetch the output of the php page

[douffle]

Thank you for your help.
I will give that code a try and see what happens.

I checked with my Host provider to see if they allowed remote connections and they said yes but it has to be set up in the cpanel so I will give it a shot.

Thanks again. Very much appreciated.

[infinitylimit]

If you have cpanel you will need to go into the Mysql section and allow the remote hosts. This will mean you will have to enter the ip and access before you can connect, it's easy and there is a form.