mysql.php

为我们学校开发的一个住房货币化补贴工作的专题网站

<?php
class mysql
{	
	var $dbhost="localhost";
	var $dbuser="root";
	var	$dbpw="";
	var	$dbname="easy";
	var $rs;
	////////////// init class ///////////////////
	 function mysql($dbhost="", $dbuser="", $dbpw="",$dbname="")
	 	{
			$this->dbhost = $dbhost ? $dbhost: $this->dbhost;
			$this->dbuser = $dbuser ? $dbuser: $this->dbuser;
			$this->dbpw   = $dbpw   ? $dbpw: 	$this->dbpw ;
			$this->dbname = $dbname ? $dbname:	$this->dbname;
			$this->connect(); 		/////connect server
			$this->select_db();  	///// select database
		}
	function connect($dbhost="",$dbuser="",$dbpw="") 
	{	
		$dbhost	=	$dbhost	?	$dbhost	:	$this->dbhost;
		$dbuser	=	$dbuser	?	$dbuser	:	$this->dbuser;
		$dbpw	=	$dbpw	?	$dbpw	:	$this->dbpw ;
			if(!$link=@mysql_pconnect($dbhost, $dbuser, $dbpw)) 
			{
				$this->halt('Can not connect to server');
			}
			return $link;
	}

	function select_db($dbname="") 
	{	
		$dbname=$dbname?$dbname:$this->dbname;
		return mysql_select_db($dbname);
	}
	
	function query($sql)
	{
		
		$query = mysql_query($sql);
		$this->rs=$query;		
		if(!$query)	$this->halt('MySQL Query Error');		
		return $query;
	}
	
	function fetch_object($rs="") 
	{	
		$rs=$rs?$rs:$this->rs;
		return @mysql_fetch_object($rs);
		
	}
	
	function fetch_array($rs="",$result_type = MYSQL_ASSOC) 
	{	
		$rs=$rs?$rs:$this->rs;
		return @mysql_fetch_array($rs, $result_type);
	}
	
	function num_rows($rs="") 
	{	
		$rs=$rs?$rs:$this->rs;
		return  mysql_num_rows($rs);
		
	}
	
	function insert_id() 
	{	
		return  mysql_insert_id();
	}
		
	function errno()
	{
		return mysql_errno();
	}

	function error() 
	{
		return mysql_error();
	}
	
	function affected_rows()
	{
		return @mysql_affected_rows();
	}
	
	function halt($message ="")
	{	
    	echo mysql_error(); echo mysql_errno ();
		echo $message;
		exit();
	}	

	function free_result($rs)
	{
		 mysql_free_result($rs);
	}
	
	function close($link) 
	{
		return mysql_close($link);
	}	

}//End for class

function check_str($str,$start,$len)
   {$str=trim($str);
	if (strlen($str) > $len){ 
     for($i=0; $i < $len; $i++) 
        if (ord($str[$i]) > 128) $i++; 
   $str= substr($str,$start,$i); 
} 
return $str;
}

?>