communicating between 2 servers

phence

How can i do the following in PHP?

I need to pull data from a mysql database that is on a different server than where i need to edit the data. I then need to edit the data, and send the edited data back to server where I collected it from and save it there.

How can I send and recieve data between 2 different servers?

I really appreciate any help you can offer.

zalath

It doesn't matter where the server resides. You can usually specify the server you're connecting to in the xxxx_connect function.

DigitalExpl0it

why not make a page that opens one mysql databse gets the data puts it into forms.. then when you edit the forms and click submit it goes to another page there it will open the other database then insert the edited data.

phence

Originally posted by DigitalExpl0it
why not make a page that opens one mysql databse gets the data puts it into forms.. then when you edit the forms and click submit it goes to another page there it will open the other database then insert the edited data.

I am editing html data. I am using a WYSIWIG editor to edit html. The server where i need to make changes does not support the WYSIWIG editor, nor is it my machine. So to avoid grief with the owner of the machine to upgrade, i thought this would be a simpliar solution.

Thank-you

phence

Originally posted by zalath
It doesn't matter where the server resides. You can usually specify the server you're connecting to in the xxxx_connect function.

Can you elaborate a little more?

zalath

Well suppose the database server was MySQL and the machine running it is mysql.somedomain.com. You could connect to it like so:

$link_id = mysql_connect('mysql.somedomain.com','username','password');

that way you can use the remote database just as you would if the database was local.