php - 数据放入下拉列表

我想从MySQL获取数据并将其插入到我的导航栏中。我的问题是某些数据必须放在下拉菜单下，但会创建一个新的主列表项。

这是屏幕快照，现在看起来是这样，但是我想在下拉菜单中插入Panel列。

    <?php
     $query  =   $connect->prepare("SELECT * FROM `ucp_navbar` WHERE `Kategorie` = 0");
     $query->execute();
    ?>

<div class='collapse navbar-collapse' id='bs-example-navbar-collapse-1'>
<ul class='nav navbar-nav'>
    <?php while ($row = $query->fetch()) { echo $row["Panel"]; if($row["Panel"] == 0) { ?>
        <li <?php if($page_a == $row["Active"]) echo "class='active nav-active'"; ?>>
            <a href='<?php echo htmlentities($row["Link"]); ?>'><i class='fa fa-<?php echo htmlentities($row["Icon"]); ?>' aria-hidden='true'></i> <?php echo htmlentities($row["Name"]); ?></a>
        </li><?php } ?>

        <?php if($row["Panel"] != 0 && $row["Panel"] == 1) { ?>
        <li class='dropdown'>
            <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false"><i class='fa fa-user' aria-hidden='true'></i> Account<span class="caret"></span></a>
            <ul class="dropdown-menu">
                <li>
                    <a href='<?php echo htmlentities($row["Link"]); ?>'><i class='fa fa-<?php echo htmlentities($row["Icon"]); ?>' aria-hidden='true'></i> <?php echo htmlentities($row["Name"]); ?></a>
                </li>
            </ul>
        </li>
    <?php } } ?>
</ul>

我的数据库结构：

最佳答案

我认为您遇到的问题是您对待子菜单的方式与主要导航栏项目相同。下面是一个可能的解决方案，我已经进行了一些繁重的格式重构，以尝试将逻辑部分放在顶部，以便使解决方案更加清晰。我倾向于同意早期的评论者（@Scott）的观点，即从长远来看，创建表的父子关系将是更可维护的做法。

<?php
// Make query
$query = $connect->prepare("SELECT * FROM `ucp_navbar` WHERE `Kategorie` = 0");
$query->execute();

// Setup containers for list items
$nav = array();
$dropdown = array();

// Iterate query
while ($row = $query->fetch()) {
  // Assign built list item to either navbar or dropdown arrays
  switch ($row['Panel']) {
    case 0:
      $nav[] = buildListItem(
        htmlentities($row['Link']),
        htmlentities($row['Icon']),
        echo htmlentities($row["Name"]),
        true
      );
      break;
    case 1:
      $dropdown[] = buildListItem(
        htmlentities($row['Link']),
        htmlentities($row['Icon']),
        echo htmlentities($row["Name"])
      );
  }
}

// Add dropdowns to main nav and convert array of nav items to string.
$nav[] = buildDropdown($dropdowns);
$navbar = implode("", $nav);

/**
 * Builds an individual list item.
 *
 * @param string $link URL to use for href
 * @param string $icon font-awesome icon to use
 * @param string $name display name for navbar
 * @param bool   $active adds nav-active class when true
 *
 * @return string formatted single list item
 */
function buildListItem($link, $icon, $name, $active = false)
{
  $class = ($active) ? ' class="active nav-active"': ""
  return "<li{$class}><a href=\"{$link}\"><i class=\"fa fa-{$icon}\" aria-hidden=\"true\"></i>{$name}</a></li>";
}

/**
 * Construct dropdown list item.
 *
 * @param array $dropdowns group of dropdown list items
 *
 * @return string formatted dropdown list for navbar
 */
function buildDropdown($dropdowns)
{
  $list = implode("", $dropdowns);
  return <<<EOT
  <li class='dropdown'>
      <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-haspopup="true" aria-expanded="false">
        <i class='fa fa-user' aria-hidden='true'></i>
        Account<span class="caret"></span>
      </a>
      <ul class="dropdown-menu">
          $list
      </ul>
  </li>
EOT;
}
?>

<div class='collapse navbar-collapse' id='bs-example-navbar-collapse-1'>
<ul class='nav navbar-nav'>
   <?php echo $navbar; ?>
</ul>

关于php - 数据放入下拉列表，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/43031834/