Re: [請益] 關於php同時連接多個db
※ 引述《marcoyan (回到正軌。)》之銘言：
: 想請問有沒大大寫過這樣的方式,同時連接2個以上的db
: 不知是否可以分享一下寫法
: 目前試過如果引入一個 db.php
我自己回答一下好了,不過我不知這方法是不是會有問題,如果寫的不好請多指教
class_db.php
<?php
/* 資料庫連線 Class */
class DB{
//主機1
var $dbhostname = 'host1';
var $dbusername = 'test1';
var $dbpassword = 'test1';
var $dbname = 'test1';
//主機2
var $dbhostname2 = 'host2';
var $dbusername2 = 'test2';
var $dbpassword2 = 'test2';
var $dbname2 = 'test2';
var $conn;
var $conn2;
function db_link(){
$this->conn = mysql_connect($this->dbhostname, $this->dbusername,
$this->dbpassword) or die('DB Account or Password is Error');
mysql_select_db($this->dbname,$this->conn) or die('DB Name is Error');
return $this->conn;
}
function db_link2(){
$this->conn2 = mysql_connect($this->dbhostname2, $this->dbusername2,
$this->dbpassword2) or die('DB Account or Password is Error');
mysql_select_db($this->dbname2,$this->conn2) or die('DB Name is Error');
return $this->conn2;
}
}
?>
class_order.php
<?php
class testOrder extends DB{
//取出訂單列表
function getList(){
$sql = "SELECT * FROM `trd_order`";
$rs = mysql_query($sql,$this->db_link());
echo mysql_num_rows($rs);
echo "<br/>";
$sql = "SELECT * FROM `test`";
$rs = mysql_query($sql,$this->db_link2());
echo mysql_num_rows($rs);
echo "<br/>";
exit;
}
}
?>
test.php 測試程式
<?php
include_once("class_db.php");
include_once("class_order.php");
$test = new testOrder();
$test->getList();
unset($test);
?>
以上。有寫的不好的地方請更正謝謝
--
相信，用心就能夠看見。
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.32.2.112
推
09/02 11:20, , 1F
09/02 11:20, 1F
→
09/02 12:46, , 2F
09/02 12:46, 2F
→
09/02 12:47, , 3F
09/02 12:47, 3F
→
09/02 15:21, , 4F
09/02 15:21, 4F
→
09/02 20:21, , 5F
09/02 20:21, 5F
討論串 (同標題文章)