Connect two different database server using PHP

tokcy · #1 July 1st, 2009, 03:22 PM

Hi everyone,

I want to connect two different database server using php/mysql.
Suppose i have some dat on www.xyz.com and i want to select that data on www.abc.com
How do i integrate two different database server please some body tell me...

Thanks in advance

dlite922 · #2 July 1st, 2009, 11:32 PM

do you know how to connect to one database? if not look online for PHP tutorial and read the manual at php.org

I don't even know what database you're using, if MySQL then php has native functions for that.

If you know how to connect to one, then you can connect to multiple.

Dan

tokcy · #3 July 2nd, 2009, 05:33 AM

of course i know how to connect one database but i am facing the problem like if i connect two different databse on local server it works fike and when i upload that file to remote server its not working and i am using PHP 5.0/MYSQL .

Dormilich · #4 July 2nd, 2009, 06:42 AM

to work with a remote server you usually need permissions to access it (many ISP servers allow only localhost access). otherwise you need to make sure to always pass the correct resource link. (if you're using PDO you might get away with 2 DB objects, though)

tokcy · #5 July 2nd, 2009, 07:25 AM

i am connecting two database server with this code.

Expand|Select|Wrap|Line Numbers

 
For first server

<?php

$hostname = "hostname";

$username = "username"; 

$password = "password";  

$con = mysql_connect($hostname,$username,$password) or die("Database not connected");

mysql_select_db("database");  

?>
 
For second server

<?php

$hostname = "hostname1";

$username = "username1"; 

$password = "password1";  

$con = mysql_connect($hostname,$username,$password) or die("Database not connected");

mysql_select_db("database1");  

?>

Dormilich · #6 July 2nd, 2009, 08:18 AM

Quote:

Originally Posted by tokcy

i am connecting two database server with this code.

this code will probably get you in trouble if you want to use both connections in the same script.

- the second connection will overwrite the first one (you need to use different variable names)
- if you're using more than one connection, you must (in a logical sense) pass the connection resource to every mysql_* function.

my personal recommendation: use PDO. it boils down to using 2 different DB objects, which is IMO easier to track and maintain (beside the various other advantages that come with PDO (Exceptions, Prepared Statements, advanced data fetching, …)

tokcy · #7 July 2nd, 2009, 08:27 AM

Sorry for prev reply actually i had not notice that i am using same variable name in prev reply

my actual code is:

Expand|Select|Wrap|Line Numbers

 
<?php

$r_hostname = "hostname1";

$r_username = "username1";

$r_password = "pass1";

$link = mysql_connect($r_hostname,$r_username,$r_password);

$db = mysql_select_db("db_name1",$link);

?>

<?php

$hostname = "hostname2";

$username = "username2"; 

$password = "pass2";  

$con = mysql_connect($hostname,$username,$password);

$db1 = mysql_select_db("db_name2",$con);  

if ($con)

 {

    if ($db1) 

    {

        echo "connected and selected ok";

    }

    else

      {

        echo "connected and selected failed";

    }

} 

else

{

echo "failed to connect to server";

}

?>

Dormilich · #8 July 2nd, 2009, 08:32 AM

does it work now?

you might think over, how to verify the server connections, currently you completely neglect server1 errors.

line 13 would fail if the server connection (line 12) failed.

tokcy · #9 July 2nd, 2009, 09:05 AM

No its not working...

And server1 is that server where my registration page resides and i want to insert all data into database which is on server2 .
But i am not able to do this...

Thanks for your kind reply

Dormilich · #10 July 2nd, 2009, 09:07 AM

any error messages? can you confirm both connections? have you access permission on server2?

tokcy · #11 July 2nd, 2009, 09:20 AM

I am getting this error

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'mysql50-30.wcl' (11001).

and for permission i have to check but how will i check that server2 has given me permission to access database. If not then how will i enable the access...

Dormilich · #12 July 2nd, 2009, 09:24 AM

that's a strange host name, usually the host name is identical to the server name.

as for the permissions, ask the Administrator of server2.

tokcy · #13 July 2nd, 2009, 10:44 AM

If i am using only on single server this name as hostname ''mysql50-30.wcl'' then its working fine i can do all the think like select, delete and insert command. on this server but its not working when i am trying to connect on another server.

Dormilich · #14 July 2nd, 2009, 10:50 AM

what do you get for "mysql.max_links" in php.ini (see phpinfo() in the MySQL section)?

tokcy · #15 July 2nd, 2009, 10:56 AM

its showing unlimited

Dormilich · #16 July 2nd, 2009, 10:59 AM

hm, as expected…

could you PM (private messaging) me both host names, so that I can try if I get the same errors?

tokcy · #17 July 2nd, 2009, 11:04 AM

send me ur email id or how can i send PM via bytes

Dormilich · #18 July 2nd, 2009, 11:10 AM

go to "User Control Panel" (click on your username just below the Bytes logo). in the left side menu there is the "Private Messages" group, click on "Send New Message". use "Dormilich" (w/o the quotes) as recipient. type message. click on the "Submit Message" button when you’re done. ;)

alternatively, click on my username, this brings you to my public profile. go to the "Contact Info" tab, click on "Send a Private Message …". proceed as above.

tokcy · #19 July 2nd, 2009, 11:28 AM

i have sent you the message with all the details...

thanks

Dormilich · #20 July 2nd, 2009, 12:24 PM

1) can't connect to second server (hostname (chessimmigration.com) unknown) but it should work for you since it's your localhost

2) can find first server, but can't establish connection

Expand|Select|Wrap|Line Numbers

 $c1 = mysql_connect('chessglobalproperties.com', $user, $pass);
 
Warning: mysql_connect(): Lost connection to MySQL server at 'reading initial communication packet', system error: 61

after some research I found out that "system error: 61" means that you can only connect this particular DB with "localhost" as host name (i.e. not from outside). you need to alter the mysql conf file to get this working.

note: to pass the socket you need to use MySQLi

tokcy · #21 July 3rd, 2009, 05:26 AM

thank you very much for your co-operation...

i will do the same according to your reply...

Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

re: Connect two different database server using PHP

/bytes/development

/bytes/it

/bytes/about