<?php session_start(); error_reporting(E_ERROR | E_PARSE);
include("connection.php");  $id=$_REQUEST["id"];
date_default_timezone_set("Asia/Calcutta");
$ids=$_REQUEST["del_id"];
if($ids !="") {
    mysqli_query($con,"delete * from building  where `id`='".$ids."'");?>
	?><script>
	window.location.href="inn.php";
	</script><?php 
} else { }


?>
<!DOCTYPE html>
<html lang="en">

<head>
  <meta charset="utf-8">
  <meta content="width=device-width, initial-scale=1.0" name="viewport">

  <title>Ghatal Municipality</title>
  <meta content="" name="description">
  <meta content="" name="keywords">

  <!-- Favicons -->
  <link href="assets/img/favicon.png" rel="icon">
  <link href="assets/img/apple-touch-icon.png" rel="apple-touch-icon">

  <!-- Google Fonts -->
  <link href="https://fonts.googleapis.com/css?family=Open+Sans:300,300i,400,400i,600,600i,700,700i|Raleway:300,300i,400,400i,500,500i,600,600i,700,700i|Poppins:300,300i,400,400i,500,500i,600,600i,700,700i" rel="stylesheet">

  <!-- Vendor CSS Files -->
  <link href="assets/vendor/aos/aos.css" rel="stylesheet">
  <link href="assets/vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet">
  <link href="assets/vendor/bootstrap-icons/bootstrap-icons.css" rel="stylesheet">
  <link href="assets/vendor/boxicons/css/boxicons.min.css" rel="stylesheet">
  <link href="assets/vendor/glightbox/css/glightbox.min.css" rel="stylesheet">
  <link href="assets/vendor/swiper/swiper-bundle.min.css" rel="stylesheet">


 



  <!-- Template Main CSS File -->
  <link href="assets/css/style.css" rel="stylesheet">

<link href='https://cdn.datatables.net/1.10.19/css/jquery.dataTables.min.css' rel='stylesheet' type='text/css'>
<link href='https://cdn.datatables.net/buttons/1.5.6/css/buttons.dataTables.min.css' rel='stylesheet' type='text/css'>
<link href='https://cdn.datatables.net/2.0.5/css/dataTables.dataTables.css' rel='stylesheet' type='text/css'>

<script src="https://code.jquery.com/jquery-3.7.1.js" type="text/javascript"></script>
<script src="https://cdn.datatables.net/2.0.5/js/dataTables.js" type="text/javascript"></script>

  <!-- =======================================================
  * Template Name: Appland - v4.2.0
  * Template URL: https://bootstrapmade.com/free-bootstrap-app-landing-page-template/
  * Author: BootstrapMade.com
  * License: https://bootstrapmade.com/license/
  ======================================================== -->
</head>

<body >

  <!-- ======= Header ======= -->
  <header id="header" class="fixed-top " style="background-color:#660000">
    <div class="container d-flex align-items-center justify-content-between" >

      <div class="logo" >
         <h1><a href="trade_1.php"><b> <font color="white">Ghatal Municipality</font></b></a></h1>
        <!-- Uncomment below if you prefer to use an image logo -->
        <!-- <a href="index.html"><img src="assets/img/logo.png" alt="" class="img-fluid"></a>-->
      </div>

      <nav id="navbar" class="navbar">
        <ul>
          <li><a class="nav-link scrollto" href="trade_1.php"><font color="white"><b>Home</b></font></a></li>
          <li><a class="nav-link scrollto" href="renew_complete.php"><font color="white"><b>Home</b></font></a></a></li>
          <li><a class="nav-link scrollto" href="renew_due.php"><font color="white"><b>Home</b></font></a></a></li>
         
        </ul>
        <i class="bi bi-list mobile-nav-toggle"></i>
      </nav><!-- .navbar -->

    </div>
  </header><!-- End Header -->

 

    <!-- ======= Breadcrumbs Section ======= -->
   
  <br>  

    <section id="contact" class="contact" style="background-color:#CCFFFF">
      <div class="container" data-aos="fade-up">
