c_db_mysql.php

转载中国源码下载站 1) 基于PHP语言开发,MYSQL数据库驱动的多用户留言本 2) 采用PHP官方提供的编译模板引擎smarty 3) 代码、页面分离

<?php
class c_db_mysql {
    var $link_id = 0;
    var $query_id = 0;
    var $record = array();
    var $errdesc = "";
    var $errno = 0;
    var $reporterror = 1;
    var $appname = "default";

    function c_db_mysql()
    {
        $this->connect(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);
    } 

    function connect($server, $user, $password, $database)
    {
        if (0 == $this->link_id) {
            if ($password == "") {
                $this->link_id = @mysql_connect($server, $user);
            } else {
                $this->link_id = @mysql_connect($server, $user, $password);
            } 

            if (!$this->link_id) $this->halt("连接数据库失败");

            if ($database != "") {
                if (!mysql_select_db($database, $this->link_id)) $this->halt("不能使用该数据库 " . $database);
            } 
        } 
    } 

    function geterrdesc()
    {
        $this->error = mysql_error();
        return $this->error;
    } 

    function geterrno()
    {
        $this->errno = mysql_errno();
        return $this->errno;
    } 

    function query($query_string)
    {
        $array = $this->query_id = mysql_query($query_string, $this->link_id);
        if (!$this->query_id) $this->halt("无效的SQL语句: " . $query_string);
        return $this->query_id;
    } 

    function fetch_array($query_id = -1)
    {
        if ($query_id != -1) $this->query_id = $query_id;
        $this->record = @mysql_fetch_array($this->query_id);
        return $this->record;
    } 

    function free_result($query_id = -1)
    {
        if ($query_id != -1) $this->query_id = $query_id;
        return @mysql_free_result($this->query_id);
    } 

    function num_rows($query_id = -1)
    {
        if ($query_id != -1) $this->query_id = $query_id;
        return @mysql_num_rows($this->query_id);
    } 

    function insert_id()
    {
        return @mysql_insert_id($this->link_id);
    } 

    function halt($msg)
    {
        $this->errdesc = mysql_error();
        $this->errno = mysql_errno();

        $message = "<font size=2>数据库错误在" . $this->appname . ":" . $msg . "<br>";
        $message .= "MySQL错误:" . $this->errdesc . "<br>";
        $message .= "MySQL错误号:" . $this->errno . "<br>";
        $message .= "日期: " . date("l dS of F Y h:i:s A") . "<br>";
        $message .= "脚本: " . getenv("REQUEST_URI") . "<br>";
        $message .= "来自: " . getenv("HTTP_REFERER") . "<br></font>";
    } 
} 

?>