File: /home/bibuzptr/elearning.bibu-edu.us/dashboard/app/unitprogress.php
<?php
include_once('../../includes/db_connect.php');
header("Content-Type:application/json");
$date = date("Y-m-d H:i:s");
$year = date("Y");
if(isset($_POST["nextid"])){
extract($_POST);
if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM learningprogress WHERE lessonid='$lessonid' AND studentid='$studentid'"))<1){
mysqli_query($con,"INSERT INTO learningprogress(unitid,lessonid,studentid) VALUES('$unitid','$lessonid','$studentid')");
echo json_encode(array('status' => '200','message' => 'SUCCESS'));
}
else{
echo json_encode(array('status' => '300','message' => 'ERROR'));
}
}
if(isset($_POST["previousid"])){
extract($_POST);
if(mysqli_num_rows(mysqli_query($con,"SELECT * FROM learningprogress WHERE lessonid='$previousid' AND studentid='$studentid'"))>0){
mysqli_query($con,"DELETE FROM learningprogress WHERE unitid='$unitid' AND lessonid='$previousid' AND studentid='$studentid'");
echo json_encode(array('status' => '200','message' => 'SUCCESS'));
}
else{
echo json_encode(array('status' => '300','message' => 'ERROR'));
}
}
?>
<?php mysqli_close($con) ?>