php数据库操作类

jopen 7年前

    <?php            /*==================================================================*/            /*      文件名:BaseLogic.class.php                          */            /*      概要: 数据处理公共类.                                */                    class BaseLogic extends MyDB {                protected $tabName;     //表的名称                protected $fieldList;   //字段集合                protected $messList;                        //==========================================                // 函数: add($postList)                // 功能: 添加                // 参数: $postList 提交的变量列表                // 返回: 刚插入的自增ID                //==========================================                function add($postList) {                    $fieldList='';                    $value='';                    foreach ($postList as $k=>$v) {                        if(in_array($k, $this->fieldList)){                            $fieldList.=$k.",";                            if (!get_magic_quotes_gpc())                                $value .= "'".addslashes($v)."',";                            else                                $value .= "'".$v."',";                        }                    }                            $fieldList=rtrim($fieldList, ",");                    $value=rtrim($value, ",");                            $sql = "INSERT INTO {$this->tabName} (".$fieldList.") VALUES(".$value.")";                    echo $sql;                    $result=$this->mysqli->query($sql);                    if($result && $this->mysqli->affected_rows >0 )                         return $this->mysqli->insert_id;                    else                        return false;                }                                //==========================================                // 函数: mod($postList)                // 功能: 修改表数据                // 参数: $postList 提交的变量列表                //==========================================                function mod($postList) {                    $id=$postList["id"];                    unset($postList["id"]);                    $value='';                    foreach ($postList as $k=>$v) {                        if(in_array($k, $this->fieldList)){                            if (!get_magic_quotes_gpc())                                $value .= $k." = '".addslashes($v)."',";                            else                                $value .= $k." = '".$v."',";                        }                    }                    $value=rtrim($value, ",");                    $sql = "UPDATE {$this->tabName} SET {$value} WHERE id={$id}";                    return $this->mysqli->query($sql);                    }                            //==========================================                // 函数: del($id)                // 功能: 删除                // 参数: $id 编号或ID列表数组                // 返回: 0 失败 成功为删除的记录数                //==========================================                function del($id) {                    if(is_array($id))                        $tmp = "IN (" . join(",", $id) . ")";                    else                         $tmp = "= $id";                                        $sql = "DELETE FROM {$this->tabName} WHERE id " . $tmp ;                    return $this->mysqli->query($sql);                                    }                                        function get($id) {                    $sql = "SELECT * FROM {$this->tabName} WHERE id ={$id}";                                        $result=$this->mysqli->query($sql);                            if($result && $result->num_rows ==1){                        return $result->fetch_assoc();                    }else{                        return false;                    }                            }                function getMessList(){                    $message="";                    if(!empty($this->messList)){                        foreach($this->messList as $value){                            $message.=$value."<br>";                        }                    }                    return $message;                    }            }        ?>