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

Which methods should be used for sending an email using the variables $to, $subject, and $body?

0 Answers  


Can anybody plz tell me if there any recruitment on php plz mail to vasudev.adepu@gmail.com.i had completed M.SC(MATHS) in 2007 . trying to get a job on php. i have good knowledge on PHP/MYSQL

1 Answers  


What is The difference between ' and " where they can ben in between or outmost and how

2 Answers   Avis Software,


What is session php?

0 Answers  


What is indexing in mysql and how do we create indexing in mysql

4 Answers  






How do you set the browser timeout?

3 Answers  


how to retrieve from database..... this format (PRMRMDU402). firstname= prabhu, lastname=kumar, city=madurai, pincode=624402.... i want first name first two letters and last name last two letters ... city first two letters ... pin code last three letters....

2 Answers  


What is difference between session and cookie in PHP?

0 Answers  


What is explode() in php?

0 Answers  


How many escape sequences are recognized in single-quoted strings?

0 Answers  


What is serialization / object serialization ?

2 Answers  


Why do we use namespace in php?

0 Answers  


Categories