前往小程序，Get更优阅读体验！
立即前往
文档建议反馈控制台
首页
学习
活动
专区
工具
TVP
最新优惠活动
文章/答案/技术大牛
发布
首页
学习
活动
专区
工具
TVP最新优惠活动
返回腾讯云官网
社区首页 >专栏 >tp6中无限极分类里面的获取多级分类数据

tp6中无限极分类里面的获取多级分类数据

作者头像
贵哥的编程之路
发布于 2022-06-05 11:26:48
9360
发布于 2022-06-05 11:26:48
举报
文章被收录于专栏：用户7873631的专栏用户7873631的专栏

作者：陈业贵 华为云享专家 51cto(专家博主 明日之星 TOP红人)

文章目录

前言

和大家共同完成获取多级分类数据

一、什么是多级分类数据？

就是很多很多的数据，按照无限极分类结构排序。每一个数组的所有数据都是顶级分类及其其下数据

二、使用步骤

代码语言：javascript
复制
$allcate=$this->order('listorder asc')->field('id,parent_id,cate_name')->select()->toArray();

第一步：这张表qing_category。把这张表所有的数据转换成数组格式。取出字段id,parent_id,cate_name。按照从小到大排序。

代码语言：javascript
复制
foreach ($allcate as $k => $v) {
        	if($v['parent_id']==0){

第二步：遍历数组并取出顶级分类的数据，放进data[]=v;这里。

代码语言：javascript
复制
foreach ($allcate as $k1 => $v1) {
                	if($v1['parent_id']==$v['id']){

第三步： 取出某个顶级分类其下的二级分类的所有数据。方进v['children'][]=v1;中。

代码语言：javascript
复制
foreach ($allcate as $k2 => $v2) {
                        	if($v2['parent_id']==$v1['id']){
                        		$v1['children'][]=$v2;
                        	}

第四步：取三级分类的所有数据放进v1['children'][]=v2;中 最后返回 return

sql

代码如下（示例）：

代码语言：javascript
复制
 -- phpMyAdmin SQL Dump
-- version 4.8.5
-- https://www.phpmyadmin.net/
--
-- 主机： localhost
-- 生成日期： 2022-06-04 19:25:49
-- 服务器版本： 5.7.26
-- PHP 版本： 7.3.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 数据库： `kkk`
--

-- --------------------------------------------------------

--
-- 表的结构 `qing_category`
--

CREATE TABLE `qing_category` (
  `id` int(10) UNSIGNED NOT NULL COMMENT '栏目id',
  `cate_name` varchar(30) NOT NULL COMMENT '栏目名称',
  `seo_title` varchar(150) NOT NULL COMMENT '栏目标题',
  `seo_keywords` varchar(150) NOT NULL COMMENT '关键词',
  `seo_description` varchar(255) NOT NULL COMMENT '描述',
  `content` text COMMENT '内容',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态 1：显示 0：隐藏',
  `thumb` varchar(150) DEFAULT NULL COMMENT '图片',
  `link` varchar(150) NOT NULL COMMENT '栏目外链',
  `listorder` smallint(6) NOT NULL DEFAULT '50' COMMENT '排序',
  `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上级id',
  `type_id` int(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- 转存表中的数据 `qing_category`
--

INSERT INTO `qing_category` (`id`, `cate_name`, `seo_title`, `seo_keywords`, `seo_description`, `content`, `status`, `thumb`, `link`, `listorder`, `parent_id`, `type_id`) VALUES
(1, '女装 / 内衣', '', '', '', NULL, 1, '/public/upload/20200907/a9a2ebdfc574b7ba4f63111b725173a1.jpg', '', 1, 0, 2),
(2, '浪漫裙装', '', '', '', NULL, 0, NULL, '', 50, 1, 1),
(3, '美妆 / 护理', '', '', '', NULL, 1, '/public/upload/20200907/6720d04938b02fad0a8df2468a954b98.jpg', '', 3, 0, 0),
(4, '生活电器', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 4, 0, 0),
(5, '护肤品', '', '', '', NULL, 1, '/public/upload/20200907/3dfe3c4b167f688385657d72d1321bc5.jpg', '', 50, 3, 0),
(6, '家居服', '', '', '', NULL, 1, '/public/upload/20200907/bf429889460c7a17b6521c201ef06b18.jpg', '', 50, 1, 0),
(7, '彩妆', '', '', '', NULL, 1, '/public/upload/20200907/59feb5c76f25fc55545541c381f6fb7f.jpg', '', 50, 3, 0),
(8, '洗衣机', '', '', '', NULL, 1, NULL, '', 50, 4, NULL),
(9, '电冰箱', '', '', '', NULL, 1, NULL, '', 50, 4, NULL),
(10, '家居 / 建材', '', '', '', NULL, 1, NULL, '', 50, 0, NULL),
(11, '母婴 / 玩具', '', '', '', NULL, 1, NULL, '', 50, 0, NULL),
(12, '图书 / 音像', '', '', '', NULL, 1, NULL, '', 30, 0, NULL),
(13, '零食 / 茶酒', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 5, 0, 0),
(14, '手机 / 数码', '', '', '', NULL, 1, '/public/upload/20200907/5feb28d16702eaf24bf85ebccc954d2d.jpg', '', 2, 0, 0),
(15, '腕表 / 首饰', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 6, 0, 0),
(16, '小米', '', '', '', NULL, 1, NULL, '', 50, 18, 1),
(17, '荣耀', '', '', '', NULL, 1, NULL, '', 50, 18, NULL),
(18, '热门手机', '', '', '', NULL, 1, NULL, '', 50, 14, 1),
(19, '电脑整机', '', '', '', NULL, 1, NULL, '', 50, 14, NULL),
(20, '笔记本', '', '', '', NULL, 1, NULL, '', 50, 19, NULL),
(21, '平板电脑', '', '', '', NULL, 1, NULL, '', 50, 19, NULL),
(22, '台式机', '', '', '', NULL, 1, NULL, '', 50, 19, NULL),
(23, '一体机', '', '', '', NULL, 1, NULL, '', 50, 19, NULL),
(24, '游戏本', '', '', '', NULL, 1, NULL, '', 50, 19, NULL),
(25, 'iPad', '', '', '', NULL, 1, NULL, '', 50, 19, NULL),
(26, 'Iphone', '', '', '', NULL, 1, NULL, '', 50, 18, NULL),
(27, '魅族', '', '', '', NULL, 1, NULL, '', 50, 18, NULL),
(28, '华为', '', '', '', NULL, 1, NULL, '', 50, 18, NULL),
(29, 'OPPO', '', '', '', NULL, 1, NULL, '', 50, 18, NULL),
(30, '智能数码', '', '', '', NULL, 1, NULL, '', 50, 14, NULL),
(31, '智能设备', '', '', '', NULL, 1, NULL, '', 50, 30, NULL),
(32, '智能手表', '', '', '', NULL, 1, NULL, '', 50, 30, NULL),
(33, '智能手环', '', '', '', NULL, 1, NULL, '', 50, 30, NULL),
(34, 'VR眼镜', '', '', '', NULL, 1, NULL, '', 50, 30, NULL),
(35, '智能摄像', '', '', '', NULL, 1, NULL, '', 50, 30, NULL),
(36, '智能健康', '', '', '', NULL, 1, NULL, '', 50, 30, NULL),
(37, '智能机器人', '', '', '', NULL, 1, NULL, '', 50, 30, NULL),
(38, '硬件存储', '', '', '', NULL, 1, NULL, '', 50, 14, NULL),
(39, '显示器', '', '', '', NULL, 1, NULL, '', 50, 38, NULL),
(40, '机械键盘', '', '', '', NULL, 1, NULL, '', 50, 38, NULL),
(41, '固态硬盘', '', '', '', NULL, 1, NULL, '', 50, 38, NULL),
(42, 'CPU', '', '', '', NULL, 1, NULL, '', 50, 38, NULL),
(43, '显卡', '', '', '', NULL, 1, NULL, '', 50, 38, NULL),
(44, '主板', '', '', '', NULL, 1, NULL, '', 50, 38, NULL),
(45, '高速U盘', '', '', '', NULL, 1, NULL, '', 50, 38, NULL),
(46, '路由器', '', '', '', NULL, 1, NULL, '', 50, 38, NULL),
(47, '摄影摄像', '', '', '', NULL, 1, NULL, '', 50, 14, NULL),
(48, '相机', '', '', '', NULL, 1, NULL, '', 50, 47, NULL),
(49, '单反', '', '', '', NULL, 1, NULL, '', 50, 47, NULL),
(50, '单电微单', '', '', '', NULL, 1, NULL, '', 50, 47, NULL),
(51, '摄像机', '', '', '', NULL, 1, NULL, '', 50, 47, NULL),
(52, '自拍神器', '', '', '', NULL, 1, NULL, '', 50, 47, NULL),
(53, '拍立得', '', '', '', NULL, 1, NULL, '', 50, 47, NULL),
(54, '镜头', '', '', '', NULL, 1, NULL, '', 50, 47, NULL),
(55, '自拍杆', '', '', '', NULL, 1, NULL, '', 50, 47, NULL),
(56, '影音娱乐', '', '', '', NULL, 1, NULL, '', 50, 14, NULL),
(57, '耳机', '', '', '', NULL, 1, NULL, '', 50, 56, NULL),
(58, '天猫魔盒', '', '', '', NULL, 1, NULL, '', 50, 56, NULL),
(59, '数码影音', '', '', '', NULL, 1, NULL, '', 50, 56, NULL),
(60, '家庭影院', '', '', '', NULL, 1, NULL, '', 50, 56, NULL),
(61, '蓝牙耳机', '', '', '', NULL, 1, NULL, '', 50, 56, NULL),
(62, '网络播放器', '', '', '', NULL, 1, NULL, '', 50, 56, NULL),
(63, '精选上装', '', '', '', NULL, 1, '/public/upload/20200907/12e2badae06d0be8dd1f6186c4142ea6.jpg', '', 50, 1, 2),
(64, '女士下装', '', '', '', NULL, 1, '/public/upload/20200907/bc7a1f58d4d737ffc2842f9483f2d7b0.jpg', '', 50, 1, 0),
(65, '特色女装', '', '', '', NULL, 1, '/public/upload/20200907/5b999d2f7a73e7616fe6f86e8b9eab4b.jpg', '', 50, 1, 0),
(66, '文胸塑身', '', '', '', NULL, 1, '/public/upload/20200907/049adc94a689a1ec4bccba90c43e719a.jpg', '', 50, 1, 0),
(67, '毛呢外套', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(68, '羽绒服', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(69, '棉服', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(70, '丝绒卫衣', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(71, '毛针织衫', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(72, '皮毛一体', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(73, '皮草', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(74, '毛衣', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 63, 2),
(75, '衬衫', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(76, '卫衣', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 63, 2),
(77, '针织衫', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(78, 'T恤', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(79, '短外套', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(80, '小西装', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(81, '风衣', '', '', '', NULL, 1, NULL, '', 50, 63, NULL),
(82, '连衣裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(83, '半身裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(84, 'A字裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(85, '荷叶边裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(86, '大摆裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(87, '包臀裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(88, '百褶裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(89, '长袖', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(90, '连衣裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(91, '棉麻连衣裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(92, '牛仔裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(93, '蕾丝连衣裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(94, '真丝连衣裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(95, '印花连衣裙', '', '', '', NULL, 1, NULL, '', 50, 2, NULL),
(96, '春夏家居服', '', '', '', NULL, 1, NULL, '', 50, 6, NULL),
(97, '纯棉家居服', '', '', '', NULL, 1, NULL, '', 50, 6, NULL),
(98, '莫代尔家居服', '', '', '', NULL, 1, NULL, '', 50, 6, NULL),
(99, '真丝家居服', '', '', '', NULL, 1, NULL, '', 50, 6, NULL),
(100, '春夏睡裙', '', '', '', NULL, 1, NULL, '', 50, 6, NULL),
(101, '男士家居服', '', '', '', NULL, 1, NULL, '', 50, 6, NULL),
(102, '情侣家居服', '', '', '', NULL, 1, NULL, '', 50, 6, NULL),
(103, '性感睡裙', '', '', '', NULL, 1, NULL, '', 50, 6, NULL),
(104, '休闲裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(105, '阔腿裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(106, '牛仔裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(107, '打底裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(108, '开叉运动裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(109, '哈伦裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(110, '背带裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(111, '小脚裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(112, '西装裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(113, '短裤', '', '', '', NULL, 1, NULL, '', 50, 64, NULL),
(114, '时尚套装', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(115, '休闲套装', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(116, '日系女装', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(117, '精选妈妈装', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(118, '大码女装', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(119, '职业套装', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(120, '优雅旗袍', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(121, '精致礼服', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(122, '婚纱', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(123, '唐装', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(124, '小码女装', '', '', '', NULL, 1, NULL, '', 50, 65, NULL),
(125, '光面文胸', '', '', '', NULL, 1, NULL, '', 50, 66, NULL),
(126, '运动文胸', '', '', '', NULL, 1, NULL, '', 50, 66, NULL),
(127, '美背文胸', '', '', '', NULL, 1, NULL, '', 50, 66, NULL),
(128, '聚拢文胸', '', '', '', NULL, 1, NULL, '', 50, 66, NULL),
(129, '大杯文胸', '', '', '', NULL, 1, NULL, '', 50, 66, NULL),
(130, '轻薄塑身', '', '', '', NULL, 1, NULL, '', 50, 66, NULL),
(131, '家居服', '', '', '', '', 1, '/public/upload/20200907/6502a54382a96c2f370933c280a8456f.jpg', '', 50, 1, 1),
(132, '精选上衣', '', '', '', '', 1, '/public/upload/20200907/be5921de5ee20e4932305a8dabd8d7d8.jpg', '', 50, 1, 1),
(133, '家居服A', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 6, 2),
(134, '家居服B', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 6, 2),
(138, '进口零食', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 13, 1),
(139, '休闲零食', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 13, 1),
(140, '酒类', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 13, 1),
(141, '茶叶1', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 13, 1),
(142, '茶叶2', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 13, 1),
(143, '', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 13, 1),
(144, '大牌乐器', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 12, 1),
(145, '儿童读书', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 12, 1),
(146, '儿童读物1', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 12, 1),
(148, '儿童读书2', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 12, 1),
(149, '儿童读书3', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 12, 1),
(150, '玩具', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 11, 1),
(151, '童装', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 11, 1),
(155, '电视机', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 4, 3),
(153, '婴儿服', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 11, 1),
(154, '奶粉', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 11, 1),
(156, '液晶电视机', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 155, 3),
(157, '灯饰照明', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 4, 0),
(158, '灯泡', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 157, 0),
(159, '办公文教', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 14, 0),
(160, '婴儿玩具', '', '', '', NULL, 1, '/public/static/index/images/thumb.jpg', '', 50, 150, 0);

--
-- 转储表的索引
--

--
-- 表的索引 `qing_category`
--
ALTER TABLE `qing_category`
  ADD PRIMARY KEY (`id`);

--
-- 在导出的表使用AUTO_INCREMENT
--

--
-- 使用表AUTO_INCREMENT `qing_category`
--
ALTER TABLE `qing_category`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '栏目id', AUTO_INCREMENT=161;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

代码

代码语言：javascript
复制
use app\common\model\Category as CategoryModel;//引用category这张表并取名为CategoryModel
$category_model=new CategoryModel();
        $indexCate=$category_model->getNavCateData();
        halt($indexCate);
代码语言：javascript
复制
public function getNavCateData(){
		$data=array();
		$allcate=$this->order('listorder asc')->field('id,parent_id,cate_name')->select()->toArray();
		
        foreach ($allcate as $k => $v) {
        	if($v['parent_id']==0){
        		
                foreach ($allcate as $k1 => $v1) {
                	if($v1['parent_id']==$v['id']){

                        foreach ($allcate as $k2 => $v2) {
                        	if($v2['parent_id']==$v1['id']){
                        		$v1['children'][]=$v2;
                        	}
                        }

                		$v['children'][]=$v1;
                	}
                }

        		$data[]=$v;
        	}
        }
        return $data;
	}

2.效果图

在这里插入图片描述
在这里插入图片描述

总结

谢谢大家的观看，谢谢！

本文参与 腾讯云自媒体同步曝光计划，分享自作者个人站点/博客。
原始发表：2022-06-04，如有侵权请联系 cloudcommunity@tencent.com 删除
编程算法
sql

本文分享自 作者个人站点/博客 前往查看

如有侵权，请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体同步曝光计划  ，欢迎热爱写作的你一起参与！

编程算法
sql
评论
登录后参与评论
0 条评论
热度
最新
登录 后参与评论
推荐阅读
LV.
文章
0
获赞
0
目录
  • 文章目录
  • 前言
  • 一、什么是多级分类数据？
  • 二、使用步骤
    • sql
      • 代码
        • 2.效果图
        • 总结
        相关产品与服务
        腾讯云小微
        腾讯云小微，是一套腾讯云的智能服务系统，也是一个智能服务开放平台，接入小微的硬件可以快速具备听觉和视觉感知能力，帮助智能硬件厂商实现语音人机互动和音视频服务能力。
        产品介绍产品文档
        618年中盛惠，限时抢
        领券

        腾讯云开发者

        扫码关注腾讯云开发者

        扫码关注腾讯云开发者

        领取腾讯云代金券

        热门产品

        热门推荐

        更多推荐

        Copyright © 2013 - 2024 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

        深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 深公网安备号 44030502008569

        腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号 | 京公网安备号11010802020287

        问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档

        Copyright © 2013 - 2024 Tencent Cloud.

        All Rights Reserved. 腾讯云 版权所有

        登录 后参与评论