<h4><b>All Data</b></h4><hr><?php $i=1;   $cl=mysqli_query($con,"select * from building  "); 


  ?>      
   
 <center> 
  
   <a href="inn.php"><img src="https://cdn-icons-png.freepik.com/256/7915/7915208.png?semt=ais_hybrid" width="50"></a> &nbsp; &nbsp; 
    <a href="inn.php"><img src="https://cdn-icons-png.flaticon.com/512/6831/6831963.png" width="50"></a> &nbsp; &nbsp;  
     <a href="add.php"><img src="https://cdn-icons-png.flaticon.com/512/2921/2921226.png" width="50"></a> &nbsp; &nbsp;  
    </center>
   <hr>
   
   <div class="table-responsive">
   
    <table class="table table-bordered table-hover" id="example" border="1" style=" border: 1px solid black;" >
                                            <thead>
                                                <tr style=" border: 1px solid black; background-color: #99FFFF">  <th>Sl</th>
                                                      <th>Plan No</th>
                                                       <th>ward</th>
                                                     <th>Name</th>
                                                      <th>Address</th>
                                                      <th>Holding</th>
                                                      <th>LBS</th>
                                                     <th>Submit Date</th>
                                                      <th>Approved Date</th>
                                                      <th >Action</th>
                                                   
                                                                                                     
                                                </tr>
                                            </thead>
                                            <tbody>
<?php while($clr=mysqli_fetch_array($cl,MYSQLI_ASSOC)) { ?> 
                                       <tr style=" border: 1px solid black;">
        										     <td style=" border: 1px solid black;"><?php echo $i; ?></td>
                                                     <td style=" border: 1px solid black;">
                                                         <?php echo $clr['building_plan_no']; ?>	
													 </td>
                                                      <td style=" border: 1px solid black;">
                                                         <?php echo $clr['ward']; ?>	
													 </td>
                                                     <td style=" border: 1px solid black;"><?php echo $clr['name']; ?></td>
                                                     <td style=" border: 1px solid black;"><font color="blue"><?php echo $clr["address"];  ?></font></td>
                                                    <td style=" border: 1px solid black;"><font color="blue"><?php echo $clr["holding_no"];  ?></font></td>
                                                     <td style=" border: 1px solid black;"><font color="blue"><?php echo $clr["lbs"];  ?></font></td>
                                                      <td style=" border: 1px solid black;"><font color="blue"><?php echo $clr["submit_date"];  ?></font></td>
                                                       <td style=" border: 1px solid black;"><font color="blue"><?php echo $clr["approved_date"];  ?></font></td>
                                                        <td style=" border: 1px solid black;"> 
                                                        <a href="edit.php?edit_id=<?php echo $clr['id']; ?>">
                                                        <img src="https://cdn-icons-png.flaticon.com/512/6052/6052010.png" width="20"> </a>

                                                              <a href="?del_id=<?php echo $clr['id']; ?>" onclick="return confirm('Are you sure you want delete');"><img src="https://cdn-icons-png.freepik.com/256/6861/6861362.png?semt=ais_hybrid" width="20"> 
                                                              </a>
                                                              </td>
                                                   </tr>
 <?php $i++; }?>                                              

                                     
 
                                                                                             </tbody>
                                            
                                        </table> 

</div>
   
   
        <div class="row">

          <div class="col-lg-6">
	

          </div>
		 
        </div>
          </div>

        </div>
		 

      </div>
    </section><!-- End Contact Section -->


  <!-- End #main -->

  <!-- ======= Footer ======= -->
