Loading... # 方法一 ```php <?php $conn1 = mysql_connect("127.0.0.1", "root","root","db1"); mysql_select_db("Huju", $conn1); $conn2 = mysql_connect("127.0.0.1", "root","root","db2"); mysql_select_db("yun", $conn2); $sql = "select * from user"; $query = mysql_query($sql,$conn1); //添加连接$conn1 if($row = mysql_fetch_array($query)) echo $row[0]."\n"; $sql = "select * from url "; $query = mysql_query($sql, $conn2); if($row = mysql_fetch_array($query)) echo $row[0]; ?> ``` # 方法二:在sql语句中关联所用数据库,此时可以省略mysql_query的第二个参数 ```php <?php $conn1 = mysql_connect("127.0.0.1", "root","root","db1"); mysql_select_db("db1", $conn1); $conn2 = mysql_connect("127.0.0.1", "root","root","db2"); mysql_select_db("db2", $conn2); $sql = "select * from db1.user"; //关联数据库 $query = mysql_query($sql); if($row = mysql_fetch_array($query)) echo $row[0]."\n"; $sql = "select * from db2.url "; $query = mysql_query($sql); if($row = mysql_fetch_array($query)) echo $row[0]; ?> ``` 最后修改:2022 年 02 月 24 日 © 允许规范转载 打赏 赞赏作者 支付宝微信 赞 如果觉得我的文章对你有用,请随意赞赏