db_mysql.php

实时统计出pc蛋蛋的幸运28开奖数据

<?php
Class DB {
	var $query_num = 0;
	var $link = null;

	function DB($dbhost, $dbuser, $dbpw, $dbname, $pconnect = 0) {
		$this->connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect);
	}

	function connect($dbhost, $dbuser, $dbpw, $dbname, $pconnect = 0) {
		$this->link = $pconnect==0 ? @mysql_connect($dbhost, $dbuser, $dbpw) : @mysql_pconnect($dbhost, $dbuser, $dbpw);
		if($dbname) {
			if (!@mysql_select_db($dbname,$this->link)){
			}
		}
	}

	function close() {
		return mysql_close();
	}

	function select_db($dbname){
		if (!@mysql_select_db($dbname,$this->link)){
		}
	}

	function query($SQL,$method='') {
		if($method=='U_B' && function_exists('mysql_unbuffered_query')){
			$query = mysql_unbuffered_query($SQL,$this->link);
		}else{
			$query = mysql_query($SQL,$this->link);
		}
		$this->query_num++;
		
		//echo $SQL.'<br>'.$this->query_num.'<br>';
		//echo mysql_error();
		return $query;
	}

	function get_one($SQL){

		$query=$this->query($SQL,'U_B');
		
		$rs =& mysql_fetch_array($query, MYSQL_ASSOC);

		return $rs;
	}

	function if_update($SQL_1,$SQL_2,$SQL_3){
		$rt=$this->get_one($SQL_1);
		if($rt){
			$this->update($SQL_2);
		} else{
			$this->update($SQL_3);
		}
	}

	function update($SQL) {
		if(function_exists('mysql_unbuffered_query')){
			$query = mysql_unbuffered_query($SQL,$this->link);
		}else{
			$query = mysql_query($SQL,$this->link);
		}
		$this->query_num++;
		
		//echo $SQL.'<br>'.$this->query_num.'<br>';

		return $query;
	}

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

	function affected_rows() {
		return mysql_affected_rows($this->link);
	}

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

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

	function insert_id() {
		$id = mysql_insert_id($this->link);
		return $id;
	}
}
?>