<?php include("admin/includes/config.php"); ?>

<!-- Offcanvas Menu Begin -->
   <div class="offcanvas-menu-overlay"></div>
    <div class="offcanvas-menu">
        <div class="offcanvas__logo">
            <a href="index.html"><img src="img/logo.png" alt=""></a>
        </div>
        <div id="mobile-menu-wrap"></div>
        <div class="offcanvas__widget">
            <ul>
                <li>CALL US: +91 8851319207</li>
                <li>WRITE US:  info@nidhitechnocare.com</li>
                <li>OPENING TIMES: MON - FRI: 9:00 - 19:00</li>
            </ul>
            <a href="#" class="primary-btn">Buy Now</a>
        </div>
        <nav class="header__menu">
            <ul class="mobile-menu">
                <li class="active"><a href="index.php">Home</a></li>
                <li><a href="about.php">About</a></li>


                  
    <?php
// Database connection (assumed $conn is already defined and connected)

// Fetch categories
$category_query = "SELECT * FROM categories WHERE id = 2";  // You can change the WHERE condition to get categories dynamically
$category_result = mysqli_query($conn, $category_query);

if (mysqli_num_rows($category_result) > 0) {
    while ($category = mysqli_fetch_assoc($category_result)) {
        echo '<li id="products-menu"><a href="#">' . htmlspecialchars($category['cat_name']) . '</a>';
        
        // Fetch subcategories for this category
        $subcategory_query = "SELECT * FROM scategories WHERE category_id = " . $category['id'];
        $subcategory_result = mysqli_query($conn, $subcategory_query);
        
        if (mysqli_num_rows($subcategory_result) > 0) {
            echo '<ul class="dropdown">';
            
            while ($subcategory = mysqli_fetch_assoc($subcategory_result)) {
                echo '<li><a href="#">' . htmlspecialchars($subcategory['scat_name']) . '</a>';
                
                // Fetch products for this subcategory
                $product_query = "SELECT * FROM products WHERE scategory_id = " . $subcategory['id'];
                $product_result = mysqli_query($conn, $product_query);
                
                if (mysqli_num_rows($product_result) > 0) {
                    echo '<ul class="submenu">';
                    
                    while ($product = mysqli_fetch_assoc($product_result)) {
                        echo '<li><a href="product-detail.php?id=' . $product['id'] . '">' . htmlspecialchars($product['product_name']) . '</a></li>';
                    }
                    
                    echo '</ul>';
                }
                
                echo '</li>';
            }
            
            echo '</ul>';
        }
        
        echo '</li>';
    }
} else {
    echo "No categories found.";
}
?>


               
                <li><a href="contact.php">Contact</a></li>
                <!-- <li><a href="blog.php">Blogs</a></li> -->
            </ul>
        </nav>
        <div class="offcanvas__social">
            <a href="#"><i class="fa fa-facebook"></i></a>
            <a href="#"><i class="fa fa-twitter"></i></a>
            <a href="#"><i class="fa fa-instagram"></i></a>
            <a href="#"><i class="fa fa-linkedin"></i></a>
        </div>
    </div>
    <!-- Offcanvas Menu End -->

    <!-- Header Section Begin -->
    <header class="header">
        <div class="header__top">
            <div class="container">
                <div class="row">
                    <div class="col-lg-3 col-md-3">
                        <div class="header__logo">
                            <a href="index.php"><img src="img/logo.png" alt=""></a>
                        </div>
                    </div>
                    <div class="col-lg-9 col-md-9">
                        <div class="header__top__widget">
                            <ul>
                                <li>CALL US: +91 8851319207</li>
                                <li>WRITE US: info@nidhitechnocare.com</li>
                                <li>OPENING TIMES: MON - FRI: 9:00 - 19:00</li>
                            </ul>
                            <a href="#" class="primary-btn">Buy Now</a>
                        </div>
                    </div>
                </div>
                <div class="canvas__open">
                    <i class="fa fa-bars"></i>
                </div>
            </div>
        </div>
        <div class="header__nav">
            <div class="container">
                <div class="row">
                    <div class="col-lg-12 col-md-9">
                        <nav class="header__menu">
                        <ul class="main-menu">
    <!-- Other Navigation Links -->
    <li><a href="index.php">Home</a></li>
    <li><a href="about.php">About Us</a></li>


    
    <?php
// Database connection (assumed $conn is already defined and connected)

// Fetch categories
$category_query = "SELECT * FROM categories WHERE id = 2";  // You can change the WHERE condition to get categories dynamically
$category_result = mysqli_query($conn, $category_query);

