mysql.class.php

一款文件上传程序

<?php
class mysqlDB
{
	var$_l;var$_r;var$_q;
	function mysqlDB($h,$u,$p,$db,$ps=0){$this->_l=false;$this->_r=false;$this->_q=0;$this->_r=0;$t='mysql_'.($ps?'p':'').'connect';$this->_l=$t($h,$u,$p);if(!$this->_l||!mysql_select_db($db))exit($this->error(__LINE__,__FILE__));return true;}
	function query($q){$this->_q++;$this->_r=@mysql_query($q,$this->_l);return$this->_r;}
	function getRow(){if($this->_r)return mysql_fetch_row ( $this->_r );return false;}
	function getAssoc(){if ($this->_r)return mysql_fetch_array($this->_r,MYSQL_ASSOC);return false;}
	function getArray(){if($this->_r)return mysql_fetch_array($this->_r,MYSQL_NUM);return false;}
	function getInsertId(){return mysql_insert_id($this->_l);}
	function getRowCount(){if($this->_r)return mysql_num_rows($this->_r);return false;}
	function getAffectRowCount(){if($this->_r)return mysql_affected_rows($this->_l);return false;}
	function error($l=-1,$f=''){return'mySQL: '.mysql_error()." on line $l in $f";}
	function escape($s){return function_exists('mysql_real_escape_string')?mysql_real_escape_string($s,$this->_l):addslashes($s);}
	function buildInsertStatement($arr){$ins=array();reset($arr);while(list($c,$v)=each($arr)){$ins[]=$v===NULL?sprintf("`%s`=NULL",$c ):sprintf("`%s`='%s'",$c,$v);}return implode(', ',$ins);}

	function free(){return @mysql_free_result($this->_r);}
}
?>