PHP使用递归生成文章树_PHP教程

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

26

27

28

29

30

31

32

33

34

35

36

37

38

function category_tree($fatherid){

//require_once("mysql_class/config.inc.php");

//require_once("mysql_class/Database.class.php");

$db = new Database(DB_SERVER, DB_USER, DB_PASS, DB_DATABASE);

$db->connect();

$sql = "SELECT id,title,url FROM ".TABLE_TASK."

WHERE fatherid=$fatherid and ispublic=1 order by id asc";

$articles = $db->query($sql);

$db->close();

while ($record = $db->fetch_array($articles)){

$i = 0;

if ($i == 0){

if($fatherid==0){

echo '

';

}else{

echo '

';

}

 

}

if($fatherid==0){

echo '

• aria-hidden="true" id="han'.$record['id'].'">

  '

  . $record['title'].'

  ';

  }else{

  echo '

• '

  . $record['title'].'

  ';

  }

   

  category_tree($record['id']);

  echo '

';

$i++;

if ($i > 0){

echo '

';

}

}

}

1

category_tree(0) //先提取最顶层文章