<?php
// session_start();
error_reporting(E_ERROR | 1);
$se = $_SESSION["id"];
if (!isset($_SESSION['id'])) {
    // header("Location: login.php");
}
include("admin/includes/config.php");
 
?>


<style>
   .dropdown-menu {
    position: absolute;
    display: none;
    list-style: none;
    background-color: #fff;
    padding: 10px;
    border: 1px solid #ccc;
    z-index: 1000;
}

.dropdown:hover > .dropdown-menu {
    display: block;
}

.sub-menu {
    position: absolute;
    left: 100%;
    top: 0;
    width: 207px;
    display: none;
    list-style: none;
    background-color: #fff;
    padding: 10px;
    border: 1px solid #ccc;
    border-bottom: solid 1px
}

.dropdown-submenu:hover > .sub-menu {
    display: block;
}

</style>

<header id="header">
            <!-- Start Navigation -->
            <nav class="navbar navbar-default navbar-fixed white no-background bootsnav">
               <!-- Start Top Search -->
               <!-- <div class="top-search">
                  <div class="container">
                     <div class="input-group"> <span class="input-group-addon"><i class="fa fa-search"></i></span>
                        <input type="text" class="form-control" placeholder="Search">
                        <span class="input-group-addon close-search"><i class="fa fa-times"></i></span> 
                     </div>
                  </div>
               </div> -->
               <!-- End Top Search -->
               <div class="container">
                  <!-- Start Atribute Navigation -->
                  <div class="attr-nav">
                     <ul id="cart-dropdown">
                        <li class="dropdown">

                        <?php
                            $select_product = mysqli_query($conn,"select * from `cart`") or die('query faild');
                            $row_count = mysqli_num_rows($select_product);
                            
                        ?>
                           <a href="cart.php" class="dropdown-toggle" data-toggle="dropdown"> <i class="fa fa-shopping-bag"></i> <span class="badge"><?php echo $row_count; ?></span> </a>
                        
                        </li>

                      
                      
                        <?php                     
                                        if (isset($_SESSION['id'])) {
                                        // User is logged in, fetch user information
                                        $se = $_SESSION['id'];
                                        $query = "SELECT * FROM `users` WHERE id='$se'";
                                        $query_run = mysqli_query($conn, $query);
                                    
                                        if (mysqli_num_rows($query_run) > 0) {
                                            $row = mysqli_fetch_assoc($query_run);
                                            ?>
                                          <li class="dropdown">
                                            <a href="#"><?php echo $row['name'] ?></a>
                                            
                                            <ul class="dropdown-menu">
                                            <li><a href="user-profile.php">User Detail</Details></a></li>
                                        <li><a href="logout.php">Logout</a></li>
                                       
                                    </ul>
                                    </li>
                                            <?php
                                        }
                                    } else {
                                        // User is not logged in
                                        ?>   
                                 <li class="dropdown">
                                       <a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-user"></i></a>
                                    <ul class="dropdown-menu">
                                    <li><a href="login.php">Sign in</a></li>
                                    <!-- <li><a href="register.php">Register</a></li> -->
                                    <!-- <li><a href="user-profile.php">My Account</a></li> -->
                                    </ul>

                                    <?php } ?>
                                    </li>


                        
                        <!-- <li class="side-menu"><a href="#"><i class="fa fa-bars"></i></a></li> -->
                     </ul>
                  </div>
                  <!-- End Atribute Navigation --> 
                  <!-- Start Header Navigation -->
                  <div class="navbar-header">
                     <button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#navbar-menu"> <i class="fa fa-bars"></i> </button>
                     <a class="navbar-brand" href="index.php"> <img src="images/logo.png" class="logo logo-display" alt=""> <img src="images/logo.png" class="logo logo-scrolled" alt=""> </a> 
                  </div>
                  <!-- End Header Navigation --> 
                  <!-- Collect the nav links, forms, and other content for toggling -->
                  <div class="collapse navbar-collapse" id="navbar-menu">
                     <ul class="nav navbar-nav navbar-left pull-right" data-in="fadeInDown" data-out="fadeOutUp">
                        <li class="active"><a href="index.php">Home</a></li>
                        <li><a href="about.php">About Us</a></li>
                        <!-- <li><a href="shop.php">Products</a></li> -->

                        <li class="dropdown">
    <a href="#" class="dropdown-toggle" data-toggle="dropdown">Category</a>
    <ul class="dropdown-menu">
        <?php
        // Fetch subcategories
        $query = "SELECT * FROM scategories";
        $query_run = mysqli_query($conn, $query);

        if (mysqli_num_rows($query_run) > 0) {
            foreach ($query_run as $row) {
                $subcategory_id = $row['id'];
                $scategory_name = $row['scat_name'];

                // Fetch products for this subcategory
                $product_query = "SELECT * FROM products WHERE scategory_id = $subcategory_id";
                $product_query_run = mysqli_query($conn, $product_query);
                ?>
                <li class="dropdown-submenu">
                    <a href="#">
                        <?php echo $scategory_name; ?> <!-- Display the sub-category name -->
                    </a>
                    <?php if (mysqli_num_rows($product_query_run) > 0) { ?>
                        <ul class="sub-menu">
                            <?php foreach ($product_query_run as $product) { ?>
                                <li>
                                    <a href="product-detail.php?id=<?php echo $product['id']; ?>">
                                        <?php echo $product['product_name']; ?> <!-- Display the product name -->
                                    </a>
                                </li>
                            <?php } ?>
                        </ul>
                    <?php } ?>
                </li>
                <?php
            }
        }
        ?>
    </ul>
