< ? Class MySQL { var $host; var $user; var $passwd; var $database; function MySQL() //利用构造函数实现变量初始化 { $host = ""; $user = ""; $passwd = ""; $database = ""; } function Connect() { $conn = MySQL_connect($this->host, $this->user,$this->passwd) or die("Could not connect to $this->host"); MySQL_select_db($this->database,$conn) or die("Could not switch to database $this->database;"); return $conn; } function Close($conn) { MySQL_close($conn); }
function Query($queryStr, $conn) { $res =MySQL_query($queryStr, $conn) or die("Could not query database"); return $res; } function getRows($res) { $rowno = 0; $rowno = MySQL_num_rows($res); if($rowno>0) { for($row=0;$row<$rowno;$row++) { $rows[$row]=MySQL_fetch_row($res); } return $rows; } } function getRowsNum($res) { $rowno = 0; $rowno = mysql_num_rows($res); return $rowno; } } ? > 同样我们要封装其他的“数据库驱动”到我们的SQL类中,只需要建立相应的类,并以同名命名驱动文件,放到PHP的include目录就可以了。