How can I retrieve values from one database server and store
them in other database server using PHP?
Answer Posted / 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″, $db1);
$res1 = mysql_query(”query”,$db1);
$db2 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db2″, $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″, $db1);
$res1 = mysql_query(”query”,$db1);
$db2 = mysql_connect(”host”,”user”,”pwd”, true)
mysql_select_db(”db2″, $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 |
Post New Answer View All Answers
What is get method in java?
When do sessions end?
How do we get the current session id?
Explain the visibility of the property or method?
Tell me what is the difference between characters 34 and x34?
Tell me how to create a text file in php?
Which programming language does php resemble to?
Why did you choose this particular career path?
What is move_uploaded_file in php?
How to return ascii value of character in php?
What is php date function?
What is the content of /etc directory?
How long is a php session valid?
What is php artisan tinker?
Does php need to be installed?