PHP操作Mysql数据库类

自己使用的数据库操作类

不过一般有一个配置文件我独立开来了

在使用这个类文件的时候需要包含进来，如果不包含那么需要传入参数<?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $dbname = 'static_html'; $dbprefix = ''; $dbcharset = 'utf8'; ?>

这个是数据库操作类

<?php /* QQ:8390671 Author:JustBeBetter Date:2011-02-09 */ class db{ private $conn; public function __construct(){ global $dbhost,$dbuser,$dbpass,$dbname,$dbcharset,$dbprefix; $this->dbhost = $dbhost; $this->dbuser = $dbuser; $this->dbpass = $dbpass; $this->dbname = $dbname; $this->dbprefix = $dbprefix; $this->Coding = $dbcharset; } function conn(){ $conn = mysql_connect ($this->dbhost,$this->dbuser,$this->dbpass); mysql_query("set names " . $this->Coding); return $conn; } function SelectSQL($SQL,$ResultType=2){ switch ($ResultType){ case 0:$ResultType=MYSQL_NUM;break; case 1:$ResultType=MYSQL_ASSOC;break; default:$ResultType=MYSQL_BOTH;break; } $conn = $this->conn(); mysql_select_db($this->dbname,$conn); $result = mysql_query($SQL); while($row = mysql_fetch_array($result,$ResultType)){$array[] = $row;} mysql_free_result($result); mysql_close($conn); if(!is_array(@$array)){$array=array();} return $array; } function ExecuteSQL($SQL,$ResultType=0){ $conn = $this->conn(); mysql_select_db($this->dbname,$conn); @$result = mysql_query($SQL); if($ResultType==1) $result = mysql_insert_id(); mysql_close($conn); return $result; } } ?>