how can we retrive value from one database server and store
them another database server using php?
Answer Posted / sunilchai
just connect to the datbase server from php using the
mysql_connect and store the connection identifier in a
variable and then fetch the data from the server and the
close the server connections using mysql_close() and then
connect to another server and insert the value there
/// sample scriopt
$db=mysql_pconnect("host","username","pssword");
mysql_select_db("dtabase name",$db);
$query="select * from the table";
$res=mysql_fetch_object(mysql_query($query));
mysql_close($db);
///connected to the first server fetch the data and stored
in the $res varialble
$db=mysql_pconnect("secondhost","username","pssword");
mysql_select_db("dtabase name",$db);
$query="insert into tablename values($res)";
mysql_close($db);
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
Why do we need abstract class in php?
Tell me how comparison of objects is done in php5?
What are the file upload settings in configuration file?
What is final in php?
Tell me how do you define a constant?
what is the scope of php in the future if any other language is developed then may be php is loss ???
Are php session secure?
What are the different components used in php for formatting?
Is php front end?
How to uploaded files to a table?
Do you know what is the differences between $a != $B and $a !== $B?
What are the rules to declare a php variables?
How to strip whitespace (or other characters) from the beginning and end of a string?
List some features of php that are deprecated in php7?
what the new feature add in php 7.2?