1#@!#!123s

: / home3 / encodto1 / newpcjewellers.in /
Filename : footer.php
back
<?php
// Include your database configuration file
include('config.php');

// Fetch categories for "Our Jewelleries"
$ourJewelleriesQuery = "SELECT id, category_name FROM product_category LIMIT 11"; // Adjust the limit as needed
$ourJewelleriesResult = mysqli_query($conn, $ourJewelleriesQuery);

// Fetch categories for "Our Collections"
$ourCollectionsQuery = "SELECT id, category_name FROM product_category";
$ourCollectionsResult = mysqli_query($conn, $ourCollectionsQuery);
?>

<footer class="row footer2">
   <div class="footerOverlay">
      <div class="row m0 topFooter">
         <div class="container line2">
            <div class="row m0">
               <div class="col-12">
                  <div class="footer_logo text-center">
                     <img src="images/npj.png" alt="new-pc-jewellers-logo">
                  </div>
               </div>
               <div class="col-12 top_widget">
                  <div class="row m0">
                     <h4>Our Jewelleries</h4>
                     <ul class="tags">
                        <?php
                        // Loop through the categories and display them
                        if (mysqli_num_rows($ourJewelleriesResult) > 0) {
                           while ($row = mysqli_fetch_assoc($ourJewelleriesResult)) {
                              echo '<li><a href="products.php?category=' . $row['id'] . '">' . $row['category_name'] . '</a></li>';
                           }
                        } else {
                           echo '<li>No categories found.</li>';
                        }
                        ?>
                     </ul>
                  </div>
               </div>
               <div class="col-md-4 col-sm-6 col-xs-12 widget">
                  <div class="row m0">
                     <h4>Contact Details</h4>
                     <ul class="contact_list">
                        <li><a href="tel:+91 97343 55000"><i class="fas fa-phone"></i> +91 97343 55000</a></li>
                        <li><a href="mailto:info@newpcjewellers.com"><i class="fas fa-envelope"></i> info@newpcjewellers.com</a></li>
                        <li><a href="#"><i class="fas fa-map-marker-alt"></i> Pritilata Sarani, near SBI Branch, Haider para, Ward 39, Siliguri, West Bengal 734006</a></li>
                        <li><a href="#"><i class="fas fa-map-marker-alt"></i>D.B.C Road , Kadamtala , Jalpaiguri</a></li>
                     </ul>
                     <ul class="list-inline">
                        <li><a href="https://www.facebook.com/newpcjewellersslg01"><i class="fab fa-facebook-f"></i></a></li>
                        <li><a href="https://www.instagram.com/newpcjewellerssiliguri/"><i class="fab fa-instagram"></i></a></li>
                       
                     </ul>
                  </div>
               </div>
               <div class="col-md-2 col-sm-6 col-xs-12 widget">
                  <div class="row m0">
                     <h4>Overview</h4>
                     <ul class="nav">
                        <li><a href="about.php">About</a></li>
                        <li><a href="products.php">collection</a></li>
                        <li><a href="gallery.php">Photo Gallery</a></li>
                        <li><a href="contact.php">Contact Us</a></li>
                     </ul>
                  </div>
               </div>
                <div class="col-md-2 col-sm-6 col-xs-12 widget">
                  <div class="row m0">
                     <h4>Our COLLECTIONS</h4>
                     <ul class="nav">
                        <li><a href="about.php">Rings</a></li>
                        <li><a href="products.php">Jhumka</a></li>
                        <li><a href="gallery.php">Pendants</a></li>
                        <li><a href="contact.php">Chains</a></li>
                     </ul>
                  </div>
               </div>

               <div class="col-md-4 col-sm-6 col-xs-12 widget">
                  <div class="row m0">
                     <iframe src="https://www.facebook.com/plugins/page.php?href=https%3A%2F%2Fwww.facebook.com%2Fnewpcjewellersslg01&tabs=timeline&width=340&height=500&small_header=false&adapt_container_width=true&hide_cover=false&show_facepile=true&appId" width="340" height="300" style="border:none;overflow:hidden" scrolling="no" frameborder="0" allowfullscreen="true" allow="autoplay; clipboard-write; encrypted-media; picture-in-picture; web-share"></iframe>
                     <div id="fb-root"></div>
                  </div>
               </div>
            </div>
         </div>
      </div>
      <div class="row m0 copyRight">
         <div class="container">
            <div class="row m0">
               <div class="fleft">&copy; 2025 <a href="index.php">New PC Jewellers</a> All Rights Reserved.</div>
               <div class="float-right footer_dev">
                  <p>Designed with <i class="fas fa-heart"></i> By <a href="#"><img src="images/eu.png" alt="encoders-unlimited-image" title="encoders-unlimited"></a></p>
               </div>
            </div>
         </div>
      </div>
   </div>
   <div class="footer_smFixed">
      <ul class="list-inline">
         <li class="list-inline-item"><a href="contact.php" title="Contact-Us" data-toggle="tooltip" data-placement="top"><i class="fas fa-thumbtack"></i></a></li>
      </ul>
   </div>
</footer>

<?php
// Close the database connection if not needed further
mysqli_close($conn);
?>