File: /home/bibuzptr/elearning.bibu-edu.us/old 20th oct/admin/app/activate-quiz.php
<?php
include_once('../../includes/db_connect.php');
header("Content-Type:application/json");
$date = date("Y-m-d H:i:s");
$year = date("Y");
//quiz
if(isset($_POST["quizid"])){
$id = trim(mysqli_real_escape_string($con, $_POST["quizid"]));
if(mysqli_query($con,"UPDATE quizs 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["quizid2"])){
$id = trim(mysqli_real_escape_string($con, $_POST["quizid2"]));
if(mysqli_query($con,"UPDATE quizs 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["quizid3"])){
$id = trim(mysqli_real_escape_string($con, $_POST["quizid3"]));
if(mysqli_query($con,"DELETE FROM quizs WHERE id = '$id'")){
echo json_encode(array('status' => '200','message' => 'SUCCESS'));
}
else{
echo json_encode(array('status' => '300','message' => 'ERROR'));
}
}
if(isset($_POST["quizid4"])){
$id = trim(mysqli_real_escape_string($con, $_POST["quizid4"]));
if(mysqli_query($con,"DELETE FROM docquizs WHERE id = '$id'")){
echo json_encode(array('status' => '200','message' => 'SUCCESS'));
}
else{
echo json_encode(array('status' => '300','message' => 'ERROR'));
}
}
?>
<?php mysqli_close($con) ?>