Get recursive menu from database

[eluser]Dam1an[/eluser]
Ok, here's some quick code I've mocked up

Code:

<?php
class Test extends Controller {
    function index() {
        $menu = Test::create_nested_menu();
        
        print_r($menu);
    }
    
    function create_nested_menu($parent = 0) {
        $items = array();
        
        $this->db->where('parent', $parent);
        $query = $this->db->get('menu_items');
        $results = $query->result();
        
        foreach($results as $result) {
            $child_array = Test::create_nested_menu($result->id);
            if(sizeof($child_array) == 0) {
                array_push($items, $result->label);
            } else {
                array_push($items, array($result->label, $child_array));
            }
        }
        
        return $items;
    }
}
?>

and with the array in your example, it would generate the following array

Code:

Array (
    [0] => Label 1
    [1] => Array (
        [0] => Label 2
        [1] => Array (
            [0] => Array (
                [0] => Label 2.1
                [1] => Array (
                    [0] => Label 2.1.1
                )
            )
            [1] => Label 2.2
        )
    )
    [2] => Label 3
    [3] => Label 4
)

You'll obviously want to move the function into a helper, but you get the idea (hopefully)
If not, I'll explain it in detail