/*
===========================================================   
    class.mysql.php    Zhu Weiwei
    Copyright © 2006-2008
    http://www.cncmm.com China. All Rights Reserved.
===========================================================
*/
class MySQL{
    private $m_classname = "MySQL";
    protected static $m_conn = null;
    protected $m_rs;
    protected $m_errlevel = "report";


    function __construct($server='',$username='',$password='',$database=''){
        if(self::$m_conn === null){       
            self::$m_conn = @mysql_connect($server,$username,$password);

            if(!self::$m_conn){
                die("mysql_connect(): Failed");
            }
            if($database != ""){
                if( !@mysql_select_db($database,self::$m_conn)){
                    die("mysql_select_db($database,m_conn) Failed.");
                }
            }
        }
        $this->executeQuery('SET NAMES utf8');
    }
 

    function connect(){
        $this->executeQuery('SET NAMES utf8');
        $this->executeQuery('SET CHARACTER SET utf8');
        $this->executeQuery('SET COLLATION_CONNECTION=utf8_general_ci');
        return true;
    }


    function close(){
        return @mysql_close( self::$m_conn );
    }


    function selectDatabase($database=''){
        if($database!=""){
            return @mysql_select_db($database);
        }
    }


    function executeQuery($sql=''){
        if(self::$m_conn == false && self::$m_conn){
            $this->halt("Execute SQL Failed: Hava not valid database connect.");
            return false;
        }

        $this->m_rs = mysql_query($sql,self::$m_conn);
        if(!$this->m_rs){
            $this->halt("Execute SQL: mysql_query($sql,m_conn) failed.");
            return false;
        }
        return $this->m_rs;
    }
 

    function executeQueryFormat($query='') {
        if (func_num_args()>1){
            $args=func_get_args();
            $query=call_user_func_array("sprintf",$args);
        }
        return $this->executeQuery($query);
    }

 
    function getTotalRowNum($result=''){
        if($result != ""){
            $this->m_rs = $result;
        }
        $row = @mysql_num_rows($this->m_rs);
        if($row >= 0){
            return $row;
        }else{
            $this->halt("Get a row of result Failed: Result $result is invalid.");
            return false;
        }
    }
 
 
    function getLastInsertID(){
        return @mysql_insert_id($this->m_rs);
    }
 
 
    function getFieldValue($result='',$row=0,$field=0){
        if($result != ""){
            $this->m_rs = $result;
        }
        $fieldvalue = @mysql_result($this->m_rs,$row,$field);
        if($fieldvalue != ""){
            return $fieldvalue;
        }else{
            $this->halt("Get field: mysql_result($this->m_rs,$row,$field) failed.");
            return false;
        }
    }

    function getFieldList($database,$table) {
        $fs = mysql_list_fields($database, $table, self::$m_conn);
        $columns = mysql_num_fields($fs);

        $filed = Array();
        for ($i = 0; $i < $columns; $i++) {
            $filed[] = mysql_field_name($fs, $i);
        }
        return $filed;
    }

    function getObjectRecord($result='') {
        if($result!=""){
            $this->m_rs=$result;
        }
        return @mysql_fetch_object($this->m_rs);
    }

    function getArrayRecord($result='') {
        if($result!=""){
            $this->m_rs=$result;
        }
        return @mysql_fetch_array($this->m_rs, MYSQL_ASSOC);
    }
 

    function freeResult($result=''){
        if($result != ""){
            $this->m_rs = $result;
        }
        return @mysql_free_result($this->m_rs);
    }
 
 
    function setErrorLevel($state='report'){
        if(!($state == "ignore" || $state == "report" || $state == "halt")){
            $this->halt("Set the m_errlevel Fail: There is no state value $state");
            return false;     
        }
        $this->m_errlevel = $state;
        return true;
    }
 

    function toString(){
        return $this->m_classname;
    }


    function escapeString($str){
        return @addslashes($str);
    }
   

    function getErrorText(){
        return @mysql_error(self::$m_conn);
    }


    function getErrorNo(){
        return @mysql_errno(self::$m_conn);
    }
   

    function halt($msg=''){
        if ($this->m_errlevel == "ignore"){
             return;
        }
        //report
        printf("<hr />\n");
        printf("<b>Database error:</b> %s<br>\n", $msg);
        printf("<b>MySQL Error</b>: %s (%s)<br>\n",mysql_errno(self::$m_conn),mysql_error(self::$m_conn));
        printf("<hr />\n");
        if ($this->m_errlevel == "halt"){
            die("<b>Session halted</b>");
        }
    }
};