php 无极分类(递归)代码

admin

1. <?php
   
2. $conn=mysql_connect("localhost","root","myoa888");
   
3. mysql_select_db("lost63",$conn) or die("select db error");
   
4. $sql[]="Create TABLE `lost63`.`dd_book_class` (
   
5. `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
   
6. `classname` VARCHAR( 50 ) NOT NULL ,
   
7. `classid` INT NOT NULL
   
8. )";
   
9. $sql[]="insert `dd_book_class` (classname,classid) values ('小说',0)";
   
10. $sql[]="insert `dd_book_class` (classname,classid) values ('文艺',0)";
    
11. $sql[]="insert `dd_book_class` (classname,classid) values ('青春',0)";
    
12. $sql[]="insert `dd_book_class` (classname,classid) values ('励志/成功',0)";
    
13. $sql[]="insert `dd_book_class` (classname,classid) values ('少儿',0)";
    
14. $sql[]="insert `dd_book_class` (classname,classid) values ('悬疑',1)";
    
15. $sql[]="insert `dd_book_class` (classname,classid) values ('言情',1)";
    
16. $sql[]="insert `dd_book_class` (classname,classid) values ('职场',1)";
    
17. $sql[]="insert `dd_book_class` (classname,classid) values ('文学',2)";
    
18. $sql[]="insert `dd_book_class` (classname,classid) values ('科普',5)";
    
19. //print_r($sql);
    
20. /* -- insert test data -- */
    
21. foreach($sql as $value){
    
22. mysql_query($value) or die("insert data error");
    
23. }
    
24. 
    
25. $class_arr=array();
    
26. $recordset=mysql_query("select * from `dd_book_class`");
    
27. while($row=mysql_fetch_array($recordset)){
    
28. $class_arr[]=array($row['id'],$row['classname'],$row['classid']);
    
29. }
    
30. function classtree($n,$id){
    
31. global $class_arr;
    
32. $n = str_pad('',$n,'-',STR_PAD_RIGHT);
    
33. $n = str_replace("-"," ",$n);
    
34. for($i=0;$i<count($class_arr);$i++){
    
35. if($class_arr[$i][2]==$id){
    
36. echo $n.'┠<a href="?class='.$class_arr[$i][0].'">'.$class_arr[$i]
    
37. [1].'</a><br>';
    
38. classtree($n+1,$class_arr[$i][0]);
    
39. }
    
40. }
    
41. }
    
42. classtree(0,0);
    
43. ?>

复制代码