|
|
function getTree()
{
$sql = 'SELECT n.catID, n.catNAME, COUNT(*)-1 AS level FROM categories AS n, categories AS p WHERE n.leftNODE BETWEEN p.leftNODE AND p.rightNODE GROUP BY n.leftNODE ORDER BY n.leftNODE;';
$result = $db->query($sql);
if ($db->affected_rows == 0)
{
return 'Hata! Kategori Yok';
}
$tree = array();
$i = 0;
while ($row = $result->fetch_assoc())
{
$tree[$i] = $row;
$i++;
}
return $tree;
}
function treeAsHtml()
{
$tree = getTree();
$html = "<ul>\n";
for ($i=0; $i<count($tree); $i++)
{
$html .= "<li>" . $tree[$i]['catNAME'];
if ($tree[$i]['level'] < $tree[$i+1]['level'])
{
$html .= "\n<ul>\n";
} elseif ($tree[$i]['level'] == $tree[$i+1]['level'])
{
$html .= "</li>\n";
} else
{
$diff = $tree[$i]['level'] - $tree[$i+1]['level'];
$html .= str_repeat("</li>\n</ul>\n", $diff) . "</li>\n";
}
}
$html .= "</ul>\n";
return $html;
}
echo treeAsHtml();
 
|
 |
 |
 |
 |
Doğru Cevap
$diff = $tree[$i]['level'] - $tree[$i+1]['level'];