Joinutility seperatorLogin utility separator Infobright.com
   
 
How do I connect to two MySQL databases at two different servers from a single php page?
 
jongrang168
Posted: 30 January 2010 01:43 PM   [ Ignore ]  
Newbie
Rank
Total Posts:  1
Joined  2010-01-30

I need to extract data from 2 MySQL databases located at two different servers. How is it possible from one single PHP page?

Profile
 
Mahib
Posted: 30 January 2010 08:41 PM   [ Ignore ]   [ # 1 ]  
Member
RankRankRank
Total Posts:  220
Joined  2008-08-18

General idea would be use two separate connections for two servers.  Execute query on each connection.

[ Edited: 31 January 2010 12:59 AM by Mahib]
Signature 

Mahib

Profile
 
Marcin Perkowski
Posted: 02 February 2010 06:50 AM   [ Ignore ]   [ # 2 ]  
Jr. Member
RankRank
Total Posts:  66
Joined  2008-08-18

Hi,
Try this way:

<?php
//Server A

$linkA = mysql_connect('hostA:port', 'user', 'password');
if (!$linkA) {
    die('Can not connect ' . mysql_error());
}

else
{
echo "Connected to server A";
}
    
 
//Server B

$linkB = mysql_connect('hostB:port', 'user', 'password');
if (!$linkB) {
    die('Can not connect ' . mysql_error());
}

else
{
echo "Connected to server B";
}   

?> 

Thanks,
Marcin Perkowski.

Profile
 
   
 
 
‹‹ Datatype DATE      DB2 to Infobright real time replication ››