适配器模式

发表于 | 分类于 | | 阅读次数

新建一个IDatabase

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
interface IDatabase{
	function connect($host,$user,$password,$dbname);
	function query($sql);
	function close();
}
Database下面的 mysql mysqli pdo
namespace IMooc\Database;
use IMooc\IDatabase;
class Mysql implements IDatabase{
	protected $conn;
	
	function connect($host, $user, $password, $dbname){
		$conn = mysql_connect($host,$user,$password);
		mysql_db_name($dbname,$conn);
		$this->conn = $conn;
	}
	function query($sql){
		$res = mysql_query($sql,$this->conn);
		return $res;
	}
	function close(){
		mysql_close($this->conn);
	}
	
}
namespace IMooc\Database;
use IMooc\IDatabase;
class PDO implements IDatabase{
	protected $conn;
	function connect($host,$user,$password,$dbname){
		$conn = new \PDO("mysql:host=$host;dbname=$dbname",$user,$password);
		$this->conn = $conn;
	}
	function query($sql){
		return $this->conn->query($sql);
	}
	function close(){
		unset($this->conn);
	}
}