php mysql資料庫類(php新手入門)

//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); } } 複製代碼 2、調用樣本 //資料庫 $db_host='localhost'; $db_user='root'; $db_pwd='root'; $db_name='news'; $charset='utf8'; $sql="select * from news_base"; $db=mySql::doNew(); $db->connect($db_host,$db_user,$db_pwd,$db_name,$charset='utf8'); $db->query($sql); while($row=$db->getRecord()){ echo $row[1].' '; } 複製代碼

