ʵÏÖ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();
}
}