php原始数据操作的封装类

<?php 
class DB{
	public $dbHost='localhost';
	public $dbUser='root';
	public $dbPwd='root';
	public $dbName='pro';
	public $dbCharset='utf8';
	public $links='';
	function __construct($dbHost,$dbUser,$dbPwd,$dbName,$dbCharset){
		//初始化属性
		$this->dbHost=$dbHost;
		$this->dbUser=$dbUser;
		$this->dbPwd=$dbPwd;
		$this->dbHost=$dbHost;
		$this->dbName=$dbName;
		$this->dbCharset=$dbCharset;
		//链接数据库
		$this->links=mysql_connect($dbHost,$dbUser,$dbPwd) or die(mysql_error());
		mysql_query("set names ".$this->dbCharset);//names后面有空格;
		mysql_select_db($this->dbName,$this->links);

	}
	function query($sql){
		return mysql_query($sql);
	}
	//select返回数据数目
	function numRows($sql){
		$result=$this->query($sql);
		return mysql_num_rows($result);//返回数据数目;
	}
	function affectedRows(){
		return mysql_affected_rows();
	}
	function fetchOne($sql){
		$result=$this->query($sql);
		$rs=mysql_fetch_assoc($result);//***
		return $rs;
	}
	//返回多条记录组成的2维数组；
	function fetchAll($sql){
		$result=$this->query($sql);
		$rows=array();
		while($rs=mysql_fetch_assoc($result)){
			$rows[]=$rs;
		}
		return $rows;
	}
	//释放资源;
	function __destruct(){
		$this->dbHost=NULL;
		$this->dbUser=NULL;
		$this->dbPwd=NULL;
		$this->dbHost=NULL;
		$this->dbName=NULL;
		$this->dbCharset=NULL;
		mysql_close();
	}
}

$db=new DB("localhost","root","root","pro","utf8");
$sql="select * from admin";
//header("Content-type:text/html:charset=uft-8");

$count=$db->fetchAll($sql);
print_r($count);





?>