在PHP MySQL上选择嵌套记录

i have a table in database sql like below, and i want to display it based on id and how many record (generation)

+-------------------------------+
|      ID      |    Parent_ID   | 
+-------------------------------+
|      1       |        0       |
+-------------------------------+
|      2       |        1       |
+-------------------------------+
|      3       |        1       |
+-------------------------------+
|      4       |        2       |
+-------------------------------+
|      5       |        2       | 
+-------------------------------+
|      6       |        2       |
+-------------------------------+
|      7       |        2       |
+-------------------------------+
|      8       |        3       | 
+-------------------------------+
|      9       |        5       |
+-------------------------------+
|      10      |        7       |
+-------------------------------+
|      11       |       10      | 
+-------------------------------+
|      12       |       10      | 
.................................
The list goes on..

so if i want to select the ID = 2 and record from 1st generation to 4th generation, the result is gonna be like this

+-------------------------------+
|      ID      |    Parent_ID   | 
+-------------------------------+
|      2       |        1       |  -> 1st generation
+-------------------------------+
|      4       |        2       |  -> 2nd generation
+-------------------------------+
|      5       |        2       |  -> 2nd generation
+-------------------------------+
|      6       |        2       |  -> 2nd generation
+-------------------------------+
|      7       |        2       |  -> 2nd generation
+-------------------------------+
|      10      |        7       |  -> 3rd generation
+-------------------------------+
|      12       |       10      |  -> 4th generation
.................................

the generation is not always from first, so i start select from any generation position, any idea how to do this in php or php laravel using MySQL database?

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

报告相同问题？

关注问题

另一个嵌套循环php + mysql查询 mysql php
2018-06-20 02:08

回答 2 已采纳 Mostly it will be like the below. The idea is Sort the rows with category. [you have done thi
PHP将嵌套的json插入mySQl json mysql php
2018-03-07 21:29

回答 2 已采纳 The problem is rather simple. Your insert statement is outside your for statement which is resulti
嵌套对象用php写入mysql mysql php
2016-11-11 20:48

回答 1 已采纳 The last three variables are subitems of price. So you need to change $inpr = $row -> INPR; $e
PHP中实现MySQL嵌套事务的两种解决方案
2020-12-15 07:35

在MySQL的官方文档中有明确的说明不支持嵌套事务：代码如下: Transactions cannot be nested. This is a consequence of the implicit commit performed for any current transaction when you issue a START ...
如何在PHP MySQL中循环中运行嵌套语句？ mysql php
2016-11-11 12:56

回答 1 已采纳 Try to do the timeout timein comparison in a database level and not php. Change your code to some
嵌套在MySQL（PHP）中的JSON json mysql php
2015-10-06 02:03

回答 1 已采纳 $parents = array(); $sql = "SELECT ID, NAME FROM articles WHERE NAME!='' AND PARENTID='' ORDER BY
嵌套while循环php mysql mysql php
2015-03-11 13:05

回答 1 已采纳 It may not be the best solution, but I cannot think of something better right now. In the pre-exec
php-nested-comments:使用PHP和MySQL的简单嵌套注释
2021-05-01 17:28

php-nested-comments 使用PHP和MySQL的简单嵌套注释使用随附的schema.sql在数据库中创建一个新的user_comments表修改index.php中的数据库连接详细信息测试您的新嵌套评论！
PHP将嵌套的json保存到mysql数据库 json mysql php
2016-08-07 00:14

回答 1 已采纳 You were looping through the wrong element of your array. As you want to list the items, your loop
PHP / MySQL：如何从嵌套循环中区分重复的id mysql php
2016-09-05 16:54

回答 1 已采纳 It seems like all you need is a single LEFT JOIN query: SELECT COALESCE(t2.Sub_criteria_name, t1.
使用PHP将嵌套的Json数组导入Mysql [关闭] json mysql php
2018-10-24 20:18

回答 2 已采纳 After lots of googling I have come up with the solution, and I apologize if I didn't word my quest
php的mysql事务嵌套,MySql中的事务嵌套
2021-05-08 06:56

南都有雪的博客 2、Mysql是不支持嵌套事务的，开启了一个事务的情况下，再开启一个事务，会隐式的提交上一个事务。3、Mysql默认是autocommit=1，也就是说默认是立即提交，如果想开启事务，先设置autocommit=0，然后用START ...
将嵌套的php数组添加到mysql mysql php
2015-10-24 15:39

回答 1 已采纳 $data = array(...); // your data array; $values = array(); foreach ($data $v) { $clicks = (int
php mysql 嵌套查询_MYSQL数据库MySQL嵌套查询实例详解
2021-01-28 12:07

常爸-黄任的博客《MYSQL数据库MySQL嵌套查询实例详解》要点：本文介绍了MYSQL数据库MySQL嵌套查询实例详解，希望对您有用。如果有疑问，可以联系我们。MYSQL学习本文实例分析了MySQL嵌套查询.分享给大家供大家参考,具体如下：MYSQL...
nestedset-php:使用嵌套集模式在PHP中对树结构建模
2021-05-26 06:45

如果您不使用任何PHP框架并且需要管理树结构数据，那么这里是使用嵌套集模式对PHP中的树结构进行建模的库安装要安装该库，您可以简单地克隆该库并包含文件pdo.nestedset.php。如果您在项目中使用，则安装nested...
没有解决我的问题, 去提问

悬赏问题

¥15 基于卷积神经网络的声纹识别
¥15 Python中的request，如何使用ssr节点，通过代理requests网页。本人在泰国，需要用大陆ip才能玩网页游戏，合法合规。
¥100 为什么这个恒流源电路不能恒流？
¥15 有偿求跨组件数据流路径图
¥15 写一个方法checkPerson，入参实体类Person，出参布尔值
¥15 我想咨询一下路面纹理三维点云数据处理的一些问题，上传的坐标文件里是怎么对无序点进行编号的，以及xy坐标在处理的时候是进行整体模型分片处理的吗
¥15 CSAPPattacklab
¥15 一直显示正在等待HID—ISP
¥15 Python turtle 画图
¥15 stm32开发clion时遇到的编译问题

码龄粉丝数原力等级 --

在PHP MySQL上选择嵌套记录

0条回答默认最新

悬赏问题

在PHP MySQL上选择嵌套记录

0条回答 默认 最新

悬赏问题

0条回答默认最新