<?php
include_once 'classes/Authentication.php';
include_once 'classes/Database.php';
include_once 'classes/User.php';
$db = Database::getDatabase();
Authentication::sec_session_start();
if (Authentication::login_check($db->getMysqli()) == true && $_SESSION['admin'] == true) {
?>
<?php
} else {
header('Location: access-error.php');
}
?>
<?php
$userExams = User::getAppointments($_POST['netID']);
$mycount = count($userExams);
?>
<link rel="stylesheet" type="text/css" href="css/sortable_table.css">
<div class="facultyScheduleExamFormContainer">
<table id="student_exams_container" class="sortable_table">
<tbody>
<tr>
<th sort_expression="netID">netID</th>
<th sort_expression="ClassID">CourseName</th>
<th sort_expression="ClassID">CourseNumber</th>
<th sort_expression="ExamStartDate">ExamStartDate</th>
<th sort_expression="ExamEndDate">ExamEndDate</th>
<th sort_expression="ExamDuration">ExamStartTime</th>
<th sort_expression="ExamDuration">ExamEndTime</th>
<?php
include "dbQueries.php";
//error_reporting(E_ALL);
//ini_set('display_errors', 'On');
include_once 'classes/Authentication.php';
include_once 'classes/Database.php';
$db = Database::getDatabase();
Authentication::sec_session_start();
if (Authentication::login_check($db->getMysqli()) == true) {
try {
$dbh = new PDO("mysql:host=mysql2.cs.stonybrook.edu;dbname=sachin", "sachin", "108610059");
} catch (PDOException $e) {
$message = "Couldnt connect to db.";
echo "<script type='text/javascript'>alert('{$message}');</script>";
}
//gets previous information need for the queries and inserts.
$dbh->beginTransaction();
$examStartDate = $_POST[startDate];
$examNetID = $_POST[netID];
$examID = $_POST[examID];
$examDuration = $_POST[examDuration];
$examClassID = $_POST[examClassID];
$term;
$dayOfWeek = date('l', strtotime($examStartDate));
$examTotalTime = intval($examDuration);
$gaptime;
$numSeats;
// gets the last updated room change for the date the appointment is to be scheduled for
$sql = "SELECT * FROM freyhalltestingcenterroom WHERE daysFrom<'{$examStartDate}' AND daysUntil> '{$examStartDate}'; ";
$result = $dbh->prepare($sql);
