send data to antoher database server?

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.

You will need to replace the 'localhost' with the servers FQDN or IP Address — PhearOfRayne
– PhearOfRayne, Commented Dec 18, 2012 at 8:16

Hanky Panky · Accepted Answer · 2012-12-18 08:16:28Z

2

Instead of "localhost", enter in the ip address / host name of the server where database server is listening for requests. In order for this to work, that database server will have to allow requests from outside "localhost" aswell

answered Dec 18, 2012 at 8:16

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:12:32Z

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.

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Dec 18, 2012 at 8:17

MrCode

64.6k10 gold badges95 silver badges114 bronze badges

Comments

Priidu Neemre · Accepted Answer · 2012-12-18 08:25:57Z

1

You could just create two concurrent sets of connection variables and send the query to both of the database servers under question. For example, you could have:

  $dbConn1 = mysql_connect('address-of-the-first-database-server', 
  $userName1, $password1);
  mysql_select_db($dbName1, $dbConn1);

  $dbConn2 = mysql_connect('address-of-the-second-database-server', 
  $userName2, $password2);
  mysql_select_db($dbName2, $dbConn2);

  $execQuery = mysql_query($queryToRun, $dbConn1);
  $execQuery = mysql_query($queryToRun, $dbConn2);

PS: I would also recommend using more descriptive names for your variables, as this basically makes programming feel like writing structured English.

edited Dec 18, 2012 at 8:25

answered Dec 18, 2012 at 8:20

Priidu Neemre

3,0992 gold badges43 silver badges44 bronze badges

1 Comment

Priidu Neemre Over a year ago

Yes, it should make the query run on two distinct servers (or in two different databases of the same server, in case you choose to use the same server address but different database names). NOTE: You should take my syntax with a grain of salt as I do not write PHP too often. I hope I got it right though.

Collectives™ on Stack Overflow

send data to antoher database server?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related