<?php
session_start();
ini_set('display_errors', 1); 
ini_set('display_startup_errors', 1); 
error_reporting(E_ALL);
include_once('../../includes/db_connect.php');
header("Content-Type:application/json");
$date = date("Y-m-d H:i:s");
$year = date("Y");
// if(isset($_SESSION["OPENUNI^###DHSG"])){
//     $email = $_SESSION["OPENUNI^###DHSG"];
    // $chkuser = mysqli_query($con,"SELECT * FROM admins WHERE admin_email='$email'");
    // while($row = mysqli_fetch_assoc($chkuser)){
    //   $uid = $row["id"];
    //   $name = $row["admin_name"];
    // }
/*<===========================campus Management=================================>*/
if(isset($_POST["campusname"])){
 $id = trim(mysqli_real_escape_string($con, $_POST["campusid"]));
  extract($_POST);
    //New campus
    if($id == ""){
     if(mysqli_query($con,"INSERT INTO campuses(countryid,campusname,county,lecturer) VALUES('$countryid','$campusname','$county','$lecturer')")){
       echo json_encode(array("status" => 200, "message" => "SUCCESS"));
      }
      else{
        echo json_encode(array('status' => 300,'message' => mysqli_error($con)));
      }
    }
    else{
    if(mysqli_query($con,"UPDATE campuses SET countryid='$countryid',campusname='$campusname',county='$county',lecturer='$lecturer' WHERE id = '$id'")){
         echo json_encode(array('status' => 200,'message' => 'SUCCESS'));
        }
        else{
          echo json_encode(array('status' => 300,'message' => 'ERROR'));
      }
    }
  }
  
    if(isset($_POST["campusid3"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["campusid3"]));
  if(mysqli_query($con,"DELETE FROM campuses WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
      if(isset($_POST["studentid"])){
  $id = trim(mysqli_real_escape_string($con, $_POST["studentid"]));
  if(mysqli_query($con,"UPDATE students SET campus='0' WHERE id = '$id'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }
  
     if(isset($_POST["studentid2"])){
  $studentid = trim(mysqli_real_escape_string($con, $_POST["studentid2"]));
  $campusid = trim(mysqli_real_escape_string($con, $_POST["campusid"]));
  if(mysqli_query($con,"UPDATE students SET campus='$campusid' WHERE id = '$studentid'")){
    echo json_encode(array('status' => '200','message' => 'SUCCESS'));
  }
  else{
    echo json_encode(array('status' => '300','message' => 'ERROR'));
   }
  }


//}
?>
<?php mysqli_close($con) ?>