how can we retrive value from one database server and store
them another database server using php?
- 3 Answers
- 7434 Views
- I also Faced
- E-Mail Answers
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
Tell me what's the difference between include and require?
What’s the special meaning of __sleep and __wakeup?
How do you end php?
What is a php trait?
Why php is better?
How do you end a session in php?
Why php is also called as scripting language?
Why overriding is called runtime polymorphism?
What is T_PAAMAYIM_NEKUDOTAYIM?
What is difference between include,require,include_once and require_once()?
What does a delimiter do in mysql?
What are the different types of php variables?
How to download files from an external server with code in php?
What is difference between include and include_once in php?
How are php sessions stored?
