How can I retrieve values from one database server and store them in other database server using PHP?

Question

I Know that we can always fetch from one database server and rewrite it to another. But what is the simplest way to do this?

Comments

Simply retrieve data from one server and store it in session variables,  then connect to other server and insert the data into the database.

Answer 1

We have to connect to the database server from php using the mysql_connect and store the connection identifier in a variable and then fetch the data from the server and then close the server connections using mysql_close() and then connect to another server and insert the value there.

1. Connected to the first server fetch the data and stored in the $res variable

   $db=mysql_pconnect("host","username","pssword");
   mysql_select_db("dtabase name",$db);
   $query="select * from the table";
   $res=mysql_fetch_object(mysql_query($query));
   mysql_close($db)

2. Connected to the second server

   $db=mysql_pconnect("secondhost","username","pssword");
   mysql_select_db("dtabase name",$db);
   $query="insert into tablename values($res)";
   mysql_close($db);