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 '
' ;
$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)) ;
?> 转自:燕十八