程序员人生 网站导航

PHP5和MYSQL数据库操作函数封装类集合

栏目:综合技术时间:2014-05-29 00:19:31

 建站学院(LieHuo.Net)转载文档 相信用过PHP的用户都用过这类的封装类吧,网上也有很多类似的发布,不过各有各长,现在我就把我本人的发布出来,供PHP初学者使用,也欢迎专家批评指正,在此谢过了,只能PHP5下使用,PHP4的话可以修改以后再用吧。

以下为引用的内容:
<!--p//copyrights all reseved By CGclass db {   //public	public static $conn;	public static $data;	public static $fields;	public static $row;	public static $row_num;	public static $insertid;	public static $version;	public static $affected_rows;	public static $query_num = 0;	public static $debug = false;   //private	private static $user;	private static $pass;	private static $host;	private static $db;	$host 服务器地址	$user 用户名	$pass 密码	$db 数据库名称	//构造函数	function __construct($host,$user,$pass,$db)	{		self::$host = $host;		self::$pass = $pass;		self::$user = $user;		self::$db = $db;		self::Connect();	}//__construct()	//析构函数	function __destruct()	{	 	self::close();	}//__destruct()	public static function close() {	if(self::$conn!=NULL)		mysql_close(self::$conn);	}	//connect	public static function Connect() {	self::$conn =  mysql_connect(self::$host,self::$user,self::$pass) or self::msg("连接数据库失败!可能是mysql数据库用户名或密码不正确");	self::selectdb(self::$db);	}	public static function query($sql) {	$query =  mysql_query($sql,self::$conn) or self::msg("SQL语法错误:".htmlspecialchars($sql));	if(self::$debug) {	echo $sql . "";	}	self::query_num();	return $query;	}	public static function fetch_array($query) {	self::$data = mysql_fetch_array($query);	return self::$data;	} //这里返回全部的key	public static function fetch_assoc($query) {	self::$data = mysql_fetch_assoc($query , MYSQL_ASSOC);	return self::$data;	}//这里只返回key索引	public static function fetch_num($query) {	self::$data = mysql_fetch_num($query , MYSQL_NUM);	return self::$data;	}//这里只返回数字索引	public static function num_fields($query) {	self::$fields = mysql_num_fields($query);	return self::$fields;	}	public static function fetch_row($query) {	self::$row = mysql_fetch_row($query);	return self::$row;	}	public static function num_rows($query) {	self::$row_num = mysql_num_rows($query);	return self::$row_num;	}	public static function insert_id() {	self::$insertid = mysql_insert_id();	return self::$insertid;	}	public static function affected_rows() {	self::$affected_rows = mysql_affected_rows(self::$conn);	return self::$affected_rows;	}	public static function fetch_one_array($sql){	$query = self::query($sql);	self::$data = self::fetch_array($query);	return self::$data;	}	public static function free($data)	{	if($data) mysql_free_result($data);	}	private static function query_num(){	self::$query_num++;	}	private static function selectdb($db) {	mysql_select_db($db,self::$conn) or self::msg("未找到指定数据库!");	}	private static function version() {	self::$version = mysql_get_server_info();	return self::$version;	}	private static function geterror() {	return mysql_error();	}	private static function geterrno() {	return intval(mysql_errno());	}   private static function error($info) {	echo $info;	echo "";   }	private static function msg($info) {	echo "<strong>错误信息:</strong>";	echo "<b>Mysql error:</b>".self::geterror()."";	echo "<b>Mysql error number:</b>".self::geterrno()."";	echo "<b>Time</b>: ".gmdate("Y-n-j g:ia", time() + (8 * 3600))."";	echo "<b>Script</b>: ".

 建站学院(LieHuo.Net)转载文档 相信用过PHP的用户都用过这类的封装类吧,网上也有很多类似的发布,不过各有各长,现在我就把我本人的发布出来,供PHP初学者使用,也欢迎专家批评指正,在此谢过了,只能PHP5下使用,PHP4的话可以修改以后再用吧。

以下为引用的内容:
___FCKpd___0

SERVER['PHP_SELF'].""; exit; } } -->

------分隔线----------------------------
------分隔线----------------------------

最新技术推荐