<?phpdefine(‘MY_DBHOST‘, ‘localhost‘);define(‘MY_PORT‘, ‘3306‘);define(‘MY_DBUSER‘, ‘root‘);define(‘MY_DBPW‘, ‘123456‘);define(‘MY_DBNAME‘, ‘test‘);define(‘MY_DBCHARSET‘, ‘utf8‘);define(‘MY_DBTABLEPRE‘, ‘pre_‘);function M($table,$database=‘‘,$pre=‘‘){    if(empty($database)){        $db=new MYSQL(MY_DBHOST,MY_PORT,MY_DBUSER,MY_DBPW,MY_DBNAME,MY_DBTABLEPRE,MY_DBCHARSET);    }    else{        $db=new MYSQL(MY_DBHOST,MY_PORT,MY_DBUSER,MY_DBPW,$database,$pre,MY_DBCHARSET);    }    return $db->table($table);}/** * MySQL 数据库操作工具类, 方便数据库操作. */class MYSQL{    private     $conn;    private  $pre;    private  $where;    private  $limit;    private  $order;    private  $field;    public function __construct($host,$port,$user,$pw,$db,$pre,$charset){        if(!$this->conn){            $server = $host.‘:‘.$port;            $this->conn = mysql_connect($server, $user, $pw, true) or die(‘connect db error‘);            $this->pre=$pre;            mysql_select_db($db,$this->conn) or die(‘select db error‘);            if($charset){                mysql_query("set names " . $charset, $this->conn);            }                    }    }    public function __destruct(){        if($this->conn){            mysql_close($this->conn);        }    }    /*        快捷找到一行记录    */    public function find(){        $result=$this->query($this->sql());        if(!$result){            return false;        }        else{            return $result[0];        }    }    /*        选择所有的资源    */    public function select(){        return $this->query($this->sql());    }    /*        获取某行记录的某个字段    */    public function getField($field){        $this->field=$field;        $result=$this->query($this->sql());        if(!$result){            return false;        }        return $result[0][$field];    }    /*        设置某行记录的某个字段    */    public function setField($field,$value){        $sql=‘update ‘.$this->table.‘ set `‘.$field.‘`=‘.‘\‘‘.$value.‘\‘ ‘.$this->where;        $this->execute($sql);    }    /*        统计    */    public function count(){        $sql=‘select count(*) as ask_count from ‘.$this->table.‘ ‘.$this->where.‘ limit 0,1‘;        $result=$this->query($sql);        return $result[0][‘ask_count‘];    }    public function sum($field){        $sql=‘select sum(‘.$field.‘) as ask_sum from ‘.$this->table.‘ ‘.$this->where;        $result=$this->query($sql);        return $result[0][‘ask_sum‘];    }    /*    添加记录    */    public function add($data){        $fields=array();        $values=array();        foreach($data as $k=>$v){            $fields[]=‘`‘.$k.‘`‘;            $values[]=‘\‘‘.$v.‘\‘‘;        }        $sql="insert ".$this->table.‘ (‘.implode(‘,‘,$fields).‘) values (‘.implode(‘,‘,$values).‘)‘;        $this->execute($sql);        return mysql_insert_id($this->conn);    }    /*    更新添加记录    */    public function readd($data){        $fields=array();        $values=array();        foreach($data as $k=>$v){            $fields[]=‘`‘.$k.‘`‘;            $values[]=‘\‘‘.$v.‘\‘‘;        }        $sql="replace into ".$this->table.‘ (‘.implode(‘,‘,$fields).‘) values (‘.implode(‘,‘,$values).‘)‘;        $this->execute($sql);        return mysql_insert_id($this->conn);    }    /*    更新记录    */    public function save($data){        $new=array();        foreach($data as $k=>$v){            $new[]=‘`‘.$k.‘`=\‘‘.$v.‘\‘‘;        }        $sql=‘update ‘.$this->table.‘ set ‘.implode(‘,‘,$new).‘ ‘.$this->where;        $this->execute($sql);    }    /*    删除记录    */    public function delete(){        $sql=‘delete from ‘.$this->table.‘ ‘.$this->where;        $this->execute($sql);    }    /*        执行原生的SQL    */    public function query($sql){        $result=mysql_query($sql,$this->conn);        if($result === false){            return false;        }        if(mysql_num_rows($result)==0){            return false;        }                $data=array();        while($row=mysql_fetch_assoc($result)){            $data[]=$row;        }        $this->resetsql();        return $data;    }    /*        生成SQL并执行返回结果资源    */    public function execute($sql){        mysql_query($sql,$this->conn);        $this->resetsql();    }    /*        设置where    */    public function where($map){        $this->where=‘where ‘.$map;        return $this;    }    public function error(){        return mysql_error($this->conn);    }    /*        设置order    */    public function order($order){        $this->order=‘order by ‘.$order;        return $this;    }    /*        设置limit    */    public function limit($limit){        if(is_numeric($limit)){            $this->limit=‘limit 0,‘.$limit;            }        else{            $this->limit=‘limit ‘.$limit;            }        return $this;    }    /*        设置field    */    public function field($field){        $this->field=$field;        return $this;    }    /*        设置table    */    public function table($table){        $this->table=$this->pre.$table;        return $this;    }    /*        生成查询sql    */    public function sql(){        $sql=‘select‘;        if($this->field){            $sql.=‘ ‘.$this->field.‘ from‘;        }        else{            $sql.=‘ * from‘;        }        $sql.=‘ ‘.$this->table;        if($this->where){            $sql.=‘ ‘.$this->where;        }        if($this->order){            $sql.=‘ ‘.$this->order;        }        if($this->limit){            $sql.=‘ ‘.$this->limit;        }        //echo $sql.‘<br>‘;        return $sql;    }    /*    查询完毕以后清空    */    Public function resetsql(){        $this->field=‘‘;        $this->order=‘‘;        $this->limit=‘‘;        $this->where=‘‘;    }    /*        解析MYSQL的返回结果    */    private function parseResult($result,$find=false,$reset=true){        if(mysql_num_rows($result)==0){            return false;        }                if($find){            return mysql_fetch_assoc($result);         }        $data=array();        while($row=mysql_fetch_assoc($result)){            $data[]=$row;        }        if($reset){            $this->resetsql();        }        return $data;    }}?>