雖然我確實(shí)同意依賴模型很好，但是對(duì)于數(shù)據(jù)庫，我個(gè)人使用一個(gè)靜態(tài)連接，它可以用于數(shù)據(jù)庫類的所有實(shí)例和CREATE實(shí)例，以便在需要時(shí)進(jìn)行查詢。以下是一個(gè)例子：
<?php//define a database classclass DB {
//the static connection.
//This is available to all instances of the class as the same connection.
private static $_conn;
//store the result available to all methods
private $result;
//store the last query available to all methods
private $lastQuery;
//static connection function. connects to the database and stores that connection statically.
public static function connect($host, $user, $pass, $db){
self::$_conn = mysqli_connect($host, $user, $pass, $db);
}
//standard function for doing queries. uses the static connnection property.
public function query($query){
$this->lastQuery = $query;
$this->result = mysqli_query(self::$_conn, $query);
//process result, return expected output.
}}//create connection to the database, this connection will be used in all instances of DB classDB:
:connect('local', 'DB_USER', 'DB_PASS');//create instance to query$test = new DB;
//do query$test->query("SELECT * FROM TABLE");//test functionfunction foo(){
//create instance to use in this function
$bar = new DB;
//do query
$bar->query("SELECT * FROM OTHER_TABLE");
//return results
return $bar->fetchArray();}這樣，我就可以在任何函數(shù)、方法.等中創(chuàng)建所有我想要的DB實(shí)例，并使用該類的本地實(shí)例來執(zhí)行所有查詢。所有實(shí)例都使用相同的連接。
但是要注意的一點(diǎn)是，這只允許每個(gè)定義的類連接到數(shù)據(jù)庫，但是我只使用一個(gè)，所以這對(duì)我來說不是問題。
