Interested to Buy Any Domain ? << Click Here >> for more details...
how can we retrive value from one database server and store
them another database server using php?
- 3 Answers
- 8520 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sunilchai
Hi Bharat your answer will work if we have low values but I
had come across the situation where I need to connect to
msaccess database where it has nearly 10000 records need to
fetch the records and insert in mysql.Keeping all the
sensitive info in the sessions will exceed the server
session memory
thanks and regards,
sunilchai
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / bharat
Another option is :
we can stored all values in sessions of one database.
and these sessions values insert in to another database.
| Is This Answer Correct ? | 2 Yes | 6 No |
How do I stop a php script?
What is difference between session_unset and session_destroy?
What is asort php?
What is the interface in php?
What kind of things have you done on the social side?
What are the different types of errors in PHP?
What is the expansion of LAMP?
What are hooks in php?
What is meant by pear in php? What is the purpose of it?
How to get number of days between two given dates using PHP?
explain the changes in php version
How can we submit a form without a submit button?
PHP 
