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
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″, $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 |
What is php built on?
How can you get the size of an image in PHP?
What is php dependency injection?
What is the difference between mysql_fetch_array() and mysql_fetch_assoc()?
What is ci framework in php?
How do I stop php artisan serve in windows?
Tell me what are the encryption techniques in php?
How to remove duplicate values from array using php?
Explain setcookie() function in php?
explain the changes in php version
write a program to print [123] [456] [789] note : braces also need to be printed
How many Types of COmments are there in PHP and what are they?