|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
<?php
$conn
= mysql_connect(
"localhost"
,
"root"
,
"1234"
);
mysql_select_db(
"laaho_caike"
);
$option
= getTree(0);
$option
=
"<select name='term'>"
.
$option
.
"</select>"
;
echo
$option
;
function
getTree(
$id
,
$spac
=0) {
//static $str;
$spac
=
$spac
+ 2;
static
$str
;
$sql
=
"select * from videoterm where parent_id='"
.
$id
.
"'"
;
$res
= mysql_query(
$sql
);
//$arr = mysqli_fetch_assoc($res);
while
(
$arr
=mysql_fetch_assoc(
$res
)) {
$str
.=
"<option value="
.
$arr
[
'Id'
] .
">"
.
str_repeat
(
' '
,
$spac
) .
"|--"
.
$arr
[
'termname'
] .
"</option>"
;
getTree(
$arr
[
'Id'
],
$spac
);
}
return
$str
;
}
?>
|
效果如图
本文转自 陈小龙哈 51CTO博客，原文链接:http://blog.51cto.com/chenxiaolong/1720847
