mysql循环数据库_在循环中连接MySQL中的另一个数据库

您正在循环中打开连接而不是关闭它们。如上所述，它可能导致超过mysql服务器的连接阈值。

相反，您可以拥有单独的连接

$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);