Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How can I retrieve values from one database server and
store them in other database server using PHP?

Answer Posted / mahesh

$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db1name;, $db1);
$res1 = mysql_query(”query”,$db1);


$db2 = mysql_connect(”host”,”user”,”pwd”, true)
mysql_select_db(”db2name;, $db2);
$res2 = mysql_query(”query”,$db2);

So mysql_connect has another optional boolean parameter
which indicates whether a link will be created or not. as we
connect to the $db2 with this optional parameter set to
‘true’, so both link will remain live.

now the following query will execute successfully.
$res3 = mysql_query(”query”,$db1);

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you identify independent and dependent variables in research?

912


How to merge values of two arrays into a single array?

1007


what is benefit of magento?

2531


How to Retrieve a Cookie Value?

1193


What is the use of @ in php?

1033


Suppose your zend engine supports the mode Then how can you configure your php zend engine to support Mode ?

972


Tell me what kind of things have you done on the social side?

967


What is isset in php form?

1012


What are the rules for naming a php variable?

1043


How many types of php frameworks are there?

910


What is pdo classes?

1082


What is the main function of php?

1113


What is the purpose of the php empty function?

951


How cookies are transported from servers to browsers?

972


Does php need html?

971