发送数据到另一个数据库服务器

Question

I've a website connected with database. When I fill the form the php script send the data to the database. The website and the database are on same server. To store the data in database I use:

    $con=mysql_connect('localhost',$id,$password);
    mysql_select_db($dabase,$con);
    $query=mysql_query($queryToRun);

This is how I send data to the database. Now I want to store the same form on a database stored on another server. Is it possible, if yes then how? Any kind of help is appreciated very much.

Answer 1

The remote database needs to be configured to allow remote connections. See this question.

Once that is set up, you just need to set the server IP/hostname in the mysql_connect() call instead of localhost.

Side note: The mysql_* API is deprecated, it is recommended to upgrade to MySQLi or PDO.