2 $result = $this->db
->safe_query_fetch('SELECT * FROM category');
4 function addleaf(&$tree, $levels, $id, $category='') {
9 $current = array_shift($levels); //echo("$current ".count($levels)."");
10 $category .= '/'.$current;
11 if(!isset($tree[$current])) $tree[$current] = array();
12 $tree[$current]['__PATH__'] = $category;
13 //if(!count($levels)) $tree[$current]['__ID__'] = $id; //echo "($current $id)\n";
14 addleaf($tree[$current], $levels, $id, $category);
18 foreach($result as $row) {
19 $row_parts = preg_split('/\//', $row['category_name']);
20 //echo($row['category_name'].$row['category_id']."\n");
21 addleaf($tree, $row_parts, $row['category_id']);
24 function render_tree($tree, $index_path='__PATH__', $index_id='__ID__') {
25 if(!is_array($tree)) return '';
27 foreach($tree as $name => $subtree) if($name != $index_path && $name != $index_id) {
28 @$html.='<li><b>'.$name.'</b> <small>('.$subtree[$index_id].' => '.$subtree[$index_path].')</small>'.render_tree($subtree).'</li>';
33 echo render_tree($tree);
This page took 0.470795 seconds and 5 git commands to generate.