db.php

美丽心雨 飞狐源码站 优化修正了50%以上的代码

<?php
XYDW == OK or exit('Forbidden');
class db {
    var $query_num = 0;
    function dbconnect($pconnect=1){
         global $dbhost,$dbname,$dbuser,$dbpwd;
         if($pconnect){
            mysql_pconnect($dbhost,$dbuser,$dbpwd) or die("不能连接服务器 Can't connect the host.");
         } else mysql_connect($dbhost,$dbuser,$dbpwd) or die("不能连接服务器 Can't connect the host.");
         mysql_select_db($dbname) or die("不能选择服数据库 Can't select database.");
    }
   function query($sql,$method='') {
        global $tablepre;
        $sql = str_replace("xydw_","$tablepre",$sql);
		if($method=='U_B' && function_exists('mysql_unbuffered_query')){
			$query = mysql_unbuffered_query($sql);
		}else{
			$query = mysql_query($sql);
		}
		$this->query_num++;
		if (!$query)  $this->halt('Query Error: ' . $SQL);
		return $query;
	}
    function getdb($sql,$type=''){
         $arr = array();
         $dbs = $this->query($sql,'U_B');
         if($type=='1'){
            while($result = mysql_fetch_array($dbs,MYSQL_ASSOC)){
               $arr[] = $result;
            }
         } else{
            while($result = mysql_fetch_array($dbs)){
               $arr[] = $result;
           }
         }
         return $arr;
    }
    function getone($sql){
         $query = $this->query($sql,'U_B');
         $result = mysql_fetch_array($query,MYSQL_ASSOC);
         return $result;
    }
    function fetch_array($sql){
         $result = mysql_fetch_array($sql,MYSQL_ASSOC);
         return $result;
    }
	function halt($msg='') {
		require_once(R_P.'include/db_error.php');
		new DB_ERROR($msg);
	}
}
?>