thinkphp无限分类模块实现

数据表结构如下：

控制器核心代码：

<?phpnamespace app\index\controller;u think\controller;class goods extends controller{    public function product_category()    {       四核和双核的区别 return $this->fetch();    }    public function product_category_add()    {        $m = model('goods_type');        // 根据paths进行排序        // \对,进行转义，因为本身是作为分隔符使用        $data = $m->field("*,concat(path,'\,',id) as paths")->order('paths')->lect();        foreach($data as $k=>$v){            //根据level的值，决定需要循环几次，生成分割线            $v['name'] = str_repeat("|------", $v['level']).$v['name'];        }        $this->assign('data', $data);        return $this->fetch();    }    //添加分类    public function goods_type_add(){        if($_post['name'] === ''){            echo '<script>alert("添加失败，分类名不能为空");parent.location.href="product_category";</script>';        }        //var_dump($_post);        $data['name'] = $_post['name'];        $data['pid'] = $_post['pid'];        $m = model('goods_type');        if($data['pid'] === "0"){            //如果是一级分类            $data['level'] = 1;            //新增分类的id            $info = $m->where('1=1')->order('id desc')->find();            $newid = $info['id']+1;            $data['path'] = '0,'.$newid;        }el{            $pinfo = $婴幼儿摄影m->field('path,level')->where('id',$data['pid'])->lect();            //查找父分类的path和level春联大全七字            $data['level'] = $pinfo[0]['level']+1;            //新增分类的id            $info = $m->where('1=1')->order('id desc')->find();            $newid = $info['id']+1;            $data['path'] = $pinfo[0]['path'].','.$newid;        }        $res = $m->data($data)->save();        if($res){            echo '<script>alert("添加成功");parent.location.href="product_category";</script>';        }el{            echo '<script>alert("添加失败");parent.location.href="product_category";</script>';        }    }    //获取分类数据    public function product_category_ajax(){        $m = model('goods_type');        $data香港节假日 = $m->field('id,pid,name')->lect();        echo json_encode($data);    }    //删除分类数据    public function product_category_del(){        $id = $_get['id'];        $m = model('goods_type');        $re安全教育日主题班会s = $m->where('pid',$id)->find();        if($res){            $str = '该分类下还有子分类，不允许直接删除';            echo json_encode($str);        }el{            $result = $m->where('id',$id)->delete();            if($result){                echo 1;            }el{                $str = '删除失败';                echo json_encode($str);            }        }    }}

实现效果