Items en subitems
Code (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
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
<?php
$i = 0;
while ($db->nextRecord())
{
$pages[$i]["id"] = $db->f("id");
$pages[$i]["level"] = $db->f("level");
$pages[$i]["parent"] = $db->f("parent");
$pages[$i]["title"] = $db->f("title");
$pages[$i]["disabled"] = $db->f("disabled");
$i++;
}
foreach ($pages as $key)
{
echo "<tr><td>";
$spaceCounter = 0;
$spaces = NULL;
while ($spaceCounter < $key["level"])
{
$spaces .= " ";
$spaceCounter++;
}
echo $spaces.$key["title"];
echo "</td></td>\n";
}
?>
$i = 0;
while ($db->nextRecord())
{
$pages[$i]["id"] = $db->f("id");
$pages[$i]["level"] = $db->f("level");
$pages[$i]["parent"] = $db->f("parent");
$pages[$i]["title"] = $db->f("title");
$pages[$i]["disabled"] = $db->f("disabled");
$i++;
}
foreach ($pages as $key)
{
echo "<tr><td>";
$spaceCounter = 0;
$spaces = NULL;
while ($spaceCounter < $key["level"])
{
$spaces .= " ";
$spaceCounter++;
}
echo $spaces.$key["title"];
echo "</td></td>\n";
}
?>
http://articles.sitepoint.com/print/hierarchical-data-database