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 to add 301 redirects in PHP?

857


how can i develop forum code? any one pleale help me on this question

1887


What does the scope of variables mean?

892


Is echo a function in php?

942


What is different types of visibility?

875


What are the variables in php?

987


What is the difference between print() and echo() in PHP?

996


Explain the difference between $message and $$message?

921


How a constant is defined in a php script?

957


How would you open a directory for reading in php?

957


What is the Default syntax used in PHP?

1054


When a conditional statement is ended with an endif?

889


Explain the difference between array_merge() and array_combine()?

947


Php being an open source is there any support available to it?

1041


Write a program to display table of a number using php?

879