《PHP操作数据库mysql的类 完成增、删、改、查操作》

<?php

/**
 * 操作数据库mysql 的类，完成增删改查的操作
 *
 */
class ms_new_mysql {

    private $dbHost;
    private $dbUser;
    private $dbPassword;
    private $dbTable;
    private $dbConn;
    private $result;
    private $sql;
    private $pre;
    private $coding;
    private $pcon;
    private $queryNum;
    private static $daoImpl;

    public function __construct($dbHost, $dbUser, $dbPassword, $dbTable, $pre, $coding, $pcon) {
        $this->dbHost = $dbHost;
        $this->dbUser = $dbUser;
        $this->dbPassword = $dbPassword;
        $this->dbTable = $dbTable;
        $this->pre = $pre;
        $this->coding = $coding;
        $this->pcon = $pcon;
        $this->connect();
        $this->select_db($dbTable);
    }

    public function __clone() {
        return self::$daoImpl;
    }

    public static function getDaoImpl($linkConfig) {

        if (empty(self::$daoImpl)) {
            self::$daoImpl = new ms_new_mysql($linkConfig['db']['dbhost'], $linkConfig['db']['dbuser'], $linkConfig['db']['dbpw'], $linkConfig['db']['dbname'], $linkConfig['db']['tablepre'], $linkConfig['db']['dbcharset'], $linkConfig['db']['pconnect']);
        }
        return self::$daoImpl;
    }

    public function connect() {
        $func = $this->pcon == 1 ? "mysql_pconnect" : "mysql_connect";

        //$this->dbConn = @$func($this->dbHost, $this->dbUser, $this->dbPassword);
        $this->dbConn = mysql_connect($this->dbHost, $this->dbUser, $this->dbPassword, $this->pcon);
        if (!$this->dbConn) {
            $this->halt("不能链接数据库", $this->sql);
            return false;
        }
        if ($this->version() > '4.1') {
            $serverset = $this->coding ? "character_set_connection='$this->coding',character_set_results='$this->coding',character_set_client=binary" : '';
            $serverset .= $this->version() > '5.0.1' ? ((empty($serverset) ? '' : ',') . " sql_mode='' ") : '';
            $serverset && mysql_query("SET $serverset", $this->dbConn);
        }
        return $this->dbConn;
    }

    /**
     * 选择一个数据库
     *
     * @param string $dbTable
     * @return boolean
     */
    public function select_db($dbTable) {
        if (!@mysql_select_db($dbTable, $this->dbConn)) {
            $this->halt("没有" . $dbTable . "这个数据库");
            return false;
        } else {
            $this->dbTable = $dbTable;
            return true;
        }
    }

    /**
     * 查询语句，传过来一个sql，执行，如果语句正确，返回结果集资源
     *
     * @param string $sql
     * @param string $type
     * @return Resouce query
     */
    public function query($sql, $type = '') {

        if ($query = mysql_query($sql, $this->dbConn)) {
            $this->queryNum++;
            return $query;
        } else {
            $this->halt("Mysql 查询出错", $sql);
            return false;
        }
    }

    /**
     * 插入一组数据或一条数据
     *
     * @param string $tableName
     * @param boolean
     */
    public function insert($tableName, $info) {

        $this->checkFields($tableName, $info);
        $insert_sql = "INSERT INTO `$tableName`(`" . implode('`,`', array_keys($info)) . "`) VALUES('" . implode("','", $info) . "')";
        return $this->query("$insert_sql");
    }

    /**
     * 更细数据库中的数据
     *
     * @param string $tableName
     * @param array $info
     * @param string $where
     * @return boolean
     */
    public function update($tableName, $info, $where = '') {
        $this->checkFields($tableName, $info);
        if ($where) {
            $sql = '';

            foreach ($info as $k => $v) {
                $sql .= ", `$k`='$v'";
            }
            $sql = substr($sql, 1);

            $sql = "UPDATE `$tableName` SET $sql WHERE $where";
        } else {
            $sql = "REPLACE INTO `$tableName`(`" . implode('`,`', array_keys($info)) . "`) VALUES('" . implode("','", $info) . "')";
        }
        return $this->query($sql);
    }

