How do I use PHP to connect to another database on another server?

When you make a connection to a database, you use the usual statement:

mysql_connect('localhost','USERNAME','PASSWORD');

Where localhost is the database on the same web server as the PHP script.

If you need to connect to a database that is on another server, you would replace localhost with the IP address of the server.

You can find the IP address of the database’s server by checking your eXtend Control Panel.

1. Log into your eXtend Control Panel
2. Click on ‘MySQL Databases’
3. Scroll down to the existing databases
4. Copy the IP address next to the database you require
5. Paste that IP address into your mysql_connect line

Article ID: 20
Created On: Mon, Mar 2, 2015 at 5:06 PM
Last Updated On: Thu, Apr 23, 2015 at 10:39 AM

Online URL: https://www.heartinternet.uk/support/article/how-do-i-use-php-to-connect-to-another-database-on-another-server.html