PHP5和MYSQL數(shù)據(jù)庫操作函數(shù)封裝類集合
來源:程序員人生 發(fā)布時間:2014-05-29 00:19:31 閱讀次數(shù):4049次
建站學院(LieHuo.Net)轉(zhuǎn)載文檔 相信用過PHP的用戶都用過這類的封裝類吧,網(wǎng)上也有很多類似的發(fā)布,不過各有各長,現(xiàn)在我就把我本人的發(fā)布出來,供PHP初學者使用,也歡迎專家批評指正,在此謝過了,只能PHP5下使用,PHP4的話可以修改以后再用吧。
以下為引用的內(nèi)容: <!--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 服務(wù)器地址 $user 用戶名 $pass 密碼 $db 數(shù)據(jù)庫名稱 //構(gòu)造函數(shù) function __construct($host,$user,$pass,$db) { self::$host = $host; self::$pass = $pass; self::$user = $user; self::$db = $db; self::Connect(); }//__construct() //析構(gòu)函數(shù) 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("連接數(shù)據(jù)庫失敗!可能是mysql數(shù)據(jù)庫用戶名或密碼不正確"); 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; }//這里只返回數(shù)字索引 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("未找到指定數(shù)據(jù)庫!"); } 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)轉(zhuǎn)載文檔 相信用過PHP的用戶都用過這類的封裝類吧,網(wǎng)上也有很多類似的發(fā)布,不過各有各長,現(xiàn)在我就把我本人的發(fā)布出來,供PHP初學者使用,也歡迎專家批評指正,在此謝過了,只能PHP5下使用,PHP4的話可以修改以后再用吧。 以下為引用的內(nèi)容: ___FCKpd___0 | SERVER['PHP_SELF'].""; exit; } } --> |
生活不易,碼農(nóng)辛苦
如果您覺得本網(wǎng)站對您的學習有所幫助,可以手機掃描二維碼進行捐贈
------分隔線----------------------------
------分隔線----------------------------