<!--  <footer id="footer">

    <div class="footer-newsletter">
      <div class="container">
        <div class="row justify-content-center">
          <div class="col-lg-6">
            <h4>Join Our Network</h4>
            <p>Join with our network and receive updates</p>
            <form action="subscribe.php" method="post">
              <input type="email" name="email"><input type="submit" value="Subscribe">
            </form>
          </div>
        </div>
      </div>
    </div>

    <div class="footer-top">
      <div class="container">
        <div class="row">

          <div class="col-lg-3 col-md-6 footer-contact">
            <h3>Contact</h3>
            <p>
              Srirampurt <br>
              Panskura<br>
              West bengal <br><br>
              <strong>Phone:</strong> +91 8961963301<br>
              <strong>Email:</strong> saikat3322@gmail.com<br>
            </p>
          </div>

          <div class="col-lg-3 col-md-6 footer-links">
            <h4>Useful Links</h4>
            <ul>
			<li><a class="bx bx-chevron-right" href="#hero">Home</a></li>
          <li><a class="bx bx-chevron-right" href="#features">About Me</a></li>
          <li><a class="bx bx-chevron-right" href="#gallery">Project</a></li>
		     <li><a class="bx bx-chevron-right" href="#contact">Contact</a></li>
          
             
            </ul>
          </div>

          <div class="col-lg-3 col-md-6 footer-links">
            <h4>Our Services</h4>
            <ul>
              <li><i class="bx bx-chevron-right"></i> <a href="#">School/College Projects</a></li>
              <li><i class="bx bx-chevron-right"></i> <a href="#">Various Courses</a></li>
              <li><i class="bx bx-chevron-right"></i> <a href="#">Web Development</a></li>
              
            </ul>
          </div>

          <div class="col-lg-3 col-md-6 footer-links">
            <h4>Our Social Networks</h4>
            <p>Find our Social Network</p>
            <div class="social-links mt-3">
              <a href="#" class="twitter"><i class="bx bxl-twitter"></i></a>
              <a href="#" class="facebook"><i class="bx bxl-facebook"></i></a>
              <a href="#" class="instagram"><i class="bx bxl-instagram"></i></a>
              <a href="#" class="google-plus"><i class="bx bxl-skype"></i></a>
              <a href="#" class="linkedin"><i class="bx bxl-linkedin"></i></a>
            </div>
          </div>
Terms and Conditions | Privacy Policy | Refunds/Cancellations
        </div>
      </div>
    </div>

    <div class="container py-4">
      <div class="copyright">
        &copy; Copyright <strong><span>< CWS /></span></strong>. All Rights Reserved
      </div>
      <div class="credits">
        <!-- All the links in the footer should remain intact. -->
        <!-- You can delete the links only if you purchased the pro version. -->
        <!-- Licensing information: https://bootstrapmade.com/license/ -->
        <!-- Purchase the pro version with working PHP/AJAX contact form: https://bootstrapmade.com/free-bootstrap-app-landing-page-template/ 
        Designed by <a href="#">Coding With Saikat</a>
      </div>
    </div>
	
  </footer>--><!-- End Footer -->

  <a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>

  <!-- Vendor JS Files -->
  <script src="assets/vendor/aos/aos.js"></script>
  <script src="assets/vendor/bootstrap/js/bootstrap.bundle.min.js"></script>
  <script src="assets/vendor/glightbox/js/glightbox.min.js"></script>
  <script src="assets/vendor/php-email-form/validate.js"></script>
  <script src="assets/vendor/swiper/swiper-bundle.min.js"></script>

  <!-- Template Main JS File -->
  <script src="assets/js/main.js"></script>



<script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js" type="text/javascript"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.6/js/dataTables.buttons.min.js" type="text/javascript"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.flash.min.js" type="text/javascript"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js" type="text/javascript"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js" type="text/javascript"></script>
 <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js" type="text/javascript"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.html5.min.js" type="text/javascript"></script>
 <script src="https://cdn.datatables.net/buttons/1.5.6/js/buttons.print.min.js" type="text/javascript"></script>


    <script >
        $(document).ready(function() {
    $('#example').DataTable( {
        dom: 'Bfrtip',
        buttons: [
            'copy', 'csv', 'excel', 'pdf', 'print'
        ]
    } );
} );
</script>


</body>

</html>