If you write a system by yourself, you will often use column management
If there are many levels of column classification, you need to implement infinite classification. The code is as follows
1. Usage in the drop-down menu
/* 无限级分类 * * 逻辑递推获取类型 * hid 上级栏目id * step 下级栏目前缀 * tid seleted选项id */ function LogicGetTypeList($datatable='lanmu_class',$hid=0,$step='',$tid=-1) { static $TypeList=''; $query = "SELECT * FROM `$datatable` WHERE heid=$hid ORDER BY px ASC"; $arrs=mysql_query($query); while($row=@mysql_fetch_assoc($arrs)){ echo $step; $TypeList .= ("<option value='".$row['id']."' "); $TypeList .= ($tid == $row['id']? 'selected' : ''); $TypeList .= (" >".$step.$row['class']."</option>\r\n"); //分类名称 LogicGetTypeList($datatable,$row['id'],$step.'--',$tid); } return $TypeList; }
The code is roughly as follows and needs to be modified according to the specific situation
<?php treeList("",0); function treeList($tag,$classid){ $result=mysql_query("select * from lanmu_class where heid='".$classid."' order by px asc"); while($row=mysql_fetch_array($result)){ /*栏目功能*/ $sqlG=@mysql_fetch_assoc(mysql_query("select * from ht_gn where id='".$row['gongn']."'")); ?> <tr class="blue" <td width="5" align="center" class=""><input type="checkbox" name="dell[]" value="<?php echo $row['id']?>"></td> <td class=""><?php echo $tag.$row['class'];?></td> <td class=""><?php echo $sqlG['gn_title'];?></td> <td align="center" class=""><?php echo $row['template'];?> </td> <td align="center" class=""><input type="text" value="<?php echo $row["px"]?>" size="3" echo $row['id'];?>,this.value)" /> </td> <td class=""> 【<a href="lanmu_add.php?id=<?php echo $row['id'];?>">编辑</a>】 【<a href="#" echo $row['id']?>'}">删除</a>】 【<a href="../car/car_pic.php?s_id=<?php echo $row['id'];?>">图片集</a>】 </td> </tr> <?php treeList($tag."─┴─",$row['id']);?> <?php } } ?>
The above introduces the implementation of unlimited classification in PHP, including the content of PHP and unlimited levels. I hope it will be helpful to friends who are interested in PHP tutorials.