how can we retrive value from one database server and store
them another database server using php?
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 |
Different between the var_dump() and print_r()?
What are the different components used in php for formatting?
what is the post and get method??
Tell me what does pear stands for?
How are cookies created?
How come the code works, but does not for two-dimensional array of mine?
Tell me what is use of in_array() function in php?
If the variable $a is equal to 5 and variable $b is equal to character a, what’s the value of $$b? Can anyone explain how's the value of $$b=100
15 Answers ABC, Asan, Indivar, Swistro Marketing Solutions,
What is the use of limit in mysql?
What is the functionality of md5 function in php?
Where are the persistent cookies stored on your computer?
What is the function mysql_pconnect() useful for?