[SOLVED] Input to two databases

[aztec]

Hello

 

Is it possible using PHP to input the same data from a form into two databases when  the submit button is clicked.

 

I have a need to load information onto my web MYSQL database and at the same time load the information from the same form into my "localhost" MYSQL database.

 

Both are identical databases i.e. both are v 5. same database name same table names. At the moment I dump from my local database and transfer the dump to the web database.

 

I have used the same script to load into the local database and by changing the password etc. into the web datebase.

 

I am using a combination of HTML; PHP, MYSQL and CSS on the input form.

 

Kind Regards

[sKunKbad]

Once you have inserted the data to database #1, just close the connection, and open up a second connection to database #2.

[aztec]

Thanks sKunKbad

 

I never thought of that but it sounds too easy, I'll try it to see if it works

 

Regards

[rhodesa]

you can have several DB connections open at the same time, you just have to keep track of your connection resources...

 

<?php
  //Connection 1
  $cnx1 = mysql_connect('hostname','user','pass');
  mysql_select_db('testdb',$cnx1);

  //Connection 2
  $cnx2 = mysql_connect('localhost','user','pass');
  mysql_select_db('testdb',$cnx2);

  $sql = "UPDATE table SET field = 'update me' WHERE id = 123";
  mysql_query($sql,$cnx1);
  mysql_query($sql,$cnx2);
?>

[aztec]

Hello rhodesa

 

Many thanks, looks like a neat bit of code, I looks like it will do what need.

 

When I get back to my computer I'll give it a try.

 

Regards