Question

I m试图将数据库数据复制到另一个数据库。我试图采用以下程序,但该程序并未奏效。 I m New to MySQL and PHP

<?php 
require_once( conf.php );
?>
<?php 
$q=mysql_query("SELECT * FROM navroop_mlm.".memberlogtbl." WHERE totalleft >= 7  AND totalright >= 7 ");
while($r=mysql_fetch_array($q)){
$id=$r[ id ];
$qlnk=mysql_pconnect("localhost", "navroop_mlm", "guwahati0011*");
mysql_select_db("navroop_aip", $qlnk);

mysql_query("INSERT INTO member_login (id, name, username, password,sex) VALUSE ( $id ,  ".$r[ name ]." ,  ".$r[ username ]." ,  ".$r[ password ]." ,  ".$r[ sex ]." )");
}

请帮助我。这里的用户名、密码和服务器与两个数据库相同。

Answer 1

从来没有这样做。 <>不是你认为它会做些什么,将来会造成一定的痛苦。如果需要复制两个数据库的数据,使用数据库复制或找到另一种解决办法。 Don t Violations of the SPOT Rule。

Answer 2

Uhm,

如果两个数据库的连接参数相同,你只能利用MySQL的辛迪加将数据库名称列入询问:

INSERT INTO database2.member_login (id, name, username, password, sex)
SELECT id, name, username, password, sex from navroop_mlm.member_login;

这正是你想要的,即在一个数据库中选择,插入另一个数据库。

Answer 3

问题有可帮助你的答案。

From the answer: “......

$dbh1 = mysql_connect($hostname, $username, $password); 
$dbh2 = mysql_connect($hostname, $username, $password, true); 

mysql_select_db( database1 , $dbh1);
mysql_select_db( database2 , $dbh2);

Then to query database 1, do

mysql_query( select * from tablename , $dbh1);

表2

mysql_query( select * from tablename , $dbh2);

“......

我怀疑,在您的休息之前,你可以与数据库连接,然后在休息室使用第二个链接和您的INSERT INTO查询。

Furthermore, a superior solution would be to use PDO, which is a better alternative to the standard mysql_ functions, as well as more easily allow you to query a second database while looping through the first query s results. http://www.phpro.org/tutorials/Introduction-to-PHP-PDO.html#4.3 (a basic PDO tutorial).

Answer 4

您正在铺设通道,而不是关闭。如上文所述,这可能导致超高射电机的连接门槛。

相反,你可以有单独的联系。

$conn1=mysql_connect("localhost", "navroop_mlm", "guwahati0011*");
$conn2=mysql_connect("localhost", "navroop_mlm", "guwahati0011*");
mysql_connect_db("navroop_mlm",$conn1);
mysql_connect_db("database2",$conn2);

$q=mysql_query("SELECT * FROM $memberlogtbl WHERE totalleft >= 7  AND totalright >= 7 ",$conn1);

while($r=mysql_fetch_array($q))
{
$id=$r[ id ];

mysql_query("INSERT INTO member_login (id, name, username, password,sex) VALUES ( $id ,  ".$r[ name ]." ,  ".$r[ username ]." ,  ".$r[ password ]." ,  ".$r[ sex ]." )",$conn2);
}

mysql_close($conn1);
mysql_close($conn2);

友情链接