ansaurus

Question

Answer 1

A:

You need to implement a recursive function or use a function like array_map with a callback function to process multi-array while sending back appropriate data, you can see more info about that function at php.net site.

Sarfraz 2009-12-11 12:12:03

Answer 2

+1 A:

This solution involves recursion. If you are not familiar with the term or have a hard time following along, please refer to this IBM entry entitled "Mastering recursive programming" to familiarize yourself. It seems as though you only plan on having three levels of navigation. With that being said, this code only handles the classnames parent/child/grandchild for those three levels. You can easily add more by adding new array entries to $depthClassMapping.

/**
 * @param array $level The current navigation level array
 * @param string $output The output to be added to
 * @param int $depth The current depth of the tree to determine classname
 */
function generateRowsByLevel($level, &$output, $depth = 0) {

    $depthClassMapping = array(0 => 'parent', 1 => 'child', 2 => 'grandchild');

    foreach ($level as $row) {
        $output .= "<tr class=\"" . $depthClassMapping[$depth] . "\" valign='top'>\n";
        $output .= "<td>". $row['id']."</td>\n";
        $output .= '<td><a href="'. site_url(). '/admin/menus/submenus/' .  $row['id'] . '">' . $row['name']."</a></td>\n";
        $output .= "<td align='center'>". $row['status']."</td>\n";
        $output .= "<td align='center'>". $row['parentid']."</td>\n";
        $output .= "<td align='center'>";
        $output .= anchor('admin/menus/editMenu/'. $row['id'],'edit');
        $output .= " | ";
        $output .= anchor('admin/menus/deleteMenu/'. $row['id'],'delete', array('class' => 'delete_link'));
        $output .= "</td>\n";
        $output .= "</tr>\n";

        // if the row has any children, parse those to ensure we have a properly 
        // displayed nested table
        if (!empty($row['children'])) {
            generateRowsByLevel($row['children'], $output, $depth + 1);
        }
    }
}

//==================
// RUN THE GENERATOR 
//==================
if (count($navlist)){

    // begin table
    $output = "<table border='1' cellspacing='0' cellpadding='3' width='800'>\n";
    $output .= "<thead>\n<tr valign='top'>\n";
    $output .= "<th>ID</th>\n<th>Name</th><th>Status</th><th>parentid</th><th>Actions</th>\n";
    $output .= "</tr>\n</thead>\n<tbody>\n";

    // generate all table rows
    generateRowsByLevel($navlist, $output);

    // close up the table
    $output .= "</tbody>\n</table>";

    // display table
    echo $output;
}

cballou 2009-12-11 13:04:00

I changed += to .= and $depthClasMapping[$depth] to $depthClassMapping[$depth]. then it works. Thanks.

shin 2009-12-11 16:09:13

I must've been thinking about javascript this morning with the `+=`

cballou 2009-12-11 16:12:39

Answer 3

A:

Your logic is too flat and flawed. Make use of functions and recursion. You may find this blog useful as well: http://crisp.tweakblogs.net/blog/317/formatting-a-multi-level-menu-using-only-one-query.html

BalusC 2009-12-11 13:08:10

ansaurus

tags:

views:

answers:

Multi-level Array to a table

related questions