class MysqlDB (PHP)

发布一个简单的 MysqlDB 类。封装了常用的3个方法。select(), query(), insert()。其中对于 insert() 方法的返回结果是个数组。格式如：array('return'=>false,'id'=>NULL)

<?php
/**
 * class MysqlDB
 */

class MysqlDB
{
    private $host = NULL;
    private $user = NULL;
    private $password = NULL;
    private $dbName = NULL;
    private $charset = NULL;

    public function MysqlDB($host, $user, $password, $dbName, $charset = 'UTF8')
    {
        $this->host        = $host;
        $this->user        = $user;
        $this->password    = $password;
        $this->dbName    = $dbName;
        $this->charset    = $charset;
    }

    private function connect()
    {
        $connectId = mysql_connect($this->host,$this->user,$this->password);
        if (!$connectId)
        {
            if(DEBUG) {
                die('Could not connect: '.mysql_error());
            }
            return NULL;
        }
        return $connectId;
    }

    public function select($sql)
    {
        if(strlen($sql) == 0) {
            return NULL;
        }

        $connectId = $this->connect();
        if($connectId == NULL) {
            return NULL;
        }

        mysql_query("SET NAMES $this->charset", $connectId);

        mysql_select_db($this->dbName, $connectId);

        $queryResult = mysql_query($sql, $connectId);
        if(!$queryResult) {
            return NULL;
        }

        $result = array();
        while($row = mysql_fetch_array($queryResult))
        {
            $result[] = $row;
        }

        mysql_close($connectId);

        return $result;
    }

    public function insert($sql)
    {
        $result = array('return'=>false, 'id'=>NULL);

        if(strlen($sql) == 0) {
            return $result;
        }

        $connectId = $this->connect();
        if($connectId == NULL) {
            return $result;
        }

        mysql_query("SET NAMES $this->charset", $connectId);

        mysql_select_db($this->dbName, $connectId);

        $queryResult = mysql_query($sql, $connectId);
        if(!$queryResult) {
            return $result;
        } else {
            $result['return'] = true;
        }

        $lastInsertId = mysql_insert_id();
        mysql_close($connectId);
        if($lastInsertId == 0) {
            return $result;
        } else {
            $result['id'] = $lastInsertId;
        }

        return $result;
    }

    public function query($sql)
    {
        if(strlen($sql) == 0) {
            return false;
        }

        $connectId = $this->connect();
        if($connectId == NULL) {
            return false;
        }

        mysql_query("SET NAMES $this->charset", $connectId);

        mysql_select_db($this->dbName, $connectId);

        $result = mysql_query($sql, $connectId);

        mysql_close($connectId);

        if(!result) {
            return false;
        } else {
            return true;
        }
    }
}

?>

 点击 这里下载