<?php 
include('connection.php');?>
<footer class="footer">

      <div class="footer-primary">
        <div class="container">
          <div class="row">
          
            <div class="col-sm-12 col-md-12 col-lg-3">
            <?php
          $sel = "SELECT * FROM footer_about"; 
          $res = mysqli_query($con,$sel);
          while($r = mysqli_fetch_array($res))
          {
            ?>
              <div class="footer-widget-about">
               <div style="background:white; padding:5px; border-radius:10px; margin-bottom: 10px;">   
               <img src="br-admin/uploads/logo/<?php echo $r[2]; ?>" alt="logo" class="mb-30"></div>
                <p class="color-gray"><?php echo $r[1]; ?></p>

              </div>
              <?php
          }
        ?>
            </div>
            <div class="col-sm-6 col-md-6 col-lg-2 offset-lg-1">
      
              <div class="footer-widget-nav">
                <h6 class="footer-widget__title">Departments</h6>
                <nav>
                <?php
                  $sel = "SELECT * FROM footer_dept"; 
                  $res = mysqli_query($con,$sel);
                  while($r = mysqli_fetch_array($res))
                    { 
                ?>
                  <ul class="list-unstyled">
                    <li><p><?php echo $r[1]; ?></p></li>
                  </ul>
                  <?php
              }
              ?>
                </nav>
              </div>
              
            </div>
            <div class="col-sm-6 col-md-6 col-lg-2">
              <div class="footer-widget-nav">
                <h6 class="footer-widget__title">Links</h6>
                <nav>
                  <?php
                  $sel = "SELECT * FROM footer_link"; 
                  $res = mysqli_query($con,$sel);
                  while($r = mysqli_fetch_array($res))
                    { 
                ?>
                  <ul class="list-unstyled">
                    <li><a href="<?php echo $r[2]; ?>"><?php echo $r[1]; ?></a></li>
                    
                  </ul>
                  <?php
              }
              ?>
                </nav>
              </div>
            </div>
            <div class="col-sm-12 col-md-6 col-lg-4">
              <div class="footer-widget-contact">
                <h6 class="footer-widget__title color-heading">Quick Contacts</h6>
                <ul class="contact-list list-unstyled">
                  <?php
                  $sel = "SELECT * FROM footer_contact"; 
                  $res = mysqli_query($con,$sel);
                  while($r = mysqli_fetch_array($res))
                    { 
                ?>
                  <li><?php echo $r[1]; ?></li>
                  <li>
                    <a href="tel:01061245741" class="phone__number">
                      <i class="icon-phone"></i> <span><?php echo $r[2]; ?></span>
                    </a>
                  </li>
                  <li class="color-body"><?php echo $r[3]; ?></li>
                    <?php
              }
              ?>
                </ul>
                <div class="d-flex align-items-center">
                  <a href="#" class="btn btn__primary btn__link mr-30">
                    <i class="icon-arrow-right"></i> <span>Get Directions</span>
                  </a>
                  <ul class="social-icons list-unstyled mb-0">
                    <li><a href="#"><i class="fab fa-facebook-f"></i></a></li>
                    <li><a href="#"><i class="fab fa-instagram"></i></a></li>
                    <li><a href="#"><i class="fab fa-youtube"></i></a></li>
                  </ul>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
      <div class="footer-secondary">
        <div class="container">
          <div class="row align-items-center">
            <div class="col-sm-12 col-md-6 col-lg-12">
              <span class="fz-14">&copy; 2022 , All Rights Reserved. With Love by</span>
              <a class="fz-14 color-primary" href="https://windinsolutions.com/">Windin Solutions</a>
            </div>
          </div>
      </div>
    </footer>
    <button id="scrollTopBtn"><i class="fas fa-long-arrow-alt-up"></i></button>
  </div>
  <script src="assets/js/jquery-3.5.1.min.js"></script>
  <script src="assets/js/plugins.js"></script>
  <script src="assets/js/main.js"></script>
</body>

</html>