File: /home/bibuzptr/elearning.bibu-edu.us/dashboard/app/quizs.php
<?php
session_start();
// ini_set('display_errors', 1);
// ini_set('display_startup_errors', 1);
// error_reporting(E_ALL);
include_once "../../includes/swiftmailer/swift_required.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($_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"];
// }
/*<===========================quiz Management=================================>*/
if(isset($_POST["quizid"])){
extract($_POST);
$docfile = $_FILES['docanswer']['name'];
$file_tmp =$_FILES['docanswer']['tmp_name'];
move_uploaded_file($file_tmp,"../../docanswers/".$docfile);
if(mysqli_query($con,"INSERT INTO quizanswer(quizid,studentid,lessonid,doc) VALUES('$quizid','$studentid','$lessonid','$docfile')")){
$courseid=mysqli_fetch_assoc(mysqli_query($con,"SELECT units.courseid FROM lessons,units WHERE lessons.unitid=units.id AND lessons.id='$lessonid'"))["courseid"];
$coursename=mysqli_fetch_assoc(mysqli_query($con,"SELECT title FROM courses WHERE id='$courseid'"))["title"];
$lec=mysqli_fetch_assoc(mysqli_query($con,"SELECT lecturers.fullname,lecturers.email FROM students,lecturers WHERE students.id='$studentid' AND students.campus=lecturers.campus AND FIND_IN_SET('$courseid', lecturers.assignedcourses) > 0"));
$lecname=$lec["fullname"];
$lecemail=$lec["email"];
$std=mysqli_fetch_assoc(mysqli_query($con,"SELECT name,email,admno FROM students WHERE id='$studentid'"));
$fname=$std["name"];
$email=$std["email"];
$admno=$std["admno"];
$link="https://www.elearning.bibu-edu.us/lecturers/";
$notif = mysqli_fetch_assoc(mysqli_query($con,"SELECT * FROM notification_templates WHERE id='13'"));
$transport = Swift_SmtpTransport::newInstance('bibu-edu.us', 465, "ssl")
->setUsername('notification@bibu-edu.us')
->setPassword('@notif2019!');
$mailer = Swift_Mailer::newInstance($transport);
$message = Swift_Message::newInstance($notif["subject"])
->setFrom(array('notification@bibu-edu.us' => 'Breakthrough Open University'))
->setTo(array($lecemail => $lecname))
->setContentType('text/html; charset=utf-8')
->setBody(str_replace(array("{name}","{studentname}","{link}","{coursename}","{admno}"),array($lecname,$fname,$link,$coursename,$admno),$notif["body"]));
$numSent = $mailer->send($message);
echo json_encode(array("status" => 200, "message" => "SUCCESS"));
}
else{
echo json_encode(array('status' => 300,'message' => mysqli_error($con)));
}
}
//}
?>
<?php mysqli_close($con) ?>