if (mysqli_num_rows($category_result) > 0) {
    while ($category = mysqli_fetch_assoc($category_result)) {
        echo '<li id="products-menu"><a href="#">' . htmlspecialchars($category['cat_name']) . '</a>';
        
        // Fetch subcategories for this category
        $subcategory_query = "SELECT * FROM scategories WHERE category_id = " . $category['id'];
        $subcategory_result = mysqli_query($conn, $subcategory_query);
        
        if (mysqli_num_rows($subcategory_result) > 0) {
            echo '<ul class="dropdown">';
            
            while ($subcategory = mysqli_fetch_assoc($subcategory_result)) {
                echo '<li><a href="#">' . htmlspecialchars($subcategory['scat_name']) . '</a>';
                
                // Fetch products for this subcategory
                $product_query = "SELECT * FROM products WHERE scategory_id = " . $subcategory['id'];
                $product_result = mysqli_query($conn, $product_query);
                
                if (mysqli_num_rows($product_result) > 0) {
                    echo '<ul class="submenu">';
                    
                    while ($product = mysqli_fetch_assoc($product_result)) {
                        echo '<li><a href="product-detail.php?id=' . $product['id'] . '">' . htmlspecialchars($product['product_name']) . '</a></li>';
                    }
                    
                    echo '</ul>';
                }
                
                echo '</li>';
            }
            
            echo '</ul>';
        }
        
        echo '</li>';
    }
} else {
    echo "No categories found.";
}
?>



    <!-- Products Menu with Categories and Subcategories -->
    <!-- <li id="products-menu"><a href="#">Sport</a>
        <ul class="dropdown">
            <li><a href="#">Sub-cate1</a>
                <ul class="submenu">
                    <li><a href="product-detail.php">Product 1</a></li>
                    <li><a href="product-detail.php">Product 2</a>
                    </li>
                </ul>
            </li>
         
        </ul>
    </li> -->



    <?php

// $category_query = "SELECT * FROM categories WHERE id = 1";  
// $category_result = mysqli_query($conn, $category_query);

// if (mysqli_num_rows($category_result) > 0) {
//     while ($category = mysqli_fetch_assoc($category_result)) {
//         echo '<li id="products-menu"><a href="#">' . htmlspecialchars($category['cat_name']) . '</a>';

//         $subcategory_query = "SELECT * FROM scategories WHERE category_id = " . $category['id'];
//         $subcategory_result = mysqli_query($conn, $subcategory_query);
        
//         if (mysqli_num_rows($subcategory_result) > 0) {
//             echo '<ul class="dropdown">';
            
//             while ($subcategory = mysqli_fetch_assoc($subcategory_result)) {
//                 echo '<li><a href="#">' . htmlspecialchars($subcategory['scat_name']) . '</a>';
                
              
//                 $product_query = "SELECT * FROM products WHERE scategory_id = " . $subcategory['id'];
//                 $product_result = mysqli_query($conn, $product_query);
                
//                 if (mysqli_num_rows($product_result) > 0) {
//                     echo '<ul class="submenu">';
                    
//                     while ($product = mysqli_fetch_assoc($product_result)) {
//                         echo '<li><a href="product-detail.php?id=' . $product['id'] . '">' . htmlspecialchars($product['product_name']) . '</a></li>';
//                     }
                    
//                     echo '</ul>';
//                 }
                
//                 echo '</li>';
//             }
            
//             echo '</ul>';
//         }
        
//         echo '</li>';
//     }
// } else {
//     echo "No categories found.";
// }
?>

   
    <!-- <li id="products-menu"><a href="#">Solor</a>
        <ul class="dropdown">
            <li><a href="#">Sub-cate1</a>
                <ul class="submenu">
                    <li><a href="product-detail.php">Product 1</a></li>
                   
                    </li>
                </ul>
            </li>
         
        </ul>
    </li> -->

    <!-- <li><a href="service.php">Services</a></li> -->
  

    <li><a href="contact.php">Contact Us</a></li>
    <!-- <li><a href="blog.php">Blogs</a></li> -->
</ul>

                        </nav>
                    </div>
                    <!-- <div class="col-lg-3 col-md-3">
                        <div class="header__social">
                            <a href="#"><i class="fa fa-facebook"></i></a>
                            <a href="#"><i class="fa fa-twitter"></i></a>
                            <a href="#"><i class="fa fa-instagram"></i></a>
                            <a href="#"><i class="fa fa-linkedin"></i></a>
                        </div>
                    </div> -->
                </div>
            </div>
        </div>
    </header>


    <style>
        /* Main menu styling */
.main-menu, .dropdown, .submenu {
    list-style-type: none;
    margin: 0;
    padding: 0;
}

/* Main menu item */
.main-menu > li {
    position: relative;
}

.main-menu > li > a {
    display: block;
    padding: 10px;
    /* background-color: #333; */
    color: #fff;
    text-decoration: none;
}

/* Target only the Products dropdown */
#products-menu .dropdown {
    display: none;
    position: absolute;
    top: 100%;
    left: 0;
  

    /* background-color: #f9f9f9; */
    border: 1px solid #ddd;
    z-index: 1000;
}

#products-menu:hover .dropdown {
    display: block;
    padding: 2px 2px 2px 16px
}

/* Submenu styling for sub-categories */
#products-menu .submenu {
    display: none;
    position: absolute;
    top: 0;
    left: 100%;
    width: 178px;
    background-color: #fff;
    border: 1px solid #ddd;
    z-index: 1000;
    padding: 2px 2px 2px 16px
}

#products-menu .dropdown li:hover > .submenu {
    display: block;
}

/* Link styling within dropdowns and submenus */
#products-menu .dropdown li a, #products-menu .submenu li a {
    display: block;
    padding: 10px;
    color: #333;
    text-decoration: none;
    padding: 2px 2px 2px 2px;
}

#products-menu .dropdown li a:hover, #products-menu .submenu li a:hover {
    background-color: #ddd;
}

    </style>