include/Db_mysql.php 2008-03-23 17:45

字号:    

<?php
/*********************/
/*                   */
/*  Version : 5.1.0  */
/*  Author  : RM     */
/*  Comment : 071223 */
/*                   */
/*********************/

class db_mysql
{

    var $querycount = 0;//查询数
    var $pagetime;//页面时间
//连接数据库
    function connect( $Host, $User, $Password, $Pconnect = 0 )
    {
        if ( $Pconnect )
        {
            if ( !mysql_pconnect( $Host, $User, $Password ) )
            {
                db_mysql::halt( "MYSQL 数据库无法连接,如果确认服务器没问题请检查程序设置" );
            }
        }
        else if ( !mysql_connect( $Host, $User, $Password ) )
        {
            db_mysql::halt( "MYSQL 数据库无法连接,如果确认服务器没问题请检查程序设置" );
        }
    }
//选择数据库
    function select_db( $Database )
    {
        return mysql_select_db( $Database );
    }
//查询数据库
    function query( $sql )
    {
        $query = mysql_query( $sql );
        if ( $query )
        {
            ++$this->querycount;
        }
        else
        {
            db_mysql::halt( "MYSQL QUERY 错误", $sql );
        }
        return $query;
    }

    function fetch_array( $query, $type = MYSQL_ASSOC )
    {
        $nu = mysql_fetch_array( $query, $type );
        return $nu;
    }

    function fetch_object( $query, $type = MYSQL_ASSOC )
    {
        $nu = mysql_fetch_object( $query, $type );
        return $nu;
    }

    function fetch_row( $query )
    {
        $nu = mysql_fetch_row( $query );
        return $nu;
    }

    function result( $query, $row )
    {
        $nu = mysql_result( $query, $row );
        return $nu;
    }

    function num_rows( $query )
    {
        $num = mysql_num_rows( $query );
        return $num;
    }

    function affected_rows( )
    {
        return mysql_affected_rows( );
    }

    function num_fields( $query )
    {
        return mysql_num_fields( $query );
    }

    function free_result( $query )
    {
        return mysql_free_result( $query );
    }

    function insert_id( )
    {
        $id = mysql_insert_id( );
        return $id;
    }

    function error( )
    {
        return mysql_error( );
    }

    function errno( )
    {
        return mysql_errno( );
    }

    function close( )
    {
        return mysql_close( );
    }
//显示错误的详细信息并停止
    function halt( $msg, $sql = "" )
    {
        $date = date( "Y-m-d H:i:s", time( ) );
        $errormsg = "时间:".$date."<br>";
        $errormsg .= "提示:".$msg."<br>";
        $errormsg .= "前当地址:".$_SERVER['REQUEST_URI']."<br>";
        if ( $sql )
        {
            $errormsg .= "SQL 语句: ".htmlspecialchars( $sql )."<br>";
        }
        $errormsg .= "错误:".db_mysql::error( )."<br>";
        $errormsg .= "错误号:".db_mysql::errno( )."<br>";
        echo $errormsg;
        exit( );
    }
//现在时间
    function nowtime( )
    {
        $array = explode( " ", microtime( ) );
        $time = $array[0] + $array[1];
        return $time;
    }
//查询总数
    function querycount( )
    {
        return $this->querycount;
    }

}

?>

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
网易公司版权所有 ©1997-2009