dqwyghl0649 2017-10-24 10:34 采纳率: 0%
浏览 70
已采纳

使用php和数据库的Bootstrap下拉列表

I have a problem with drop down menu using twitter bootstrap. In my database I have table called categories. In it I have 8 records:

ID | Category | parent
1  | Apple    | 0
2  | Samsung  | 0
3  | Huawei   | 0
4  | Others   | 0
5  | Sony     | 4
6  | LG       | 4
7  | Lenovo   | 4
8  | Nokia    | 4

By using this data I have created a navbar. However I have this problem: Since 'others' have parent, they appear in their parents dropdown. Apple, Samsung and Huawei does not have any children so I would like them to not have a dropdown at at all. However my code generates an empty dropdown for these categories.

<body>
<?php
    $sql = "SELECT * FROM categories WHERE parent = 0";
    $pquery = $db->query($sql);
  ?>
  <nav class="navbar navbar-default navbar-fixed-top" id="navbar">
    <div class="container">
      <a href="/e-shop/index.php" class="navbar-brand" id="logo">Mobile e-shop</a>
      <ul class="nav navbar-nav">
        <?php while($parent = mysqli_fetch_assoc($pquery)) : ?>
        <?php
          $parent_id = $parent['id'];
          $sql2 = "SELECT * FROM categories WHERE parent = '$parent_id' ";
          $cquery = $db->query($sql2);
        ?>

<!-- Drop down meniu -->
        <li class="dropdown">
          <a href="#" class="dropdown-toggle" data-toggle="dropdown" id="text"><?php echo $parent['kategorija']; ?><span class="caret"></span></a>
          <ul class="dropdown-menu" role="menu">
            <?php while($child = mysqli_fetch_assoc($cquery)) : ?>
            <li>
            /*I assume i should do if statement or something here to check is its null? I tryied to use is_null() but it did not work for me*/
              <a href="<?=$child['adresas']; ?>">
                <?php echo $child['kategorija'] ?>
              </a>
            </li>
          <?php endwhile; ?>
          </ul>
        </li>
      <?php endwhile; ?>
      </ul>
    </div>
  </nav>

I assume i should do if statement or something to check is its null? I tryied to use is_null() but it did not work for me.

</div>
  • 写回答

1条回答 默认 最新

  • donglu1971 2017-10-24 12:31
    关注

    I see your issue. You're getting all the items without parent and give them the same function, which means they all get assigned a parent class.

    Basically, you need to find the parents that have children and then assign the correct class to them. Like so:

    <?php
  // Check if the child-query result is larger than 0
  if(mysqli_num_rows($cquery) > 0) {
    // Run your code for 'parents' here.
    <li class="dropdown">
    </li>
  } else {
    // Run your code for 'noparents' here.
    <li class="nodropdown">
    </li>
  }
?>

    If I were you, I would also prepare the statements in clean PHP code, so you only have to call some variables in the HTML. This makes your code much more readable. In the below example, you have the database call and the transforming code all in one place. In case you change one, you'd probably have to change the other, so it makes sense. Also, if someone else looks at your code, they understand it much quicker.

    <li class="dropdown">
    <a href="#" class="dropdown-toggle" data-toggle="dropdown" id="text">
        <?php echo $parent['kategorija']; ?><span class="caret"></span>
    </a>
    <ul class="dropdown-menu" role="menu">
        <?php echo get_dropdown_children(); ?>
    </ul>
<li>

<?php
function get_dropdown_children($parent['id']) {
    $sql2 = "SELECT * FROM categories WHERE parent = '$parent_id' ";
    $cquery = $db->query($sql2);
    $result = "";

    while($child = mysqli_fetch_assoc($cquery)) {
        $result .= "<li><a href='" . $child['adresas'] . "'>";  // Opening tags
        $result .= $child['kategorija'];                        // Content
        $result .= "</a></li>";                                 // Closing tags
    }

    return $result;
}
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？

  • Bootstrap_purpose_php_
    2021-10-01 14:14
    Bootstrap是世界上最受欢迎的前端开发框架之一，主要用于快速构建响应式和移动优先的网站。这个名为"Bootstrap_purpose_php_"的压缩包文件似乎包含了与Bootstrap框架在PHP环境中的应用相关的资源，特别是一个名为...
  • php bootstrap下拉菜单高度,小蚂蚁学习Bootstrap（1）——导航条的设置和下拉菜单...
    2021-05-08 12:05
    weixin_39939918的博客 前两天在动弹里看到有人吐槽，话说什么一个java程序员什么都要做，HTML、js、数据库等，我想说的是，php程序员才是这样的呢，前端程序员不一定要懂后端的技术，但是后端的程序员是一定要懂前端的技术。就用这几天的...
  • 前端BootStrap与LayUI框架
    2022-11-05 20:56
    也້໌ᮨ的博客 前端BootStrap与LayUI
  • springboot+bootstrap博客系统源码
    2022-12-10 01:49
    通过阅读和分析源码，可以深入了解Spring Boot的自动配置、AOP、RESTful API设计，以及Bootstrap的响应式布局和组件使用。这对于提升Web开发技能，尤其是微服务架构和前端框架的应用有极大的帮助。
  • ThinkPhp5+bootstrap搭建个人博客网站
    2021-12-31 22:27
    例如，使用Bootstrap的网格系统构建文章列表，用模态框处理用户登录和注册，以及使用下拉菜单实现标签筛选。 7. **服务器配置**：项目运行需要Apache或Nginx服务器支持。Apache和Nginx是常见的Web服务器，它们可以...
  • 3107大气宽屏网站建设公司bootstrap模板5020_企业网站模板PHP整站源码.zip.7z
    2023-08-01 17:24
    在使用此模板时，开发者应具备一定的HTML、CSS、JavaScript和PHP基础，理解Bootstrap框架的工作原理，并熟悉MySQL等数据库管理系统。同时，确保遵循模板的许可协议，尊重原创并合理使用。 总的来说，"3107大气宽屏...
  • 一款基于thinkphp+bootstrap开发的开源博客系统
    2024-06-05 17:06
    标题中的“一款基于thinkphp+bootstrap开发的开源博客系统”表明了这个项目是一个采用流行的PHP框架ThinkPHP和前端UI框架...开发者可以通过学习和使用这个系统，深入了解PHP开发、前端设计以及数据库管理等多方面技能。
  • 可编辑的下拉列表框
    2019-03-18 01:59
    在压缩包子文件“editable xlk.php”中，"editable"可能指的是这个文件是关于可编辑功能的，而"xlk.php"可能是一个PHP脚本文件，用于处理与前端交互的数据，例如接收用户在可编辑下拉列表框中输入的信息，进行验证、...
  • 午后咖啡休闲bootstrap模板
    2021-04-02 10:32
    午后咖啡休闲bootstrap模板是一款专为咖啡馆、休闲场所设计的网站模板，基于流行的前端框架Bootstrap构建，旨在提供一个美观、易用且响应式的网站设计方案。Bootstrap是由Twitter开发并开源的一款前端开发工具，它...
  • bootstrap商城模板效果
    2022-06-06 10:55
    在实际应用中，开发者需要根据自己的服务器环境和后台系统（如PHP、Node.js等）对模板进行适配，并与数据库连接，实现动态数据的展示和交互。同时，考虑到SEO优化，还需要处理好元标签、URL结构等细节。总的来说，...
  • 没有解决我的问题, 去提问