Mysql封装类

来源：互联网发布：js给div添加class属性编辑：程序博客网时间：2024/06/05 23:01
<?phpheader("Content-Type:text/html;charset=utf-8");//封装数据库类//增 删 改 查class DB{    public $server; //数据库服务器名称    public $username; //用户名    public $password; //密码    public $dbname; //默认数据库名称    public $result; //select查询返回的资源    public $rowCount; //select查询返回的行数    static $obj = null;    private function __construct($server,$username,$password,$dbname){        $this->server = $server;        $this->username = $username;        $this->password = $password;        $this->dbname = $dbname;        //连接数据库        $this->connect();        //选择默认数据库        $this->selectDB();    }    //静态化成员方法，实例化类 获取类对象    static function getObj($server,$username,$password,$dbname){        if(is_null(self::$obj)){            self::$obj = new DB($server,$username,$password,$dbname);        }        return self::$obj;    }    //连接数据库    function connect(){        mysql_connect($this->server,                       $this->username,                      $this->password);    }    //选择默认数据库    function selectDB(){        mysql_select_db($this->dbname);    }    //数据库类增    function insert($tbname,$data){        //拆分$data数组        /*$data = array('uname'=>'tom02','pwd'=>'666');         * $fields = uname,pwd         *          */        //获取$data的键        $fields_array = array_keys($data);        //将数组转换为字符串        $fields = implode(",",$fields_array);        //$value = 'tom02','666'        $value = implode("','",$data);        //echo $value;        //user 添加记录        $query = "insert into $tbname                   ($fields)                  value                  ('".$value."')";        echo $query;        $result = mysql_query($query);        return $result;//boolean    }    //删    function delete($tbname,$where=""){        //$where = id=41        $query = "delete from $tbname";        if($where!=""){            $query.=" where $where";        }               $result = mysql_query($query);        return $result;    }    //改 update    function update($tbname,$sets,$where=""){        //$sets = array('title'=>'判17年',        //'content'=>'安徽原副省长倪发科判17年');        //update cms_article set         //title='判17年',content='安徽原副省长倪发科判17年'        //where         $data = "";        foreach($sets as $key=>$value){            //判断$data是否为空，若为空，则表示是第一次连接            //key = value，不需要 ,            if($data!=""){                $data.=",";            }            $data.= $key."='".$value."'";//title='判17年'                                 //content='安徽原副省长倪发科判17年'        }               $query = "update $tbname set $data ";         if($where!=""){            $query.=" where $where";        }        //echo $query;exit;        $result = mysql_query($query);        return $result;    }    //查    function select($tbname,$fields,$where="",$limit="",$join=""){        $query = "select $fields from $tbname";        if($join!=""){            $query.=" ".$join;        }        if($where!=""){            $query.=" where $where";        }        if($limit!=""){            $query.=" limit $limit";        }        echo $query;        $this->result = mysql_query($query);        //获取查询的结果        return $this->getResult();         }    //从select查询的资源中获取查询的结果    function getResult(){        while($row=mysql_fetch_assoc($this->result)){            $res[] = $row;        }        //获取查询结果集的行数        $this->rowCount = mysql_num_rows($this->result);                return $res;    }}
0 0