How can I retrieve values from one database server and
store them in other database server using PHP?
Answer Posted / mahesh
$db1 = mysql_connect(”host”,”user”,”pwd”)
mysql_select_db(”db1name;, $db1);
$res1 = mysql_query(”query”,$db1);
$db2 = mysql_connect(”host”,”user”,”pwd”, true)
mysql_select_db(”db2name;, $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 ? | 8 Yes | 2 No |
Post New Answer View All Answers
What is split function in php?
How can we change the maximum size of the files to be uploaded?
When use javascript vs php?
What is default session time in php?
What is the name of the scripting engine that powers PHP?
How can we change the value of a constant?
What is the difference between overloading and overriding in php?
How to join multiple strings into a single string?
What is the output of the ucwords function in this example?
What is the correct php command to use to catch any error messages within the code?
Is overloading possible in php?
What is the functionality of the functions strstr() and stristr()?
Explain briefly about a search-friendly site looks like?
Explain what is the difference between mysql_fetch_array() and mysql_fetch_assoc()?
How check variable is set or not in php?