PHP 简单mysql封装类

<?php
	
class Mysql {
	private $host ;
	private $user ;
	private $pwd ;
	private $dbName ;
	private $charset ;
	private $conn=null ;
	
	public function __construct(){

		$this->host = 'localhost' ;
		$this->user = 'root' ;
		$this->pwd = '' ;
		$this->dbName = 'test' ;

		//链接
		$this->connect($this->host, $this->user, $this->pwd);

		//切换库
		$this->switchDb($this->dbName) ;

		//设置字符集
		$this->setChar($this->charset);
	}
	
	//负责连接数据库
	private function connect($h, $u , $p){
		$conn = mysql_connect($h, $u , $p);
		$this->conn = $conn ;
		
	}
	
	//查询
	public function query($sql){
		return mysql_query($sql,$this->conn);
	}
	
	//切换数据库
	public function switchDb($db){
		$sql = 'use '.$db;
		$this->query($sql);
	}

	//设置字符集
	public function setChar($char){
		$sql = 'set names '.$char;
		$this->query($sql);
	}

	//返回多行多列结果
	public function getAll($sql){
		$list = array();
		$rs = $this->query($sql) ;
		if (!$rs)
		{
			return false;
		};

		while ( $row = mysql_fetch_assoc($rs) )
		{
			$list[] = $row ;
		}

		return $list ;
	}

	//获取一行的结果

	public function getRow($sql){
		$rs = $this->query($sql) ;

		if (!$rs){
			return false;
		}
		return mysql_fetch_assoc($rs) ;
	}

	public function getOne($sql){
		$rs = $this->query($sql) ;

		if (!$rs){
			return false;
		}
		$row = mysql_fetch_row($rs) ;

		return $row[0] ;
	}

	public function __destruct(){
		mysql_close($this->conn);
	}

}

$mysql = new Mysql();
//print_r($mysql);
/*
$sql = "insert into class values ('李四','20','90','80')" ;
	if ( $mysql->query($sql)){
		echo '查询成功哦！' ;
	}
	else
	{
		echo '查询失败哦！' ;
	}
*/
echo '<br />' ;
$sql = 'select * from class' ;
$arr = $mysql->getAll($sql) ;

//print_r($arr) ;

$sql = 'select * from class where score = 0' ;

print_r($mysql->getRow($sql)) ;

$sql = 'select count(*) from class' ;

print_r($mysql->getOne($sql)) ;


?>

转自：燕十八