php - php mysql 中的 Bootstrap 导航

Question

我之前有过导航树，如下图:

<?php               
          $main=mysql_query("SELECT * FROM mainmenu WHERE aktif='Y'");

          while($r=mysql_fetch_array($main)){
             echo "<li><a href='$r[link]'><span>$r[nama_menu]</span></a>";
             $sub=mysql_query("SELECT * FROM submenu, mainmenu  
                        WHERE submenu.id_main=mainmenu.id_main 
                        AND submenu.id_main=$r[id_main] AND submenu.id_submain=0 AND submenu.aktif='Y'");
           $jml=mysql_num_rows($sub);
            // if submenu found                
            if ($jml > 0){
              echo "<div><ul>";                 
                while($w=mysql_fetch_array($sub)){
                echo "<li><a href='$w[link_sub]' class='parent'><span>&#187; $w[nama_sub]</span></a>";
                      $sub2 = mysql_query("SELECT * FROM submenu WHERE id_submain=$w[id_sub] AND id_submain!=0");
                $jml2=mysql_num_rows($sub2);
                if ($jml2 > 0){
                              echo "<div><ul>";
                         while($s=mysql_fetch_array($sub2)){
                            echo "<li><a href='$s[link_sub]'>&#187; $s[nama_sub]</a></li>";
                         }
                        echo "</ul></div></li>";
                      }
                }           

             echo "</li></ul></div>
                   </li>";
            }
            else{
              echo "</li>";
            }
          }        
        ?>

那么我也有一个数据库，如下:

SQL

如何将导航树转化为bootstrap？提前致谢

Answer 1

我已经修改了您的代码以适应 Bootstrap

导航 Bootstrap 标记

 <ul class="nav navbar-nav">
    <li class="active"><a href="#">Home</a></li> 
    <li class="dropdown">
      <a href="#" class="dropdown-toggle" data-toggle="dropdown">Dropdown <b class="caret"></b></a>
      <ul class="dropdown-menu">
         <li><a href="#">Action</a></li>
         <li><a href="#">Another action</a></li>
      </ul>
    </li>           
 </ul>

这是 php 代码

$main=mysql_query("SELECT * FROM mainmenu WHERE aktif='Y'");

      while ($r = mysql_fetch_array($main)) {

$sub = mysql_query("SELECT * FROM submenu, mainmenu  
                    WHERE submenu.id_main=mainmenu.id_main 
                    AND submenu.id_main=$r[id_main] AND submenu.id_submain=0 AND submenu.aktif='Y'");
$jml = mysql_num_rows($sub);

$dropdown = ($jml > 0) ? 'class="dropdown"' : ''; 
echo "<li $dropdown><a href='$r[link]'>$r[nama_menu]";

// if submenu found
if ($jml > 0) {
    echo "<b class="caret"></b><ul class="dropdown">";
    while ($w = mysql_fetch_array($sub))
        {
        echo "<li><a href='$w[link_sub]' class='parent'><span>&#187; $w[nama_sub]</a>";
        $sub2 = mysql_query("SELECT * FROM submenu WHERE id_submain=$w[id_sub] AND id_submain!=0");
        $jml2 = mysql_num_rows($sub2);
        if ($jml2 > 0)
            {
            echo "<ul $dropdown>";
            while ($s = mysql_fetch_array($sub2))
                {
                echo "<li><a href='$s[link_sub]'>&#187; $s[nama_sub]</a></li>";
                }

            echo "</ul></li>";
            }
        }

    echo "</li></ul>
               </li>";
    }
  else
    {
    echo "</a></li>";
    }
  }