PHP(4)封装的mysql操作模块

来源：互联网发布：linux拷贝隐藏文件编辑：程序博客网时间：2024/05/17 05:15
<?php     class DB{        //定义属性        public $db;        //定义构造函数        function __construct($db_config){            $this->db = new mysqli($db_config['host'], $db_config['user'], $db_config['passwd'], $db_config['db']);            $this->db->query('SET NAMES utf8');        }        //添加数据        function insertData($table, $formdata){            $field  = array();            $valuea = array();            foreach ($formdata as $key => $value) {                $field[] = $key;                if(is_string($value)){                    $valuea[$key] = '"' . $value . '"';                }else{                    $valuea[$key] = $value;                }            }            $fieldstr   = implode(', ', $field);            $value      = implode(', ', $valuea);            $sql        = 'INSERT INTO '.$table.'('.$fieldstr.') VALUES('.$value.')';            $r          = $this->db->query($sql);            return $r;        }        //更新数据        function updateData($table, $formdata, $where){            $data = array();            foreach ($formdata as $key => $value) {                if(is_string($value)){                    $value = '"' . $value . '"';                }                $data[] = $key . '=' . $value;            }            $str = implode(', ', $data);            $sql = 'UPDATE ' . $table . ' SET ' . $str . ' WHERE ' . $where;            echo $sql;            $r   = $this->db->query($sql);            return $r;        }        //删除数据        function delData($table, $where){            $sql = 'DELETE FROM '.$table.' WHERE ' . $where;            $r   = $this->db->query($sql);            return $r;        }        //查询数据        function selectData($table, $fields='*', $where='', $offset = 0, $limit = 0){            $sql        = 'SELECT '.$fields.' FROM '.$table.($where ? (' WHERE ' . $where):'');            //查询指定单位内的记录            if($limit){                $sql        .= ' LIMIT '.$offset.', ' . $limit;            }            // echo $sql;            $result     = $this->db->query($sql);            $data       = array();            while($row = $result->fetch_array(MYSQLI_ASSOC)){                $data[] = $row;            }            return $data;        }        //求符合条件的记录数        function getCount($table, $where = ''){            $sql = 'SELECT count(id) as totalnum FROM ' . $table.($where ? (' WHERE ' . $where):'');            $result     = $this->db->query($sql);            $row = $result->fetch_array(MYSQLI_ASSOC);            // array('totalnum'=>199996);            return $row['totalnum'];        }        //析构函数：        function __destruct(){            $this->db->close();        }    }
阅读全文
0 0