一個php與mysql串連類

本文介紹下，一個不錯的php與mysql串連類，php5實現的，有需要的朋友參考下吧。 代碼： Connect();}function __destruct(){ $this->Close();}private function Connect(){ //資料庫連接 $this->link=mysql_connect($this->Host,$this->UserName,$this->Password) or die("Error Connect to DB"); $this->SetError(mysql_error()); //select db ... mysql_select_db($this->DbName) ;//or die("Error Select DB"); $this->SetError(mysql_error());}public function query($query){ //mysql查詢 $this->query=mysql_query($query,$this->link); $this->SetError(mysql_error());} public function assoc(){ //mysql_fetch_assoc : return mysql_fetch_assoc($this->query); $this->SetError(mysql_error());}public function num(){ //mysql_num_rows: return mysql_num_rows($this->query); $this->SetError(mysql_error());} public function result($index=0){ //mysql_result : return mysql_result($this->query,$index); $this->SetError(mysql_error());} private function SetError($error){ $this->last_error=$error;}public function ShowError(){ return $this->last_error;}private function Close(){ mysql_close($this->link);}}?> 調用樣本： query("select * from table "); //get number of result echo $con->num() . PHP_EOL; //get result echo $con->result(/* $index */) . PHP_EOL; //get all result while($row=$con->assoc()) var_dump($row);

