class DB { //database connection var $con = FALSE; function DB( $MYSQL_HOST =MYSQL_HOST, $MYSQL_USER =MYSQL_USER, $MYSQL_PASS =MYSQL_PASS, $MYSQL_DB =MYSQL_DB) { $this ->con = @mysql_connect( $MYSQL_HOST , $MYSQL_USER , $MYSQL_PASS ) or die ( "Could not connect to database" ); if ( $this ->con) { @mysql_select_db( $MYSQL_DB , $this ->con) or die ( "Could not select database" ); } return $this ->con; } function Query( $sql , $tran = false) { // if (!file_exists(MYSQL_LOG)) // { // @umask(0); // @mkdir(MYSQL_LOG, 0777); // } // ¼? //$fp = @fopen(MYSQL_LOG.date("Ymd").".txt", "a"); // д? // @fwrite($fp, date("Y-m-d H:i:s")."|$sql "); // @fclose($fp); $this ->sql = $sql ; if ( $tran ) { $this ->result = @mysql_query( $this ->sql) OR $this ->RollBack(); return $this ->result; } else { mysql_query( "SET NAMES 'utf8'" ); //mysql_query("SET NAMES 'gbk'"); $this ->result = @mysql_query( $this ->sql); return $this ->result; } } function RollBack() { $this ->Query( "ROLLBACK;" ); die ( "MySQL ROLLBACK;" ); } function NumRows( $result ) { $this ->result = $result ; return @mysql_num_rows( $this ->result); } function FetchRow( $result ) { $this ->result = $result ; return @mysql_fetch_row( $this ->result); } function FetchArray( $result ) { $this ->result = $result ; return @mysql_fetch_array( $this ->result, MYSQL_ASSOC); } function FetchArray2( $result ) { $this ->result = $result ; return @mysql_fetch_array( $this ->result, MYSQL_BOTH); } function FetchObject( $result ) { $this ->result = $result ; return @mysql_fetch_object( $this ->result); } function FreeResult( $result ) { $this ->result = $result ; return @mysql_free_result( $this ->result); } function DataSeek( $result ) { //复位记录集指针 $this ->result = $result ; return mysql_data_seek( $this ->result,0); } function InsertID() { //$this->con = $con; return @mysql_insert_id( $this ->con); } //开源代码phpfensi测试数据 function Close() { if ( $this ->con) { @mysql_close( $this ->con); } } }查看更多关于实用简单的mysql数据库连接类的详细内容...
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did29605