<?php

 class DB{

     var $host;

     var $user;

     var $pwd;

     var $dbname;

     var $conn;

     function DB($host,$user,$pwd,$dbname){

         $this->host = $host;

         $this->user = $user;

         $this->pwd = $pwd;

         $this->dbname = $dbname;

     }

     function GetConn(){

         $this->conn = mysql_connect($this->host,$this->user,$this->pwd,$this->dbname) or die("数据库服务器连接失败".mysql_errno());

         mysql_select_db($this->dbname,$this->conn) or die("数据库选择失败".mysql_errno());

         mysql_query("SET NAMES 'UTF8'");

         mysql_query("SET CHARACTER SET UTF8");

         mysql_query("SET CHARACTER_SET_RESULTS=UTF8'");

         return $this->conn;

     }

     function CloseConnld(){

         mysql_close($this->conn);

     }

 }

 ?>

<?php

class AdminDB{

    function ExecSQL($sql,$conn){

        $sqltype = strtolower(substr(trim($sql), 0, 6));

        $rs = mysql_query($sql);

        if($sqltype == "select"){

            $array = array();

            while($row = mysql_fetch_array($rs)){

                array_push($array,$row);

            }

            if($rs == false)

                return false;

            else

                return $array;

        }else if($sqltype == "update" || $sqltype == "delete" || $sqltype == "insert"){

            if($rs)

                return true;

            else

                return false;

        }

    }

}

?>