打开此地址查看， 永久有效 ，老手绕行 领接表增强 + mptt 两种模式 http://mat1.gtimg.com/hb/js/common/demo/tree.html 超快查询所有子孙 画个table，写了样式，居然被替换的面目全非，所以，干脆做成html算了。 无 查询子集select * from `table` where `p
打开此地址查看， 永久有效 ，老手绕行
领接表增强 + mptt 两种模式
http://mat1.gtimg.com/hb/js/common/demo/tree.html
超快查询所有子孙
画个table，写了样式，居然被替换的面目全非，所以，干脆做成html算了。
查询子集select * from `table` where `pid` = 3查询子孙集select * from `table` where `place` like '%/3/%'查询某代子集select * from `table` where `place` like '%/3/%' and `level` = 4插入$insert_id = insert into `table` (`name`,`pid`) values('面试专员','10')$parent = select * from `table` where `id` = 10 update `table` set `place` = '{$parent['place']}{$insert_id}/',`level`= {$parent['level']} + 1 where `id` = {$insert_id}修改父级$parent = select * from `table` where `id` = {$pid}update `table` set `pid` = {$pid},`place` = '{$parent['place']}{$insert_id}/',`level`= {$parent['level']} + 1 where `id` = {$id}