PHP5和MYSQL數(shù)據(jù)庫(kù)操作函數(shù)封裝類(lèi)集合
來(lái)源:程序員人生 發(fā)布時(shí)間:2014-05-29 00:19:31 閱讀次數(shù):4054次
建站學(xué)院(LieHuo.Net)轉(zhuǎn)載文檔 相信用過(guò)PHP的用戶(hù)都用過(guò)這類(lèi)的封裝類(lèi)吧,網(wǎng)上也有很多類(lèi)似的發(fā)布,不過(guò)各有各長(zhǎng),現(xiàn)在我就把我本人的發(fā)布出來(lái),供PHP初學(xué)者使用,也歡迎專(zhuān)家批評(píng)指正,在此謝過(guò)了,只能PHP5下使用,PHP4的話(huà)可以修改以后再用吧。
以下為引用的內(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 用戶(hù)名 $pass 密碼 $db 數(shù)據(jù)庫(kù)名稱(chēng) //構(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ù)庫(kù)失敗!可能是mysql數(shù)據(jù)庫(kù)用戶(hù)名或密碼不正確"); self::selectdb(self::$db); } public static function query($sql) { $query = mysql_query($sql,self::$conn) or self::msg("SQL語(yǔ)法錯(cuò)誤:".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; }//這里只返回?cái)?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ù)庫(kù)!"); } 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>錯(cuò)誤信息:</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>: ". 建站學(xué)院(LieHuo.Net)轉(zhuǎn)載文檔 相信用過(guò)PHP的用戶(hù)都用過(guò)這類(lèi)的封裝類(lèi)吧,網(wǎng)上也有很多類(lèi)似的發(fā)布,不過(guò)各有各長(zhǎng),現(xiàn)在我就把我本人的發(fā)布出來(lái),供PHP初學(xué)者使用,也歡迎專(zhuān)家批評(píng)指正,在此謝過(guò)了,只能PHP5下使用,PHP4的話(huà)可以修改以后再用吧。 以下為引用的內(nèi)容: ___FCKpd___0 | SERVER['PHP_SELF'].""; exit; } } --> |
生活不易,碼農(nóng)辛苦
如果您覺(jué)得本網(wǎng)站對(duì)您的學(xué)習(xí)有所幫助,可以手機(jī)掃描二維碼進(jìn)行捐贈(zèng)