</li>

                        <li> <a href="shop.php">Today's Deals</a></li>
                        <li> <a href="shop.php">New Releases</a></li>
                        
                        
                        <li> <a href="contact.php">Contact us</a></li>
                        <!-- <li class="dropdown megamenu-fw">
                           <a href="category_page.html" class="dropdown-toggle" data-toggle="dropdown">Collection</a>
                           <ul class="dropdown-menu megamenu-content" role="menu">
                              <li>
                                 <div class="row">
                                    <div class="col-menu col-md-3">
                                       <h4 class="sub_title title mtb_10">Categories One</h4>
                                       <div class="content">
                                          <ul class="menu-col">
                                             <li><a href="#">Editors Picks</a></li>
                                             <li><a href="#">Wear To Work</a></li>
                                             <li><a href="#">The Basics</a></li>
                                             <li><a href="#">Top Sellers</a></li>
                                             <li><a href="#">Man</a></li>
                                             <li><a href="#">Women</a></li>
                                             <li><a href="#">Blouses Shirts</a></li>
                                             <li><a href="#">Dresses</a></li>
                                          </ul>
                                       </div>
                                    </div>
                                  
                                    <div class="col-menu col-md-3">
                                       <h4 class="sub_title title mtb_10">Categories Two</h4>
                                       <div class="content">
                                          <ul class="menu-col">
                                             <li><a href="#">Editors Picks</a></li>
                                             <li><a href="#">Wear To Work</a></li>
                                             <li><a href="#">The Basics</a></li>
                                             <li><a href="#">Top Sellers</a></li>
                                             <li><a href="#">Man</a></li>
                                             <li><a href="#">Women</a></li>
                                             <li><a href="#">Blouses Shirts</a></li>
                                             <li><a href="#">Sweaters</a></li>
                                          </ul>
                                       </div>
                                    </div>
                               
                                    <div class="col-menu col-md-3">
                                       <h4 class="sub_title title mtb_10">Categories Three</h4>
                                       <div class="content">
                                          <ul class="menu-col">
                                             <li><a href="#">Editors Picks</a></li>
                                             <li><a href="#">Wear To Work</a></li>
                                             <li><a href="#">The Basics</a></li>
                                             <li><a href="#">Top Sellers</a></li>
                                             <li><a href="#">Man</a></li>
                                             <li><a href="#">Women</a></li>
                                             <li><a href="#">Dresses</a></li>
                                             <li><a href="#">Sweaters</a></li>
                                          </ul>
                                       </div>
                                    </div>
                                    <div class="col-menu col-md-3">
                                       <ul>
                                          <li id="myCarousel" class="carousel slide" data-ride="carousel">
                                             <div class="carousel-inner">
                                                <div class="item active"> <a href="#"><img src="images/menu-banner1.jpg" class="img-responsive" alt="Banner1"></a></div>
                                             
                                                <div class="item"> <a href="#"><img src="images/menu-banner2.jpg" class="img-responsive" alt="Banner1"></a></div>
                                            
                                                <div class="item"> <a href="#"><img src="images/menu-banner3.jpg" class="img-responsive" alt="Banner1"></a></div>
                                              
                                             </div>
                                           
                                          </li>
                                          
                                       </ul>
                                    </div>
                                   
                                 </div>
                                
                              </li>
                           </ul>
                        </li> -->
                        <!-- <li class="dropdown">
                           <a href="category_page_left.html" class="dropdown-toggle" data-toggle="dropdown">Shop</a>
                           <ul class="dropdown-menu">
                              <li> <a href="category_page.html">4colunm</a></li>
                              <li> <a href="category_page_3col.html">3colunm</a></li>
                              <li> <a href="category_page_left.html">3colunm Left Sidebar</a></li>
                              <li> <a href="category_page_right.html">3colunm Right Sidebar</a></li>
                              <li> <a href="product_detail_page.html">Product Detail Page</a></li>
                              <li> <a href="product_detail_left.html">Product Detail Left Sidebar</a></li>
                              <li> <a href="product_detail_right.html">Product Detail Right Sidebar</a></li>
                           </ul>
                        </li> -->
                        <!-- <li class="dropdown">
                           <a href="#" class="dropdown-toggle" data-toggle="dropdown">Blgo</a>
                           <ul class="dropdown-menu">
                              <li> <a href="blog_page.html">Blog Page</a></li>
                              <li> <a href="single_blog.html">Single Blog Post</a></li>
                           </ul>
                        </li> -->
                        <!-- <li class="dropdown">
                           <a href="#" class="dropdown-toggle" data-toggle="dropdown">Page</a>
                           <ul class="dropdown-menu">
                              <li> <a href="login.html">Login/Register</a></li>
                              <li> <a href="contact_us.html">Contact us</a></li>
                              <li> <a href="cart_page.html">My Cart</a></li>
                              <li> <a href="checkout_page.html">Checkout</a></li>
                              <li> <a href="wishlist.html">Wishlist</a></li>
                           </ul>
                        </li> -->
                     
                     </ul>
                  </div>
                  <!-- /.navbar-collapse --> 
               </div>
               <!-- Start Side Menu -->
               <div class="side">
                  <a href="#" class="close-side"><i class="fa fa-times"></i></a>
                  <div class="widget">
                     <h6 class="title">My Account</h6>
                     <ul class="link">
                        <li><a href="account.html">My Account</a></li>
                        <li><a href="order.php">Order History</a></li>
                        <!-- <li><a href="category_page.html">Returns</a></li> -->
                        <!-- <li><a href="wishlist.html">My Wishlist</a></li> -->
                        <li><a href="checkout.php">Checkout</a></li>
                        <!-- <li><a href="contact.php">Contact Us</a></li> -->
                     </ul>
                     <!-- <hr class="mtb_10">
                     <ul class="link">
                        <li><a href="login.php"><i class="fa fa-lock left" aria-hidden="true"></i>Login</a></li>
                        <li><a href="register.php"><i class="fa fa-user left" aria-hidden="true"></i>Create an Account</a></li>
                     </ul> -->
                  </div>
                  <!-- <div class="widget">
                     <h6 class="title">English Language</h6>
                     <ul class="link">
                        <li><a href="#"><img src="images/English-icon.gif" alt="img"> English</a></li>
                        <li><a href="#"><img src="images/French-icon.gif" alt="img"> French</a></li>
                        <li><a href="#"><img src="images/German-icon.gif" alt="img"> German</a></li>
                     </ul>
                  </div> -->
                  <!-- <div class="widget">
                     <h6 class="title">USD Currency</h6>
                     <ul class="link">
                        <li><a href="#">€ Euro</a></li>
                        <li><a href="#">£ Pound Sterling</a></li>
                        <li><a href="#">$ US Dollar</a></li>
                     </ul>
                  </div> -->
               </div>
               <!-- End Side Menu --> 
            </nav>
            <!-- End Navigation --> 
         </header>