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


//course
if(isset($_POST["courseid"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["courseid"]));
  if(mysqli_query($con,"UPDATE courses 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["courseid2"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["courseid2"]));
  if(mysqli_query($con,"UPDATE courses 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["courseid3"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["courseid3"]));
  if(mysqli_query($con,"DELETE FROM courses WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
?>
<?php mysqli_close($con) ?>