[PHP-DB] Updating 2 Databases from a single form
Hello, I was wondering if there is anyway to first connect to two databases simeltaneously. (both reside on the same server) . After connecting, I have a single form that I want to use to update data to 2 different tables, both tables are in different databases. So far I have recieved at least 10 ways of doing this and none of them seem to work. I know there is a way, but I cant seem to grasp it from the information that I have acquired so far. Important Facts Both databases have the same login credentials, Both databases are on the same server, Any ideas? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Updating 2 Databases from a single form
If both the databases are on the same database server, you can use the SQL command USE dbname to switch databases or use the full path like dbone.tablename.columnname and dbtwo.tablename.columnname. Or you can use mysql_select_db() PHP function to switch databases on the same server. Assuming that you're talking about two different database servers, then you can just do two separate connections: $conn1 = mysql_connect($server1, $user, $pass); $conn2 = mysql_connect($server2, $user, $pass); $result1 = mysql_query($somequery, $conn1); $result2 = mysql_query($somequery, $conn2); Something like that. -TG - Original Message - From: Derek [EMAIL PROTECTED] To: php-db@lists.php.net Date: Thu, 27 Sep 2007 16:42:10 -0500 Subject: [PHP-DB] Updating 2 Databases from a single form Hello, I was wondering if there is anyway to first connect to two databases simeltaneously. (both reside on the same server) . After connecting, I have a single form that I want to use to update data to 2 different tables, both tables are in different databases. So far I have recieved at least 10 ways of doing this and none of them seem to work. I know there is a way, but I cant seem to grasp it from the information that I have acquired so far. Important Facts Both databases have the same login credentials, Both databases are on the same server, Any ideas? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Updating 2 Databases from a single form
Realistically, there are three options: 1. run the code twice to connect and pass the data to each server 2. set up a primary server and use a stored procedure to load the other server (providing db supports it) 3. set up replication and make one a master and the other a slave and the the replication do its work, the flip to this is to make each server a master and slave them off the other Bastien To: php-db@lists.php.net From: [EMAIL PROTECTED] Date: Thu, 27 Sep 2007 16:42:10 -0500 Subject: [PHP-DB] Updating 2 Databases from a single form Hello, I was wondering if there is anyway to first connect to two databases simeltaneously. (both reside on the same server) . After connecting, I have a single form that I want to use to update data to 2 different tables, both tables are in different databases. So far I have recieved at least 10 ways of doing this and none of them seem to work. I know there is a way, but I cant seem to grasp it from the information that I have acquired so far. Important Facts Both databases have the same login credentials, Both databases are on the same server, Any ideas? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php _ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=createwx_url=/friends.aspxmkt=en-us
Re: [PHP-DB] Updating 2 Databases from a single form
On 9/27/07, Derek [EMAIL PROTECTED] wrote: Hello, I was wondering if there is anyway to first connect to two databases simeltaneously. (both reside on the same server) . After connecting, I have a single form that I want to use to update data to 2 different tables, both tables are in different databases. So far I have recieved at least 10 ways of doing this and none of them seem to work. I know there is a way, but I cant seem to grasp it from the information that I have acquired so far. Important Facts Both databases have the same login credentials, Both databases are on the same server, Any ideas? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php mysql_connect($server, $user, $pass); mysql_select_db($db1); mysql_query($query1); mysql_select_db($db2); mysql_query($query2); -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php