//by http://bbs.it-home.org
class mySql{
private $result;
private $conn;
public static $hasNew = false;
private __construct(){}
function __destruct(){
self::$hasnew=false;
}
function doNew(){
if(self::$have_new){
exit('数据库只能连接一次!');
}else{
self::$hasNew=true;
return new self;
}
}
private function connect($host,$user,$password,$dbname,$charset='utf8'){
$this->conn = mysql_connect($host,$user,$password) or exit('错误码:'.mysql_errno(). '数据库连接失败:'.mysql_error());
mysql_select_db($dbname,$this->conn) or exit('错误码:'.mysql_errno().'选择数据库失败:'.mysql_error());
mysql_query("set names $charset",$this->conn);
}
function query($sql,$buffer=true){
//mysql_real_escape_string($sql,$this->conn);//特殊字符义
if($buffer){
$this->result=mysql_query($sql,$this->conn) or exit('错误码:'.mysql_errno().'sql语句执行失败:'.mysql_error());
}else{
$this->result=mysql_unbuffered_query($sql,$this->conn) or exit('错误码:'.mysql_errno().'sql语句执行失败:'.mysql_error());
}
}
function getRecord(){
return mysql_fetch_array($this->result);
}
function close(){
mysql_free_result($this->result);
mysql_close($this->conn);
}
}