<?php include "includes/header.php";?>

<?php include "includes/navbar.php";?>

  <div id="wrapper">

    <!-- Sidebar -->
   <?php include "includes/sidebar.php";?>

    <div id="content-wrapper">

      <div class="container-fluid">

        <!-- Breadcrumbs-->
        <ol class="breadcrumb">
          <li class="breadcrumb-item">
            <a href="#">Ola</a>
          </li>
          <li class="breadcrumb-item active"><?php echo $_SESSION['nome'];?></li>
        </ol>

        <h2><font color='green'>Mensagens</font></h2>
		
		<div class="container">
		 <div class="col-sm-12">
		 
	
	<table class="table">
	    
	    <thead>
	        
	        <tr>
	            <th>Item</th>
	            <th>Nome</th>
	            <th>Mensagem</th>
	            <th>Contacto</th>
	            <th>Apagar</th>
	        </tr>
	    </thead>
	    
	    <tbody>
	        
	        
	        <?php
	        $item=1;
	        $buscar = "SELECT * FROM contactos";
	        $query = mysqli_query($con,$buscar);
	        while($row = mysqli_fetch_assoc($query)){
	        
	        $nome = $row['nome'];
	        $mensagem = $row['mensagem'];
	        $email = $row['email'];
	        ?>
	        <tr>
	            <td><?php echo $item++;?></td>
	            <td><?php echo $nome;?></td>
	            <td><?php echo $mensagem;?></td>
	            <td><?php echo $email;?></td>
	            <td><button type="button" name="apagar" class="btn btn-info btn-sm"><a href="mensagens.php?id=<?php echo $row['id'];?>"style="text-decoration:none; color:white;"><span>Apagar</span></a></button></td>
	        </tr>
	        <?php }?>
	        
	        
	    </tbody>
	    
	    
	</table>
		 
		 </div>
		
		</div>
      
	  <?php 
	  if(isset($_GET['id']) && !empty($_GET['id'])){
	      
	      
	      $id = $_GET['id'];
	      
	      $apaga = "DELETE FROM contactos WHERE id='$id'";
	      $link = mysqli_query($con,$apaga);
	      
	      if($link){
	          
	          echo "<script>window.open('mensagens.php','_self')</script>";
	      }
	  }
	  
	  
	  
	  ?>

	
		

      </div>
      <!-- /.container-fluid -->

      <!-- Sticky Footer -->
     <?php include "includes/footer.php";?>

    </div>
    <!-- /.content-wrapper -->

  </div>
  <!-- /#wrapper -->

  <!-- Scroll to Top Button-->
  <a class="scroll-to-top rounded" href="#page-top">
    <i class="fas fa-angle-up"></i>
  </a>

  <!-- Logout Modal-->
<?php include "includes/logout_modal.php"; ?>

  <!-- Bootstrap core JavaScript-->
  <script src="vendor/jquery/jquery.min.js"></script>
  <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script>

  <!-- Core plugin JavaScript-->
  <script src="vendor/jquery-easing/jquery.easing.min.js"></script>

  <!-- Page level plugin JavaScript-->
  <script src="vendor/chart.js/Chart.min.js"></script>
  <script src="vendor/datatables/jquery.dataTables.js"></script>
  <script src="vendor/datatables/dataTables.bootstrap4.js"></script>

  <!-- Custom scripts for all pages-->
  <script src="js/sb-admin.min.js"></script>

  <!-- Demo scripts for this page-->
  <script src="js/demo/datatables-demo.js"></script>
  <script src="js/demo/chart-area-demo.js"></script>

</body>

</html>