    /**
     * 检查一个字段是否在这张表中存在
     *
     * @param string $tableName
     * @param array $array
     * @return message
     */
    public function checkFields($tableName, $array) {

        $fields = $this->getFields($tableName);

        foreach ($array as $key => $val) {
            if (!in_array($key, $fields)) {
                $this->halt("Mysql 错误", "找不到" . $key . "这个字段在" . $tableName . "里面");
                return false;
            }
        }
    }

    /**
     * 获取一张表中的所有字段
     *
     * @param string $tableName
     * @return array fileds
     */
    public function getFields($tableName) {
        $fields = array();
        $result = $this->query("SHOW COLUMNS FROM `$tableName`");
        while ($list = $this->fetchArray($result)) {
            $fields[] = $list['Field'];
        }
        $this->freeResult($result);
        return $fields;
    }

    /**
     * 释放当前数据库结果集的内存
     *
     * @param Resource $result
     * @return null
     */
    public function freeResult($result) {
        return @mysql_free_result($result);
    }

    /**
     * 使用while 可以迭代输出 一个结果集中的所有数据
     *
     * @param Resouce $query
     * @param result type $result_type
     * @return array
     */
    public function fetchArray($query, $result_type = MYSQL_ASSOC) {
        return mysql_fetch_array($query, $result_type);
    }

    /**
     * 返回一个结果集中的一条数据
     *
     * @param $sql $query
     * @param string $type
     * 
     * 
     */
    public function getOne($sql, $type = '', $expires = 3600) {
        $query = $this->query($sql, $type, $expires);
        $rs = $this->fetchArray($query);
        $this->freeResult($rs);
        return $rs;
    }

    /**
     * 获取插入的数据的返回的insetid
     *
     * @return insetid
     */
    public function insertId() {
        return mysql_insert_id($this->dbConn);
    }

    /**
     * 获取当前的结果集中存在多少条数据
     *
     * @param string $query
     * @return int nums
     */
    public function numRows($query) {
        return @mysql_numrows($query);
    }

    /**
     * 获取当前的结果集中，有多少个字段
     *
     * @param Resouce $query
     * @return int fields nums
     */
    public function numFields($query) {
        return @mysql_num_fields($query);
    }

    /**
     * 获取当前执行的sql总条数
     *
     * @return queryNum
     */
    public function getQueryNum() {
        return $this->queryNum;
    }

    /**
     * 获取当前文件中的函数,传入一个当前类存在函数，单例调用
     *
     * @param unknown_type $funcname
     * @param unknown_type $params
     * @return unknown
     */
    public function getFunc($funcname, $params = '') {
        if (empty($params)) {
            return $this->$funcname();
        } else {
            return $this->$funcname($this->getFuncParams($params));
        }
    }

    /**
     * 如果是一个数组，那么拼接起来，处理返回一个参数集合
     *
     * @param array,string $params
     * @return string a,d,3
     */
    public function getFuncParams($params) {
        $returnStr = "";
        if (is_array($params)) {
            foreach ($params as $key => $val) {
                $returnStr .= $val . ",";
            }
            return rtrim($returnStr, ",");
        } else {
            return $params;
        }
    }

    /**
     * 获取当前数据库的版本信息
     *
     * @return version
     */
    public function version() {
        return mysql_get_server_info($this->dbConn);
    }

    /**
     * 获取当前mysql数据的报错号
     *
     * @return errorno
     */
    public function errno() {
        return intval(@mysql_errno($this->dbConn));
    }

    /**
     * 获取当前数据库的 提示信息
     *
     * @return unknown
     */
    public function error() {
        return @mysql_error($this->dbConn);
    }

    /**
     * 操作数据库出错，提示信息
     *
     * @param unknown_type $message
     * @param unknown_type $sql
     */
    function halt($message = '', $sql = '') {
        $this->errormsg = "<b>MySQL Query : </b>$sql <br /><b> MySQL Error : </b>" . $this->error() . " <br /> <b>MySQL Errno : </b>" . $this->errno() . " <br /><b> Message : </b> $message";
        exit($this->errormsg);
    }

    function showTable() {
        $tables = array();
        $result = $this->query("SHOW TABLES");
        while ($list = $this->fetchArray($result)) {
            $tables[] = $list['Tables_in_' . $this->dbTable];
        }
        $this->freeResult($result);
        return $tables;
    }

}

$dbObj = new ms_new_mysql("127.0.0.1", "root", "", "", "", "utf-8", "0");