1# blankyao 发表于2007-09-20

一个数据库类

水水同学的一个数据库类

[复制到剪切板]
CODE:
<?php    
// ========================== 文件说明 ==========================//    
// 本文件说明：数据库类    
// --------------------------------------------------------------//    
// Copyright (C) 僭燮水 Team All Rights Reserved.    
// ==============================================================//    
error_reporting(7);    
   
class DB_MySQL  {    
   
      var $servername="localhost";    
      var $dbname="test";    
      var $dbusername="root";    
      var $dbpassword="123456";    
   
      var $link_id = 0;    
      var $result;    
      var $record = array();    
      var $rows;    
   
      function connect(){    
               global $usepconnect;    
               if ($usepconnect==1){    
                   if (!$this->link_id = @mysql_pconnect($this->servername,$this->dbusername,$this->dbpassword)){    
                        $this->halt("数据库链接失败");    
                   }    
               } else {    
                   if (!$this->link_id = @mysql_connect($this->servername,$this->dbusername,$this->dbpassword)){    
                        $this->halt("数据库链接失败");    
                   }    
               }    
               return $this->link_id;    
      }    
   
      function selectdb(){    
               if(!mysql_select_db($this->dbname)){    
                   $this->halt("数据库链接失败");    
               }    
      }    
   
      function query($query_string) {    
               $this->result = mysql_query($query_string,$this->link_id);    
               if (!$this->result) {    
                   $this->halt("SQL 无效: ".$query_string);    
               }    
               return $this->result;    
      }    
   
   
      function fetch_array($queryid) {    
               $this->record = mysql_fetch_array($queryid);    
               if (emptyempty($queryid)){    
                   $this->halt("Query id 无效:".$queryid);    
               }    
               return $this->record;    
      }    
   
      function num_rows($queryid) {    
               $this->rows = mysql_num_rows($queryid);    
               if (emptyempty($queryid)){    
                   $this->halt("Query id 无效:".$queryid);    
               }    
               return $this->rows;    
      }    
   
      function close() {    
               @mysql_close($this->link_id);    
      }    
   
   
      function halt($msg){    
               $message = "<html>\n<head>\n";    
               $message .= "<meta content=\"text/html; charset=gb2312\" http-equiv=\"Content-Type\">\n";    
               $message .= "<STYLE TYPE=\"text/css\">\n";    
               $message .=  "body,td,p,pre {\n";    
               $message .=  "font-family : Verdana, sans-serif;font-size : 12px;\n";    
               $message .=  "}\n";    
               $message .=  "</STYLE>\n";    
               $message .= "</head>\n";    
               $message .= "<body bgcolor=\"#F7F7F7\" text=\"#000000\" link=\"#006699\" vlink=\"#5493B4\">\n";    
   
               $message .= "<p>数据库出错:</p><b>".htmlspecialchars($msg)."</b><p>\n";    
               $message .= "<b>Date</b>: ".date("Y-m-d @ H:i")."\n<br>";    
               $message .= "<b>Script</b>: http://".$_SERVER[HTTP_HOST].getenv("REQUEST_URI")."\n<br>";    
               $message .= "<b>Referer</b>: ".getenv("HTTP_REFERER")."\n<br><br>";    
   
               $message .= "</body>\n</html>";    
               echo $message;    
               exit;    
      }    
}    
?> ;