<?php
$userid = "";
$teacher = "";
$subjectList = array();
$userid = $_SESSION['user'];
//$userid = "IIT2012024";
$subjectList = getSubListByid($userid);
$teacherid = "";
$subject = "";
if (isset($_POST['sub'])) {
$subject = $_POST['sub'];
for ($i = 0; $i < count($subjectList); $i++) {
if ($subjectList[$i]['Sub_Name'] == $subject) {
$teacherid = $subjectList[$i]['Teacher_ID'];
$teacher = getTeacherByid($subjectList[$i]['Teacher_ID']);
break;
}
}
}
if (isset($_POST['logout'])) {
session_start();
$_SESSION = array();
session_destroy();
redirectTo(HOME);
}
?>
<html>
<head>
<title>FeedBack Form IIITA</title>
<?php
$userid = "";
$teacher = "";
$subjectList = array();
$userid = $_SESSION['user'];
$subjectList = getSubListByid($userid);
$teacherid = "";
$subject = "";
$errormsg = "";
if (isset($_POST['submit'])) {
if (isset($_POST['sub']) && $_POST['sub'] != 'None') {
$subject = $_POST['sub'];
for ($i = 0; $i < count($subjectList); $i++) {
if ($subjectList[$i]['Sub_Name'] == $subject) {
$teacherid = $subjectList[$i]['Teacher_ID'];
$teacher = getTeacherByid($teacherid);
break;
}
}
if (isset($_POST['clarity']) && isset($_POST['punctuality']) && isset($_POST['doubts']) && isset($_POST['capability']) && isset($_POST['approachability']) && isset($_POST['syllabus']) && isset($_POST['helpful']) && isset($_POST['labs']) && isset($_POST['lab_assignments']) && isset($_POST['lnt']) && isset($_POST['involvement']) && isset($_POST['overall'])) {
if (!empty($_POST['clarity']) && !empty($_POST['punctuality']) && !empty($_POST['doubts']) && !empty($_POST['capability']) && !empty($_POST['approachability']) && !empty($_POST['syllabus']) && !empty($_POST['helpful']) && !empty($_POST['labs']) && !empty($_POST['lab_assignments']) && !empty($_POST['lnt']) && !empty($_POST['involvement']) && !empty($_POST['overall'])) {
$sql = "INSERT INTO question_feedback (teacher_id, subject_id, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10, Q11, Q12) VALUES (:teacher_id, :subject_id , :q1, :q2, :q3, :q4, :q5, :q6, :q7, :q8, :q9, :q10, :q11, :q12)";
$params = array(':teacher_id' => $teacher, ':subject_id' => $subject, ':q1' => $_POST['clarity'], ':q2' => $_POST['punctuality'], ':q3' => $_POST['doubts'], ':q4' => $_POST['capability'], ':q5' => $_POST['approachability'], ':q6' => $_POST['syllabus'], ':q7' => $_POST['helpful'], ':q8' => $_POST['labs'], ':q9' => $_POST['lab_assignments'], ':q10' => $_POST['lnt'], ':q11' => $_POST['involvement'], ':q12' => $_POST['overall']);
$result = DatabaseHandler::Execute($sql, $params);
if ($result) {
header('Location: Thanx.php');
} else {
echo "<script>alert('There was an Error in inserting data into the database!');</script>";
}
} else {
echo "<script> myFunction(); </script>";
