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 |
Tell me which function gives us the number of affected entries by a query?
Actually am working in existing project which is developed in .net, am converting the .net into php code. am facing problem after uploading the .php in server. amgetting the error message like "The page cannot be found" but its working perfectly in local host
Write a program in php to check whether a number is prime or not?
Is age interval or ordinal data?
What does trim () do in javascript?
Whether it is possible to share a single instance of a memcache between multiple php projects?
1.Where are the sessions storing ? 2.What are the contents of a session file ? 3.If the server is loaded with too many session files there is a possibility of server crash. How can we solve this issue? 4. How does php server identify that the particular session belongs to particular user ? For ex: If two users A and B logged from different machine, separate session files (say 1 and 2) will be created in the server. But how the php knows that 1 belongs to A and 2 belongs to B ?
Difference among echo, print and printf.
Name some of the popular frameworks in php.
What are the string function in php?
When sessions ends?
How to remove duplicate values from php array?