Echo menu tree with recursive function

by

How about:

function recurse($categories, $parent = null, $level = 0)
{
    $ret="<ul>";
    foreach($categories as $index => $category)
    {
        if($category['root'] == $parent)
        {
            $ret .= '<li><a href="#"><p class="Tier' . $level . '">' . $category['name'] . '</p></a>';
            $ret .= $this->recurse($categories, $category['id'], $level+1);
            $ret .= '</li>';
        }
    }
    return $ret . '</ul>';
}

This function requires that you first query your database for the entire list of available categories and assumes that your root categories have a value of null, but the function can be changed to accept -1 or 0 depending on how your current schema works.

$categories = { get from database into an multi-dimensional array };
$Tree = $this->recurse($categories);
echo $Tree;

You may consider doing the following to prevent any empty UL’s appearing when no children exist for the parent:

function recurse($categories, $parent = null, $level = 0)
{
    $ret="<ul>";
    foreach($categories as $index => $category)
    {
        if($category['root'] == $parent)
        {
            $ret .= '<li><a href="#"><p class="Tier' . $level . '">' . $category['name'] . '</p></a>';
            $sub = $this->recurse($categories, $category['id'], $level+1);
            if($sub != '<ul></ul>')
                $ret .= $sub;
            $ret .= '</li>';
        }
    }
    return $ret . '</ul>';
}

However, the best solution, would be to select your data to include a column containing how many child categories each category has.

select Category.*, (select count(distinct c1.id) from Category as c1 where c1.root = Category.id) as ChildCount from Category

In which your function would be:

function recurse($categories, $parent = null, $level = 0)
{
    $ret="<ul>";
    foreach($categories as $index => $category)
    {
        if($category['root'] == $parent)
        {
            $ret .= '<li><a href="#"><p class="Tier' . $level . '">' . $category['name'] . '</p></a>';
            if($category['ChildCount'] > 0)
                $ret .= $this->recurse($categories, $category['id'], $level+1);
            $ret .= '</li>';
        }
    }
    return $ret . '</ul>';
}

Hope that helps?

More Related Contents:

  1. Getting links from db and displaying them in another div [closed]
  2. HTML Form/PHP connected but MySQL is empty
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Php charset information [duplicate]
  5. Save the data into a database and return another value from database using PHP
  6. Math Symbol From Mysql To HTML? [closed]
  7. Thank you for helping [closed]
  8. Is the following code valid? [closed]
  9. How to insert images into a database using PHP [closed]
  10. How to retrieve images from MySQL database and display in an html tag
  11. Preserve Line Breaks From TextArea
  12. HTML – Change\Update page contents without refreshing\reloading the page
  13. Delete multiple rows by selecting checkboxes using PHP
  14. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  15. How to add a delete button to a PHP form that will delete a row from a MySQL table
  16. Dynamic table in HTML using MySQL and php
  17. display data from SQL database into php/ html table [closed]
  18. Sending HTML Code Through JSON
  19. Javascript function post and call php script
  20. PHP – Secure member-only pages with a login system
  21. PHP: Inserting Values from the Form into MySQL
  22. onbeforeprint() and onafterprint() equivalent for non IE browsers
  23. Creating dynamic tables in HTML using MySQL and PHP
  24. recursive function to get all the child categories
  25. Turkish characters are not displayed correctly [duplicate]
  26. Get sum from nodes tree
  27. mysql_fetch_array skipping first row
  28. Displaying BLOB image from Mysql database into dynamic div in html
  29. Using PHP to upload file and add the path to MySQL database
  30. MySQL PHP – SELECT WHERE id = array()? [duplicate]

Leave a Comment