📄 mysql.php

📁 极限OA开源系统
💻 PHP
字号:
<?php
class dbclass {
	var $querynum = 0;
    var $db_die   = 0;
	function connect($dbhost, $dbuname, $dbpass, $dbname, $pconnect = 0) {
		global $timpstamp,$querytime;
		if($GLOBALS['set_debug']) {
			$pageendtime=microtime();
			$starttime=explode(" ",$timpstamp);
			$endtime=explode(" ",$pageendtime);
			$beforetime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];
		}
		if($pconnect) {
			if(!@mysql_pconnect($dbhost, $dbuname, $dbpass)) {
				$this->occur_error("MySQL 数据库无法连接，请检查服务器或程序设置");
			}
		} else {
			if(!@mysql_connect($dbhost, $dbuname, $dbpass)) {
				$this->occur_error("MySQL 数据库无法连接，请检查服务器或程序设置");
			}
		}
		if($GLOBALS['set_debug']) {
			$pageendtime=microtime();
			$starttime=explode(" ",$timpstamp);
			$endtime=explode(" ",$pageendtime);

			$aftertime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];
			$querytime+=$aftertime-$beforetime;
		}
	}

	function select_db($dbname) {
		return mysql_select_db($dbname);
	}

	function fetch_array($query, $result_type = MYSQL_ASSOC) {
		$query = mysql_fetch_array($query, $result_type);
		return $query;
	}

	function query($sql, $silence = 0) {
		global $timpstamp,$querytime,$tablepre,$sql_s;
		if($GLOBALS['set_debug']) {
			$pageendtime=microtime();
			$starttime=explode(" ",$timpstamp);
			$endtime=explode(" ",$pageendtime);
			$beforetime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];
		}
$sql_s .= $sql.'<br>';
		$query = mysql_query($sql);
		if(!$query && !$silence) {
			if(mysql_errno() == 1016) {
				mysql_query("REPAIR TABLE $tablepre"."stat_mem");
				mysql_query("REPAIR TABLE $tablepre"."members");
				mysql_query("REPAIR TABLE $tablepre"."post");
				mysql_query("REPAIR TABLE $tablepre"."thread");
			}
			$query = mysql_query($sql);
			if(!$query && !$silence) {
				$this->occur_error("MySQL Query 错误", $sql);
			}

		}
		$this->querynum++;


		if($GLOBALS['set_debug']) {
			$pageendtime=microtime();
			$starttime=explode(" ",$timpstamp);
			$endtime=explode(" ",$pageendtime);

			$aftertime=$endtime[0]-$starttime[0]+$endtime[1]-$starttime[1];
			$querytime+=$aftertime-$beforetime;
		}

		return $query;
	}

	function query_fetch($sql) {
		$query = $this->query($sql);
		$returnarray=$this->fetch_array($query);
		$this->free_result($query);
		return $returnarray;
	}

	function affected_rows() {
		return mysql_affected_rows();
	}

	function result($query, $row) {
		$query = @mysql_result($query, $row);
		return $query;
	}

	function num_rows($query) {
		$query = mysql_num_rows($query);
		return $query;
	}

	function num_fields($query) {
		return mysql_num_fields($query);
	}

	function free_result($query) {
		return mysql_free_result($query);
	}

	function insert_id() {
		$id = mysql_insert_id();
		return $id;
	}

	function fetch_row($query) {
		$query = mysql_fetch_row($query);
		return $query;
	}

	function close() {
		return mysql_close();
	}
	function error() {
		return mysql_error();
	}

    function occur_error($error='',$sql='') {    	
    	if ($this->db_die == 1) {
    		$this->error = mysql_error();
    		return TRUE;
    	}
		$sql_error .= "";
		$sql_error .= "错误提示:  ".mysql_error()."\n";
		$sql_error .= "错误代号:  ".mysql_errno()."\n";
		$sql_error .= "发生时间:  ".date("Y-m-d H:i:s")."\n";
		$sql?($sql_error .= "错误语句:   $sql"):NULL;
		$sql_error = nl2br($sql_error);
    	
    	$errorout = "<html><head><title>数据库发生错误</title>
    		    <style>P,BODY{ font-family:宋体,arial,sans-serif; font-size:12px; }</style>
				</head>
				<body>
    		   &nbsp;<br><br><blockquote>数据库发生错误 如不能解决请与<a href=\"http://www.1119.net\" target=_blank>极限网络</a>联系以获取技术支持 
				<br>$sql_error<br><br>
    		   你也可<a href=\"javascript:window.location=window.location;\">点此</a>刷新此页, 若错误仍然存在
			   请正确对待</body></html>";
    		   
    
        echo($errorout);
		exit;
    }
}

if(!$install_tmp) {
	$db=new dbclass;
	$db->connect($dbhost,$dbuname,$dbpass,$pconnect);
	$db->select_db($dbname);
	unset($dbhost, $dbuname, $dbpass, $dbname, $pconnect);
}
?>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -