时间戳

首页 > 解决方案 > 产品最佳动态菜单 3 标签 php mysqli

php - 产品最佳动态菜单 3 标签 php mysqli

问题描述

我有我发出 3rd lebel 菜单未打印，但主菜单和子菜单正在工作，所以请帮助我

表名“romtech”

  1. 类别->cat_id，categories_name；

  2. sub_categories ->sub_id , cat_id, sub_categories_name;

  3. sub_child_categories ->ch_id , sub_id , cat_id, child_categories_name;

PHP 代码

<div class="cat_menu_container">
    <div class="cat_menu_title d-flex flex-row align-items-center justify-content-start">
        <div class="cat_burger"><span></span><span></span><span></span></div>
        <div class="cat_menu_text">categories</div>
    </div>
    <ul class="cat_menu">
        <!-----------------------sql error set liimit 5 and order by desc not working please check its sir---------------------------->
        <?php $menu=$conn->query("SELECT * FROM categories WHERE cat_status='1' and order by cat_id limit 5"); while($row=$menu->fetch_array()){?>
        <li class="hassubs"><a href="categories.php?cat_id=<?php echo $row['cat_id']; ?>"><?php echo $row['categories_name']; ?><i class="fas fa-chevron-right ml-auto"></i></a>


            <!-----------Second ------------------>
            <?php $sub=$conn->query("SELECT * FROM sub_categories WHERE sub_cat_status ='1' and cat_id=".$row['cat_id']);?>
            <ul> 
                <?php while($menu_row=$sub->fetch_array()){ ?>
                <li class="hassubs"><a href="categories.php?sub_id=<?php echo $menu_row['sub_id']; ?>"><?php echo $menu_row['sub_categories_name']; ?><i class="fas fa-chevron-right ml-auto"></i></a>


                    <!-----------third -issue part----------------->
                    <?php $child=$conn->query("SELECT * FROM sub_child_categories WHERE sub_id =".$row['sub_id'] AND cat_id =.$row['cat_id']);?>
                    <ul> 
                        <?php while($child_row=$child->fetch_array()){ ?>
                        <li class="hassubs"><a href="categories.php?sub_id=<?php echo $child_row['ch_id']; ?>"><?php echo $child_row['child_categories_name']; ?><i class="fas fa-chevron-right ml-auto"></i></a>
                        </li>
                    <?php } ?>
                    </ul>

                    <!-----------third ----end-------------->


                </li>
                <?php } ?>
            </ul>
          <!-----------Second ----end-------------->


        </li>
        <?php } ?>
    </ul>
</div>

标签： phphtml

解决方案

第三级查询是

$child=$conn->query("SELECT * FROM sub_child_categories WHERE sub_id =".$menu_row['sub_id']."");

利用

`sub_id =".$menu_row ['sub_id']`

或者

 `sub_id =".$menu_row ['sub_id']` AND cat_id=$row['cat_id']`

推荐阅读