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
What are different types of errors available in Php?
Which function Returns the time of sunrise for a given day / location in PHP.
Write a php function to convert all null values to blank?
What are the method available in form submitting?
Tell me what is the main difference between require() and require_once()?
Do csrf tokens expire?
What are the advantages of triggers in php?
Why do we use htaccess
Write a program in php to check whether a number is prime or not?
How to store the uploaded file to the final location?
Xplain is it possible to use com component in php?
What is the use of inner join in mysql?
What is csrf token and why it is required?
What type of headers have to be added in the mail function to attach a file?
What is a http session?