PHP 串連MySQL 的單態類

<?php/** * author: xueming */class MySQLConnFactory{private $conn;static private $_mysqlconn;//Construct-->connect DBprivate function __construct($host,$username,$password){$this->conn = mysql_connect($host,$username,$password);$this->query("SET NAMES 'utf8'");return $this->conn;}    private function __clone(){}public static function getSingleMySQLConn($host,$username,$password){if(FALSE==(self::$_mysqlconn instanceof self)){self::$_mysqlconn = new self($host,$username,$password);}return self::$_mysqlconn;}//select DBpublic function select_db($database){$this->result = mysql_select_db($database);return $this->result;}//Query public function query($query){return $this->result = mysql_query($query, $this->conn);}//fetch resultpublic function fetch_array($fetch_array){return $this->result = mysql_fetch_array($fetch_array, MYSQL_ASSOC);}//closepublic function close(){return $this->result = mysql_close($this->conn);}}?>

調用方式如下

    $sql = "select * from test";    $connector = MySQLConnFactory::getSingleMySQLConn($db_server,$db_user,$db_pwd);    $connector -> select_db($db_name);    $result = $connector -> query($sql);