客服电话
APP下载
迪恩网络APP
随时随地掌握行业动态
官方微信
扫描二维码
关注迪恩网络微信公众号
|
PHP同时连接多个mysql数据库的具体实现 方法一：
1 <?php
2 $conn1 = mysql_connect("127.0.0.1", "root","root","db1");
3 mysql_select_db("Muma", $conn1);
4 $conn2 = mysql_connect("127.0.0.1", "root","root","db2");
5 mysql_select_db("product", $conn2);
6
7 $sql = "select * from ip";
8 $query = mysql_query($sql,$conn1); //添加连接$conn1
9 if($row = mysql_fetch_array($query))
10 echo $row[0]."\n";
11
12 $sql = "select * from web ";
13 $query = mysql_query($sql, $conn2);
14 if($row = mysql_fetch_array($query))
15 echo $row[0];
16 ?>
方法2：在sql语句中关联所用数据库，此时可以省略mysql_query的第二个参数，即：
1 <?php
2 $conn1 = mysql_connect("127.0.0.1", "root","root","db1");
3 mysql_select_db("db1", $conn1);
4 $conn2 = mysql_connect("127.0.0.1", "root","root","db2");
5 mysql_select_db("db2", $conn2);
6
7 $sql = "select * from db1.ip"; //关联数据库
8 $query = mysql_query($sql);
9 if($row = mysql_fetch_array($query))
10 echo $row[0]."\n";
11
12 $sql = "select * from db2.web ";
13 $query = mysql_query($sql);
14 if($row = mysql_fetch_array($query))
15 echo $row[0];
16 ?>
|
2022-07-22
2022-07-29
2022-08-30
2022-08-17
2022-08-15
librespeed/speedtest: Self-hosted Speedtest for HTML5 and more. Easy setup, exam
IBM Security Verify Information Queue 10.0.2 is vulnerable to cross-site request
avehtari/BDA_m_demos: Bayesian Data Analysis demos for Matlab/Octave
女人怀孕后，为了有一个健康聪明的宝宝，经历各种体检、筛查。其实这些体检和筛查中的
medfreeman/markdown-it-toc-and-anchor: markdown-it plugin to add a toc and ancho
sydney0zq/covid-19-detection: The implementation of A Weakly-supervised Framewor
Vesta v1.0.0-5 was discovered to contain a cross-site scripting (XSS) vulnerabil
离中国最远的国家是阿根廷。从太平洋直线计算，即往东线走，北京到阿根廷的布宜诺斯艾
sslcommerz/SSLCommerz-Laravel: SSLCOMMERZ is a bangladeshi payment gateway provi
shem8/MaterialLogin: Login view with material design
请发表评论