实现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 mysqlreturn $this->isConnected;} else {//select databasemysql_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 databasereturn $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 connnectionreturn $result;} else {$this->isConnected = false;return true;}} else {return true;}}/** * 当连接对象解构时，关闭数据库连接 */function __destruct() {$this->closeDB();}}