<?php
include_once('../../includes/db_connect.php'); 
header("Content-Type:application/json");
$date = date("Y-m-d H:i:s");
$year = date("Y");


//school
if(isset($_POST["schoolid"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["schoolid"]));
  if(mysqli_query($con,"UPDATE schools SET status='1' WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
  if(isset($_POST["schoolid2"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["schoolid2"]));
  if(mysqli_query($con,"UPDATE schools SET status='0' WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
  if(isset($_POST["schoolid3"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["schoolid3"]));
  if(mysqli_query($con,"DELETE FROM schools WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
?>
<?php mysqli_close($con) ?>