class_db.php

采用模块化设计,自由组合文章,软件,论坛等模块,安装方便快捷 模板支持Dreamweaver可视化编辑,创建风格更为容易,专业

<?php

if (!defined('ROOT'))
    exit('Access Denied');
class db
{
    public $version = '';
    public $querynum = 0;
    public $link;
    private static $_instance = null;
    private function __construct()
    {
        include ('./config/database.php');
        $this->connect($_db['dbhost'], $_db['dbuser'], $_db['dbpw'], $_db['dbname']);
    }
    public static function getinstance()
    {
        if (!self::$_instance)
        {
            self::$_instance = new self;
        }
        return self::$_instance;
    }
    private function connect($dbhost, $dbuser, $dbpw, $dbname = '', $pconnect = 0, $halt = true,
        $dbcharset2 = '')
    {
        $func = empty($pconnect) ? 'mysql_connect' : 'mysql_pconnect';
        if (!$this->link = @$func($dbhost, $dbuser, $dbpw, 1))
        {
            $halt && $this->halt('Can not connect to MySQL server');
        } else
        {
            if ($this->version() > '4.1')
            {
                $serverset = 'character_set_connection=utf8, character_set_results=utf8, character_set_client=binary';
                $serverset .= $this->version() > '5.0.1' ? ((empty($serverset) ? '' : ',') .
                    'sql_mode=\'\'') : '';
                mysql_query("SET $serverset", $this->link);
            }
            $dbname && @mysql_select_db($dbname, $this->link);
        }
    }
    public function fetch_array($query, $result_type = MYSQL_ASSOC)
    {
        return mysql_fetch_array($query, $result_type);
    }
    public function fetch_first($sql)
    {
        return $this->fetch_array($this->query($sql));
    }
    public function result_cache($sql)
    {
        $records = false;
        $i = 0;
        $result = $this->query($sql);
        $f = strstr(mysql_field_flags($result, 0), 'primary_key');
        $_key = $f == false ? false : mysql_field_name($result, 0);
        while ($record = mysql_fetch_array($result, MYSQL_ASSOC))
        {
            if ($_key !== false)
            {
                $_t = $record[$_key];
                array_shift($record);
                $records[$_t] = $record;
            } else
                $records[$i++] = $record;
        }
        return $records;
    }
    public function query($sql)
    {
        if (!($query = @mysql_query($sql, $this->link)) && DEBUG)
        {
            $this->halt(mysql_error(), $sql);
        }
        $this->querynum++;
        return $query;
    }
    public function select_db($dbname)
    {
        return mysql_select_db($dbname, $this->link);
    }
    public function result_first($sql)
    {
        return $this->result($this->query($sql), 0);
    }
    public function affected_rows()
    {
        return mysql_affected_rows($this->link);
    }
    public function error()
    {
        return (($this->link) ? mysql_error($this->link) : mysql_error());
    }
    public function errno()
    {
        return intval(($this->link) ? mysql_errno($this->link) : mysql_errno());
    }
    public function result($query, $row = 0)
    {
        $query = @mysql_result($query, $row);
        return $query;
    }
    public function num_rows($query)
    {
        return mysql_num_rows($query);
    }
    public function data_seek($query, $offset)
    {
        return mysql_data_seek($query, $offset);
    }
    public function num_fields($query)
    {
        return mysql_num_fields($query);
    }
    public function free_result($query)
    {
        return mysql_free_result($query);
    }
    public function insert_id()
    {
        return ($id = mysql_insert_id($this->link)) >= 0 ? $id : $this->result($this->
            query("SELECT last_insert_id()"), 0);
    }
    public function fetch_row($query)
    {
        $query = mysql_fetch_row($query);
        return $query;
    }
    public function fetch_fields($query)
    {
        return mysql_fetch_field($query);
    }
    public function version()
    {
        if (empty($this->version))
        {
            $this->version = mysql_get_server_info($this->link);
        }
        return $this->version;
    }
    public function close()
    {
        return mysql_close($this->link);
    }
    public function halt($message = '', $sql = '')
    {
        echo '<b>Database Error.</b><h2>' . htmlspecialchars($sql) . '</h2>
          <p>' . htmlspecialchars($message) . '</p>';
        exit;
    }
}

?>