# 无限级分类
数据表 字段 id pid title
```
<pre class="calibre16">```
<span class="token6">/**
* 获得分类树
* @param int $pid 父id
* @param array $result返回树结构
* @param int $spac
* @return array
*/</span>
require_once <span class="token4">"pdo.php"</span><span class="token2">;</span>
<span class="token5">function</span> <span class="token1">gettree</span><span class="token2">(</span>$pid<span class="token">=</span><span class="token3">0</span><span class="token2">,</span><span class="token">&</span>$result<span class="token">=</span><span class="token1">array</span><span class="token2">(</span><span class="token2">)</span><span class="token2">,</span>$spac<span class="token">=</span><span class="token3">0</span><span class="token2">)</span><span class="token2">{</span>
$spac <span class="token">=</span> $spac<span class="token">+</span><span class="token3">2</span><span class="token2">;</span>
$row <span class="token">=</span> <span class="token1">pdo_getall</span><span class="token2">(</span><span class="token4">'item'</span><span class="token2">,</span><span class="token1">array</span><span class="token2">(</span><span class="token4">'pid'</span><span class="token">=</span><span class="token">></span>$pid<span class="token2">)</span><span class="token2">)</span><span class="token2">;</span>
<span class="token1">foreach</span><span class="token2">(</span>$row as $v<span class="token2">)</span><span class="token2">{</span>
<span class="token5">if</span><span class="token2">(</span>$v<span class="token2">[</span><span class="token4">'pid'</span><span class="token2">]</span><span class="token">==</span><span class="token3">0</span><span class="token2">)</span><span class="token2">{</span>
$v<span class="token2">[</span><span class="token4">'title'</span><span class="token2">]</span> <span class="token">=</span> $v<span class="token2">[</span><span class="token4">'title'</span><span class="token2">]</span><span class="token2">;</span>
<span class="token2">}</span> <span class="token5">else</span><span class="token2">{</span>
$v<span class="token2">[</span><span class="token4">'title'</span><span class="token2">]</span> <span class="token">=</span> <span class="token1">str_repeat</span><span class="token2">(</span><span class="token4">' '</span><span class="token2">,</span>$spac<span class="token2">)</span><span class="token2">.</span><span class="token4">"|--"</span><span class="token2">.</span>$v<span class="token2">[</span><span class="token4">'title'</span><span class="token2">]</span><span class="token2">;</span>
<span class="token2">}</span>
$result<span class="token2">[</span><span class="token2">]</span> <span class="token">=</span> $v<span class="token2">;</span>
<span class="token1">gettree</span><span class="token2">(</span>$v<span class="token2">[</span><span class="token4">'id'</span><span class="token2">]</span><span class="token2">,</span>$result<span class="token2">,</span>$spac<span class="token2">)</span><span class="token2">;</span>
<span class="token2">}</span>
<span class="token5">return</span> $result<span class="token2">;</span>
<span class="token2">}</span>
<span class="token6">/*
* 父类id 选中的id
* */</span>
<span class="token5">function</span> <span class="token1">puttree</span><span class="token2">(</span>$pid<span class="token">=</span><span class="token3">0</span><span class="token2">,</span>$selected<span class="token">=</span><span class="token3">0</span><span class="token2">)</span><span class="token2">{</span>
$rs <span class="token">=</span> <span class="token1">gettree</span><span class="token2">(</span>$pid<span class="token2">)</span><span class="token2">;</span>
$str<span class="token">=</span><span class="token4">''</span><span class="token2">;</span>
$str <span class="token2">.</span><span class="token">=</span> <span class="token4">"<select name='pid'>"</span><span class="token2">;</span>
$str <span class="token2">.</span><span class="token">=</span> <span class="token4">'<option value="0">顶级分类</option>'</span><span class="token2">;</span>
<span class="token1">foreach</span><span class="token2">(</span>$rs as $key<span class="token">=</span><span class="token">></span>$val<span class="token2">)</span><span class="token2">{</span>
<span class="token5">if</span><span class="token2">(</span>$val<span class="token2">[</span><span class="token4">'id'</span><span class="token2">]</span> <span class="token">==</span> $selected<span class="token2">)</span><span class="token2">{</span>
$selectedstr <span class="token">=</span> <span class="token4">"selected"</span><span class="token2">;</span>
<span class="token2">}</span><span class="token5">else</span><span class="token2">{</span>
$selectedstr <span class="token">=</span> <span class="token4">""</span><span class="token2">;</span>
<span class="token2">}</span>
$str <span class="token2">.</span><span class="token">=</span> <span class="token4">"<option $selectedstr value='"</span><span class="token2">.</span>$val<span class="token2">[</span><span class="token4">'id'</span><span class="token2">]</span><span class="token2">.</span><span class="token4">"'>"</span><span class="token2">.</span>$val<span class="token2">[</span><span class="token4">'title'</span><span class="token2">]</span><span class="token2">.</span><span class="token4">"</option>"</span><span class="token2">;</span>
<span class="token2">}</span>
$str <span class="token2">.</span><span class="token">=</span> <span class="token4">"</select>"</span><span class="token2">;</span>
<span class="token5">return</span> $str<span class="token2">;</span>
<span class="token2">}</span>
<span class="token6">//面包屑路径 ,$cid为分类id ,直到返回顶级</span>
<span class="token5">function</span> <span class="token1">getmenu</span><span class="token2">(</span>$cid<span class="token2">,</span><span class="token">&</span>$result<span class="token">=</span><span class="token1">array</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span><span class="token2">{</span>
<span class="token6">//引用数据库连接资源</span>
$row <span class="token">=</span> <span class="token1">pdo_get</span><span class="token2">(</span><span class="token4">'item'</span><span class="token2">,</span><span class="token1">array</span><span class="token2">(</span><span class="token4">'id'</span><span class="token">=</span><span class="token">></span>$cid<span class="token2">)</span><span class="token2">)</span><span class="token2">;</span>
<span class="token5">if</span><span class="token2">(</span>$row<span class="token2">)</span><span class="token2">{</span>
$result<span class="token2">[</span><span class="token2">]</span> <span class="token">=</span> $row<span class="token2">;</span>
<span class="token1">getmenu</span><span class="token2">(</span>$row<span class="token2">[</span><span class="token4">'pid'</span><span class="token2">]</span><span class="token2">,</span>$result<span class="token2">)</span><span class="token2">;</span>
<span class="token2">}</span>
<span class="token6">//数组顺序倒序</span>
<span class="token1">krsort</span><span class="token2">(</span>$result<span class="token2">)</span><span class="token2">;</span>
<span class="token5">return</span> $result<span class="token2">;</span>
<span class="token2">}</span>
<span class="token6">//输出从当前分类到顶级分类路径</span>
<span class="token5">function</span> <span class="token1">putmenu</span><span class="token2">(</span>$cid<span class="token2">,</span>$url<span class="token">=</span><span class="token4">"demo.php?cid="</span><span class="token2">)</span><span class="token2">{</span>
$res <span class="token">=</span> <span class="token1">getmenu</span><span class="token2">(</span>$cid<span class="token2">)</span><span class="token2">;</span>
$str <span class="token">=</span> <span class="token4">""</span><span class="token2">;</span>
<span class="token1">foreach</span><span class="token2">(</span>$res as $key<span class="token">=</span><span class="token">></span>$val<span class="token2">)</span><span class="token2">{</span>
$str <span class="token2">.</span><span class="token">=</span> <span class="token4">"<a href='{$url}{$val['id']}'>{$val['title']}</a>>"</span><span class="token2">;</span>
<span class="token2">}</span>
<span class="token5">return</span> $str<span class="token2">;</span>
<span class="token2">}</span>
<span class="token6">//查询下级 下下级</span>
<span class="token5">function</span> <span class="token1">get_cid</span><span class="token2">(</span>$cid<span class="token2">,</span><span class="token">&</span>$result<span class="token">=</span><span class="token1">array</span><span class="token2">(</span><span class="token2">)</span><span class="token2">)</span><span class="token2">{</span>
$row <span class="token">=</span> <span class="token1">pdo_getall</span><span class="token2">(</span><span class="token4">'item'</span><span class="token2">,</span><span class="token1">array</span><span class="token2">(</span><span class="token4">'pid'</span><span class="token">=</span><span class="token">></span>$cid<span class="token2">)</span><span class="token2">)</span><span class="token2">;</span>
<span class="token5">if</span><span class="token2">(</span>$row<span class="token2">)</span><span class="token2">{</span>
<span class="token1">foreach</span><span class="token2">(</span>$row as $v<span class="token2">)</span><span class="token2">{</span>
$result<span class="token2">[</span><span class="token2">]</span> <span class="token">=</span> $v<span class="token2">;</span>
<span class="token1">get_cid</span><span class="token2">(</span>$v<span class="token2">[</span><span class="token4">'id'</span><span class="token2">]</span><span class="token2">,</span>$result<span class="token2">)</span><span class="token2">;</span>
<span class="token2">}</span>
<span class="token2">}</span>
<span class="token5">return</span> $result<span class="token2">;</span>
<span class="token2">}</span>
<span class="token">?</span><span class="token">></span>
<span class="token"><</span><span class="token">!</span>DOCTYPE html<span class="token">></span>
<span class="token"><</span>html<span class="token">></span>
<span class="token"><</span>head<span class="token">></span>
<span class="token"><</span>meta charset<span class="token">=</span><span class="token4">"UTF-8"</span><span class="token">></span>
<span class="token"><</span>title<span class="token">></span>演示无限级分类<span class="token"><</span><span class="token">/</span>title<span class="token">></span>
<span class="token"><</span>style<span class="token">></span>
<span class="token2">.</span>table <span class="token2">{</span>
width<span class="token2">:</span> <span class="token3">100</span><span class="token">%</span><span class="token2">;</span>
background<span class="token2">:</span> #f8f9fa<span class="token2">;</span>
margin<span class="token2">:</span> <span class="token3">10</span>px auto<span class="token2">;</span>
border<span class="token">-</span>collapse<span class="token2">:</span> collapse<span class="token2">;</span>
<span class="token2">}</span>
<span class="token2">.</span>table th<span class="token2">,</span>
<span class="token2">.</span>table td <span class="token2">{</span>
border<span class="token2">:</span> <span class="token3">1</span>px solid #f0f1f4<span class="token2">;</span>
padding<span class="token2">:</span> <span class="token3">8</span>px<span class="token2">;</span>
<span class="token2">}</span>
<span class="token2">.</span>table th <span class="token2">{</span>
background<span class="token2">:</span> #f8f9fa<span class="token2">;</span>
font<span class="token">-</span>weight<span class="token2">:</span> bold<span class="token2">;</span>
<span class="token2">}</span>
<span class="token2">.</span>table tr <span class="token2">{</span>
background<span class="token2">:</span> #FFF<span class="token2">;</span>
<span class="token2">}</span>
<span class="token2">.</span>table tr<span class="token2">:</span>hover <span class="token2">{</span>
background<span class="token2">:</span> #f8f9fa<span class="token2">;</span>
<span class="token2">}</span>
<span class="token2">.</span>table td a <span class="token2">{</span>
color<span class="token2">:</span> #<span class="token3">18</span>B4ED<span class="token2">;</span>
text<span class="token">-</span>decoration<span class="token2">:</span> none<span class="token2">;</span>
<span class="token2">}</span>
<span class="token2">.</span>table td a<span class="token2">:</span>hover <span class="token2">{</span>
color<span class="token2">:</span> #<span class="token3">18</span>B4ED<span class="token2">;</span>
text<span class="token">-</span>decoration<span class="token2">:</span> underline<span class="token2">;</span>
<span class="token2">}</span>
<span class="token"><</span><span class="token">/</span>style<span class="token">></span>
<span class="token"><</span><span class="token">/</span>head<span class="token">></span>
<span class="token"><</span>body<span class="token">></span>
<span class="token"><</span><span class="token">?</span>php <span class="token6">//默认设置顶级分类开始,1选中</span>
echo <span class="token1">puttree</span><span class="token2">(</span><span class="token3">0</span><span class="token2">,</span><span class="token3">1</span><span class="token2">)</span> <span class="token2">;</span>
echo <span class="token1">putmenu</span><span class="token2">(</span><span class="token3">8</span><span class="token2">)</span> <span class="token2">;</span><span class="token">?</span><span class="token">></span>
<span class="token"><</span>table class<span class="token">=</span><span class="token4">"table"</span><span class="token">></span>
<span class="token"><</span>tr<span class="token">></span><span class="token"><</span>th<span class="token">></span>ID<span class="token"><</span><span class="token">/</span>th<span class="token">></span><span class="token"><</span>th<span class="token">></span>上级ID<span class="token"><</span><span class="token">/</span>th<span class="token">></span><span class="token"><</span>th<span class="token">></span>分类名称<span class="token"><</span><span class="token">/</span>th<span class="token">></span><span class="token"><</span><span class="token">/</span>tr<span class="token">></span>
<span class="token"><</span>tbody<span class="token">></span>
<span class="token"><</span><span class="token">?</span>php
<span class="token1">foreach</span><span class="token2">(</span><span class="token1">gettree</span><span class="token2">(</span><span class="token2">)</span> as $k<span class="token">=</span><span class="token">></span>$v<span class="token2">)</span><span class="token2">{</span>
echo <span class="token4">"<tr ><td>"</span><span class="token2">.</span>$v<span class="token2">[</span><span class="token4">'id'</span><span class="token2">]</span><span class="token2">.</span><span class="token4">"</td><td>"</span><span class="token2">.</span>$v<span class="token2">[</span><span class="token4">'pid'</span><span class="token2">]</span><span class="token2">.</span><span class="token4">"</td><td align='left'>"</span><span class="token2">.</span>$v<span class="token2">[</span><span class="token4">'title'</span><span class="token2">]</span><span class="token2">.</span><span class="token4">"</td></tr>"</span><span class="token2">;</span>
<span class="token2">}</span>
<span class="token">?</span><span class="token">></span>
<span class="token"><</span><span class="token">/</span>tbody<span class="token">></span>
<span class="token"><</span><span class="token">/</span>table<span class="token">></span>
<span class="token"><</span><span class="token">/</span>body<span class="token">></span>
<span class="token"><</span><span class="token">/</span>html<span class="token">></span>
```
```
- 简介
- 第一章 数据库
- Mysql/mariadb
- 函数
- 基础
- 增删改索引
- 标准查询
- 高级查询
- TIDB集群mysql解决方案
- Redis
- 语言基础
- 5种数据类型
- 其他类型
- Sqlite
- 语言基础
- 常用查询
- 第二章 PHP
- 语言基础
- 第一课 流程控制和运算
- 第二课 数组
- 第三课 日期时间
- 第四课 常用函数
- 第五课 字符串
- 第六课 文件操作
- 第七课 面向对象
- 第八课 正则表达式
- 第九课 图片处理生成
- 第十课 curl/memche
- 第十一课 mysql和pdo
- 第十三课 cookie和session
- 第十四课 xml操作
- 第十五课 php5.3+新特性
- 第十六课 php7+
- 第十七课 密码安全
- 废弃函数
- php命令行
- redis应用
- 算法
- 排序算法
- 基础算法
- 无限级分类
- 自定义函数Fn
- 查找算法
- 自定义函数数据函数fn
- laravel
- 路由
- 常用语句
- 数据库
- dingo/api
- Yii2
- 控制器
- 常用类
- 数据库
- redis
- thinkphp6
- TP6文档
- TP6插件
- dedecms
- 织梦标签大全
- 数据库操作
- 内置函数和定义函数
- 织梦核心改动
- 织梦插件/底层标签开发
- PHP相关工具
- composer
- php开发环境phpenv
- Phpstorm使用
- windows编译php扩展
- PHP开源库
- 开源项目管理禅道
- sns_auth
- php-casbin权限控制
- php-jwt
- 微信SDKeasywechat
- querylist采集库
- workerman
- Box/Spout处理excel和csv
- dll扩展
- redis/memche/xdebug
- redis
- Lua
- php_xlswriter
- event
- swoole
- 常用代码库
- 微擎框架
- 第一课全局变量
- 第二课常用函数
- 第三课自定义微擎独有函数
- 第四课数据库操作
- 第五课微信端回复
- 第六课微擎高级操作
- 第八课global函数列表
- mainfest.xml详解
- js方法
- 人人商城
- 第一课model解读
- 第二课常用语句解读
- 第三课常用js解读
- 第四课附录常见问题
- 第五课附录处理报表|支付
- 常用JSON状态码
- 第三章 JavaScript
- js基础
- 浏览器对象
- 语言基础
- html5接口
- ES6新语法
- vue
- 基础语法
- 京东vueUI组件
- uniapp
- 组件开发规范
- nodejs
- 基础知识
- 安装node
- nvm不同版本node切换
- js常用标准库
- zepto/jquery
- weui
- js图标库
- elementUI
- validator表单验证
- layer弹出层
- requirejs
- wow动画
- 动画animate
- swiper4
- 百度编辑器
- flyio/axios/qs
- jquery.form
- bootstrap3
- clipboard复制
- slideout侧滑
- imagehover.css图片悬停动画
- webpack打包
- Bulma UI框架
- store 客户端存储
- lottie动画创建库
- sweetalert
- js自定义函数
- 常见JSSDK
- 微信公众号JSSDK
- 腾讯地图jssdk
- 微信小程序
- 第四章 编程语言
- markdown语言
- Dart语言
- Dart语言基础
- Flutter框架
- Lua语言
- 字符串,数组,表
- 自定义方法
- go语言
- 第1.1语言基本语法
- 第1.2流程控制
- 第1.3函数
- 第1.4结构体
- 第1.5接口
- 第1.6包
- go语言框架Gin
- CSS3语言
- CSS与CSS3
- 选择符
- 属性
- css3
- loading动画
- HTML5语言
- less
- sass
- C#
- 基础知识
- 函数
- 第五章 开发工具
- git
- nginx/apache服务器
- Linux常用操作
- crontab定时任务
- 注册表与cmd
- 阿里云ECS
- frp穿透和ssl续期
- 宝塔安装
- 树莓派
- 浏览器模拟
- 火狐/chrome常用插件
- WSL安装使用
- mac brew和终端命令
- win10相关