连接数据据库单列模式的简单实现

<?php
class MysqlDb{
public $host;
public $user;
public $ps;
public $charset;
public $db;
private static $link;
private $resource;
public static function getInstance($config){
if(!isset(self::$link)){
self::$link=new self;
}
return self::$link;
}
private function __construct(){
$this->host=isset($config['host'])?$config['host']:'host';
$this->user=isset($config['user'])?$config['user']:'root';
$this->ps=isset($config['ps'])?$config['ps']:'root';
$this->charset=isset($config['charset'])?$config['charset']:'utf8';
$this->db=isset($config['db'])?$config['db']:'reportingStytem';
$this->connect();
$this->setcharset($this->charset);
$this->setdb($this->db);
}
private function __clone(){}
public function connect(){
$resource=mysql_connect("$this->host","$this->user","$this->ps")or die("数据库连接失败");
}
public function setcharset($charset){
mysql_set_charset($charset);
}
public function setdb($db){
mysql_select_db($db,$this->resource);
}
public function query($sql){
if(!$result=mysql_query($sql)){
echo "执行失败。";
echo "错误语句为：".$sql;
echo "错误信息为：".mysql_error();
echo "错误代号为：".mysql_errno();
die();
}
}
public function getAll($sql){
$result=$this->query($sql);
$arr=array();
while($rec=mysql_fecthassoc($result)){
$arr=$rec;
}
return $arr;
}
public function getRow($sql){
$result=$this->query($sql);
if($rec=mysql_fetch_assoc($result)){
return $rec;
}
return false;
}
public function getOne($sql){
$result=$this->query($sql);
$rec=mysql_fetch_row($sql);
if($rec===false){
return false;
}
return $rec[0];
}
public function escapeString($data){
return "'"mysql_real_escape_string($data,$this->resource)"'";
}
}
?>