<?php
//ini_set('display_errors', 1); ini_set('display_startup_errors', 1); error_reporting(E_ALL);
include_once('../../includes/db_connect.php'); 
if(isset($_POST['campusid'])){
$campusid = $_POST["campusid"];
$num=0;
$query="SELECT * FROM students WHERE campus='$campusid' ORDER BY id DESC";
$ccs=mysqli_query($con, $query ) or die(mysqli_error($con));
$flists = "";
while($row=mysqli_fetch_assoc($ccs)){
     $num++;
     $requested_on = date("d M Y h:i A",strtotime($row["createdon"]));
       
     $flists .= '<tr><td>'.$num.'</td><td>'.$row["admno"].'</td><td>'.$row["name"].'</td><td>'.$row["email"].'</td><td>'.$row["phone"].'</td><td>'.$requested_on.'</td><td><a id='.$row["id"].' class="btn btn-sm btn-danger removestudent"><i class="fa fa-times"></i></a></td></tr>';
 }
 echo $flists;
}
?>
<?php mysqli_close($con) ?>

<script>
        //remove student from campus
       $(".removestudent").click(function(){
        var studentid = $(this).attr("id"); 
         var d = confirm('Are you sure you want to remove student from campus?');
         if(d == false){
         return false;
         }
        else{
        $.ajax({
          method:"post",
          url:"app/campuses",
          data:{studentid:studentid},
          cache:false
        }).done(function(data){
          if(data.status == "200"){
              alert("student removed successfully");
             window.location.replace("campuses");
            }else{
                alert("error removing student");
            }
         });
        }
       });
</script>