how to do connectivity of 2 dbs in PHP script?

Answers were Sorted based on User's Feedback



how to do connectivity of 2 dbs in PHP script?..

Answer / lt

If you are trying to open multiple, separate MySQL
connections with the same MySQL user, password, and
hostname, you must set $new_link = TRUE to prevent
mysql_connect from using an existing connection.
The workaround is to require that the second MySQL
connection is new:

$db1 = mysql_connect($dbhost, $dbuser, $dbpass);
$rv = mysql_select_db($dbname1, $db1);
$db2 = mysql_connect($dbhost, $dbuser, $dbpass, TRUE);
$rv = mysql_select_db($dbname2, $db2);
Source: http://jp2.php.net/manual/en/function.mysql-connect.php
Message from: arithmetric at gmail dot com
26-Mar-2008 03:59

Is This Answer Correct ?    16 Yes 0 No

how to do connectivity of 2 dbs in PHP script?..

Answer / naveen das

Simple using two connection objects

Is This Answer Correct ?    3 Yes 0 No

how to do connectivity of 2 dbs in PHP script?..

Answer / manjunath

mysql_query("select db names");

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More PHP Interview Questions

What is the role of php.ini file?

0 Answers  


How many days will it take to learn php?

0 Answers  


What does echo mean in php?

0 Answers  


Can we extend two classes in php?

0 Answers  


Can we extend multiple classes in php?

0 Answers  






Where do I run php code?

0 Answers  


How do you register one session ?

4 Answers  


What does pear stand for?

0 Answers  


What is difference between strstr() and stristr() in PHP?

0 Answers  


What is php used for?

0 Answers  


How to list all values of submitted fields?

0 Answers  


Tell me what's the difference between include and require?

0 Answers  


Categories