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 api laravel?
What types of MYSQL function available for affecting columns
how to set session expire(session timeout) using php code
What is use of mysqli_query in php?
What are headers in php?
How do functions work?
Do you know how to delete a file from the system?
What is data type in php?
does PHP support foreign key and Rollback?yes or not.if not then why. how will you done these concept in php?
1 Answers Avanigoradia, Primus Global,
How to receive a cookie from the browser?
Explain the installation of PHP on UNIX systems?
What is difference between mysql_fetch_array and mysql_fetch_assoc?