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?

Answers were Sorted based on User's Feedback



How can I retrieve values from one database server and store them in other database server using PH..

Answer / vijaya

we can always fetch from one database and rewrite to
another. Here is a nice solution of it.

$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db1&#8243;, $db1);
$res1 = mysql_query(”query”,$db1);
$db2 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db2&#8243;, $db2);
$res2 = mysql_query(”query”,$db2);At this point you can only
fetch records from you previous ResultSet,

i.e $res1 - But you cannot execute new query in $db1, even
if you supply the link as because the link was overwritten
by the new db.so at this point the following script will fail

$res3 = mysql_query(”query”,$db1); //this will failSo how to
solve that?

Take a look below.

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

$db2 = mysql_connect(”host”,”user”,”pwd”, true)
mysql_select_db(”db2&#8243;, $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 ?    14 Yes 4 No

How can I retrieve values from one database server and store them in other database server using PH..

Answer / ravinder

by using import and export

Is This Answer Correct ?    1 Yes 15 No

Post New Answer

More PHP Interview Questions

equivalent code for the following c program in php void main() { int i=5;printf("%d",i); }

2 Answers  


What is the difference between Split and Explode in PHP?

0 Answers   B-Ways TecnoSoft,


What is static in php?

0 Answers  


Write a program to get second highest number in an array using php?

0 Answers  


I have written a source code in php but I do not know how to compile that and conduct it with a website please explain me the how to compile that ?

1 Answers  


Inside a php function, what param needs to be set in order to access a global variable?

0 Answers  


Is php a strongly typed language?

0 Answers  


How do I run a php script in windows?

0 Answers  


How is it possible to set an infinite execution time for php script?

0 Answers  


1.<?php echo'bsfjbsnmfbs'; ?> 2.<? ech'hjndfjkshf'; ?> 3 <? echo'naskfdjnask'; three programs are exected but which is beter why

3 Answers   HCL,


What is the use of mysql_real_escape_string() function?

0 Answers  


Explain what does the expression exception::__tostring means?

0 Answers  


Categories