Advertisement
iftekharul

Dynamic Multilevel Menu for Bootstrap

Aug 2nd, 2018
1,029
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.24 KB | None | 0 0
  1. /* Dynamic Multilevel Menu (Implement the recursion logic)
  2.  * Tutorial: https://www.w3school.info/2015/12/22/steps-to-create-dynamic-multilevel-menu-using-php-and-mysql/
  3.  */
  4. function get_menu_tree($parent_id) {
  5.     global $con;
  6.     $menu = "";
  7.     $nav_arrow = "";
  8.     $sqlquery = " SELECT * FROM menu WHERE status='1' AND menu_type='main' AND parent_id='" .$parent_id . "' ";
  9.     $res = mysqli_query($con, $sqlquery);
  10.     while($row = mysqli_fetch_array($res, MYSQLI_ASSOC)) {
  11.         $menuid = $row['menu_id'];
  12.         $menutree = get_menu_tree($row['menu_id']);
  13.         if($menutree) {
  14.             $nav_arrow = " class='dropdown'";
  15.             $nav_tog = " class='dropdown-toggle' data-toggle='dropdown' role='button' aria-haspopup='true' aria-expanded='false'";
  16.             $caret = " <span class='caret'></span>";
  17.             $drop_menu = " class='dropdown-menu'";
  18.         } else {$nav_arrow = $nav_tog = $caret = $drop_menu = ""; }
  19.         if($menuid != 1) { $sronly = ""; } else { $sronly = " <span class='sr-only'>(current)</span>"; }
  20.         $menu .="<li$nav_arrow><a href='".$row['link']."'$nav_tog>".$row['menu_name'].$sronly.$caret;
  21.         if($menutree) {
  22.             $menu .= "</a><ul$drop_menu>".get_menu_tree($row['menu_id'])."</ul>"; //call  recursively
  23.         } else {
  24.             $menu .= "</a>";
  25.         }
  26.         $menu .= "</li>";
  27.     }
  28.     return $menu;
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement