how can we retrive value from one database server and store
them another database server using php?
- 3 Answers
- 7433 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 |
Why do we use session?
How many types of array are there in php?
Tell me how can we define a variable accessible in functions of a php script?
how to register website in internet
How do you check if an arraylist is empty?
Explain the syntax for ‘foreach’ loop with example.
Write a program in php to check whether a number is prime or not?
what does this symbol mean in php?
What is the difference between for and foreach loop in php?
Sir, I want sbi clearical post model question paper please sent my mail id srinivas_33000@ahoo.co.in
0 Answers State Bank Of India SBI,
Explain how is it possible to cast types in php?
How does html form submit work?
PHP 
