实现PHP访问MYSQL数据库的类

PHP的一个数据库操作类,以UTF8格式写入,数据库内直接显示正常中文,防止查询出错
/**
* @author xggxnn
* 本类用于实现有关数据库的访问
*
*/
class DBConnection {
private $host = "";
private $user = "";
private $pass = "";
private $DBname = "";
public $isConnected = false;
/**
* 构造函数将数据库连接的参数初始化
*/
function __construct() {
$this->host = DB_SERVER_NAME;
$this->user = DB_USER_NAME;
$this->DBname = DB_NAME;
$this->pass = DB_PASS;
}
/**
* 连接数据库
*/
function getConnected(){
$this->isConnected = mysql_connect($this->host,$this->user,$this->pass);
if (!$this->isConnected) {// cannot connect to mysql
return $this->isConnected;
} else {//select database
mysql_query('set character_set_client = utf8, character_set_connection =utf8, character_set_results = utf8');
$result = mysql_select_db($this->DBname,$this->isConnected);
if (!$result){// cannot select the database
return $this->isConnected;
} else {
$this->isConnectd = true;
return $this->isConnected;
}
}
}
/**
* 关闭数据库
*/
function closeDB() {
if ($this->isConnected) {
$result = mysql_close($this->isConnected);
if (!$result) {// failed to close mysql connnection
return $result;
} else {
$this->isConnected = false;
return true;
}
} else {
return true;
}
}
/**
* 当连接对象解构时，关闭数据库连接
*/
function __destruct() {
$this->closeDB();
}
}