面向新手的php 面试题及答案-填空题与编程题

2. function my_scandir($dir)
3. {
4. $files = array();
5. if ( $handle = opendir($dir) ) {
6. while ( ($file = readdir($handle)) !== false ) {
7. if ( $file != “..” && $file != “.” ) {
8. if ( is_dir($dir . “/” . $file) ) {
9. $files[$file] = scandir($dir . “/” . $file);
10. }else {
11. $files[] = $file;
12. }
13. }
14. }
15. closedir($handle);
16. return $files;
17. }
18. }

复制代码

14.简述论坛中无限分类的实现原理。 答:

3. /*

4. 数据表结构如下:
5. CREATE TABLE `category` (
6. `categoryID` smallint(5) unsigned NOT NULL auto_increment,
7. `categoryParentID` smallint(5) unsigned NOT NULL default ’0′,
8. `categoryName` varchar(50) NOT NULL default ”,
9. PRIMARY KEY (`categoryID`)
10. ) ENGINE=MyISAM DEFAULT CHARSET=gbk;

11. INSERT INTO `category` ( `categoryParentID`, `categoryName`) VALUES

12. (0, ‘一级类别’),
13. (1, ‘二级类别’),
14. (1, ‘二级类别’),
15. (1, ‘二级类别’),
16. (2, ‘三级类别’),
17. (2, ’333332′),
18. (2, ’234234′),
19. (3, ‘aqqqqqd’),
20. (4, ‘哈哈’),
21. (5, ’66333666′);

22. */

23. //指定分类id变量$category_id,然后返回该分类的所有子类

24. //$default_category为默认的选中的分类
25. function Get_Category($category_id = 0,$level = 0, $default_category = 0)
26. {
27. global $DB;
28. $sql = “SELECT * FROM category ORDER BY categoryID DESC”;
29. $result = $DB->query( $sql );
30. while ($rows = $DB->fetch_array($result))
31. {
32. $category_array[$rows[categoryParentID]][$rows[categoryID]] = array(‘id’ => $rows[categoryID], ‘parent’ => $rows[categoryParentID], ‘name’ => $rows

33. [categoryName]);

34. }
35. if (!isset($category_array[$category_id]))
36. {
37. return “”;
38. }
39. foreach($category_array[$category_id] AS $key => $category)
40. {
41. if ($category['id'] == $default_category)
42. {
43. echo “}else
44. {
45. echo “}

46. if ($level > 0)

47. {
48. echo “>” . str_repeat( ” “, $level ) . ” ” . $category['name'] . “\n”;
49. }
50. else
51. {
52. echo “>” . $category['name'] . “\n”;
53. }
54. Get_Category($key, $level + 1, $default_category);
55. }
56. unset($category_array[$category_id]);
57. }

58. /*

59. 函数返回的数组格式如下所示:
60. Array
61. (
62. [1] => Array ( [id] => 1 [name] => 一级类别 [level] => 0 [ParentID] => 0 )
63. [4] => Array ( [id] => 4 [name] => 二级类别 [level] => 1 [ParentID] => 1 )
64. [9] => Array ( [id] => 9 [name] => 哈哈 [level] => 2 [ParentID] => 4 )
65. [3] => Array ( [id] => 3 [name] => 二级类别 [level] => 1 [ParentID] => 1 )
66. [8] => Array ( [id] => 8 [name] => aqqqqqd [level] => 2 [ParentID] => 3 )
67. [2] => Array ( [id] => 2 [name] => 二级类别 [level] => 1 [ParentID] => 1 )
68. [7] => Array ( [id] => 7 [name] => 234234 [level] => 2 [ParentID] => 2 )
69. [6] => Array ( [id] => 6 [name] => 333332 [level] => 2 [ParentID] => 2 )
70. [5] => Array ( [id] => 5 [name] => 三级类别 [level] => 2 [ParentID] => 2 )
71. [10] => Array ( [id] => 10 [name] => 66333666 [level] => 3 [ParentID] => 5 )
72. )
73. */
74. //指定分类id,然后返回数组
75. function Category_array($category_id = 0,$level=0)
76. {
77. global $DB;
78. $sql = “SELECT * FROM category ORDER BY categoryID DESC”;
79. $result = $DB->query($sql);
80. while ($rows = $DB->fetch_array($result))
81. {
82. $category_array[$rows['categoryParentID']][$rows['categoryID']] = $rows;
83. }

84. foreach ($category_array AS $key=>$val)

85. {
86. if ($key == $category_id)
87. {
88. foreach ($val AS $k=> $v)
89. {
90. $options[$k] =
91. array(
92. ‘id’ => $v['categoryID'], ‘name’ => $v['categoryName'], ‘level’ => $level, ‘ParentID’=>$v['categoryParentID']
93. );

94. $children = Category_array($k, $level+1);

95. if (count($children) > 0)

96. {
97. $options = $options + $children;
98. }
99. }
100. }
101. }
102. unset($category_array[$category_id]);
103. return $options;
104. }
105. ?>

复制代码

3. class cate

4. {

5. function Get_Category($category_id = 0,$level = 0, $default_category = 0)

6. {
7. echo $category_id;
8. $arr = array(
9. ’0′ => array(
10. ’1′ => array(‘id’ => 1, ‘parent’ => 0, ‘name’ => ’1111′),
11. ’2′ => array(‘id’ => 2, ‘parent’ => 0, ‘name’ => ’2222′),
12. ’4′ => array(‘id’ => 4, ‘parent’ => 0, ‘name’ => ’4444′)
13. ),
14. ’1′ => array(
15. ’3′ => array(‘id’ => 3, ‘parent’ => 1, ‘name’ => ’333333′),
16. ’5′ => array(‘id’ => 5, ‘parent’ => 1, ‘name’ => ’555555′)
17. ),

18. ’3′ => array(

19. ’6′ => array(‘id’ => 6, ‘parent’ => 3, ‘name’ => ’66666′),
20. ’7′ => array(‘id’ => 7, ‘parent’ => 3, ‘name’ => ’77777′)
21. ),
22. ’4′ => array(
23. ’8′ => array(‘id’ => 8, ‘parent’ => 4, ‘name’ => ’8888′),
24. ’9′ => array(‘id’ => 9, ‘parent’ => 4, ‘name’ => ’9999′)
25. )
26. );

27. if (!isset($arr[$category_id]))

28. {
29. return “”;
30. }

31. foreach($arr[$category_id] AS $key => $cate)

32. {
33. if ($cate['id'] == $default_category)
34. {
35. $txt = “}else{
36. $txt = “}

37. if ($level > 0)

38. {
39. $txt1 = “>” . str_repeat( “-”, $level ) . ” ” . $cate['name'] . “\n”;
40. }else{
41. $txt1 = “>” . $cate['name'] . “\n”;
42. }
43. $val = $txt.$txt1;
44. echo $val;
45. self::Get_Category($key, $level + 1, $default_category);
46. }
47. }

48. function getFlush($category_id = 0,$level = 0, $default_category = 0)

49. {
50. ob_start();
51. self::Get_Category($category_id ,$level, $default_category);
52. $out = ob_get_contents();
53. ob_end_clean();
54. return $out;
55. }
56. }
57. $id =$_GET['id'];
58. echo “”;
59. $c = new cate();
60. //$c->Get_Category();
61. $ttt= $c->getFlush($id,’0′,’3′);
62. echo $ttt;
63. echo “”;
64. ?>

复制代码