$fileid = "FILE_" . rand(0, 999);
$filename = $_POST['filename'];
$filedesc = $_POST['filedesc'];
$fileuploader = $_POST['file_uploader'];
$user_doc = $_FILES['user_doc']['name'];
$fileuri = "uploads/docs/" . $user_doc;
$filesize = $_FILES['user_doc']['size'];
$temp_loc = $_FILES['user_doc']['tmp_name'];
$upload_time = time();
if (validate_form($filename, $filedesc, $fileuploader, $user_doc)) {
if (move_uploaded_file($temp_loc, $fileuri)) {
include 'db_auth.php';
$link = $conn;
$query = "INSERT INTO uploads values ('{$fileid}','{$filename}','{$filesize}','{$filedesc}','{$fileuploader}','{$upload_time}','{$fileuri}')";
if (mysqli_query($link, $query)) {
increaseCommits("commits", "uploads");
echo "Uploaded successfully<br />";
} else {
/*Delete file from server*/
echo "Your upload was successful but a technical error has caused has caused a revert!<br />";
}
} else {
echo "Error:Upload failed<br />";
}
}
}
function validate_form($filename, $filedesc, $fileuploader, $user_doc)
{
$form_valid = true;
if (empty($filename)) {
$form_valid = false;
$course_code = $_POST['selected_course'];
$exam_date = $_POST['exam_date'];
$exam_start = $_POST['exam_start'];
$exam_duration = $_POST['exam_duration'];
$exam_room = $_POST['exam_room'];
$student_adm_yr = $_POST['student_adm_yr'];
$campus_id = $_POST['campus'];
$faculty_id = $_POST['faculty'];
$department_id = $_POST['department'];
$course_id = $_POST['course'];
if (validate_form($course_code, $exam_type, $exam_room, $exam_date, $exam_start, $exam_duration, $campus_id, $faculty_id, $department_id, $student_adm_yr, $course_id)) {
include 'db_auth.php';
$link = $conn;
$query = "INSERT INTO exams values ('{$course_code}','{$department_id}','{$exam_type}','{$exam_room}','{$exam_date}','{$exam_start}','{$exam_duration}','{$faculty_id}','{$campus_id}','{$student_adm_yr}','{$course_id}')";
if (mysqli_query($link, $query)) {
increaseCommits("commits", "exams");
echo "Exam saved successfully<br />";
} else {
/*Delete file from server*/
echo "Error saving exam!<br />" . mysqli_error($link);
}
}
}
function validate_form($course_code, $exam_type, $exam_room, $exam_date, $exam_start, $exam_duration, $campus_id, $faculty_id, $department_id, $student_adm_yr, $course_id)
{
$form_filled = true;
if (empty($course_code) || $course_code === 'select_student_course') {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Select course</span><br />';
}
if (empty($exam_type) || $exam_type === 'select_exam_type') {
if (isset($_POST['save_lec_info'])) {
$lec_id = "LEC_" . rand(0, 999);
$lec_name = $_POST['lec_name'];
$lec_phone = $_POST['lec_phone'];
$lec_email = $_POST['lec_email'];
$lec_qualification = $_POST['lec_qualification'];
$lec_avator_name = $_FILES['lec_avator']['name'];
$lec_avator_uri = $_FILES['lec_avator']['tmp_name'];
$lec_avator_upload_uri = "uploads/images/avators/lec/" . $lec_avator_name;
if (validate_form($lec_name, $lec_phone, $lec_email, $lec_qualification, $lec_avator_name)) {
if (move_uploaded_file($lec_avator_uri, $lec_avator_upload_uri)) {
include 'db_auth.php';
$link = $conn;
$query = "INSERT INTO lecturer values ('{$lec_id}','{$lec_name}','{$lec_email}','{$lec_phone}','{$lec_avator_upload_uri}','{$lec_qualification}')";
if (mysqli_query($link, $query)) {
increaseCommits("commits", "lecturer");
echo "Lecturer added successfully<br />";
} else {
/*Delete file from server*/
echo "Your upload was successful but a technical error has caused has caused a revert!<br />" . mysqli_error($link);
}
} else {
echo "Error:Upload failed<br />";
}
}
}
function validate_form($lec_name, $lec_phone, $lec_email, $lec_qualification, $lec_avator_name)
{
$form_valid = true;
if (empty($lec_name)) {
$form_valid = false;
if (isset($_POST['add_assignments'])) {
$assignment_no = $_POST['assignment_no'];
$submission_date = $_POST['submission_date'];
$selected_course = $_POST['selected_course'];
$campus_id = $_POST['campus'];
$faculty_id = $_POST['faculty'];
$department_id = $_POST['department'];
$course_id = $_POST['course'];
$student_adm_yr = $_POST['student_adm_yr'];
if (validate_form($campus_id, $faculty_id, $department_id, $course_id, $student_adm_yr, $assignment_no, $submission_date, $selected_course)) {
include 'db_auth.php';
$link = $conn;
$query = "INSERT INTO assignments values ('{$selected_course}','{$submission_date}','{$assignment_no}','{$department_id}','{$student_adm_yr}','{$faculty_id}','{$campus_id}','{$course_id}')";
if (mysqli_query($link, $query)) {
increaseCommits("commits", "assignments");
echo "Assignment saved successfully<br />";
} else {
/*Delete file from server*/
echo "Error assignment br />";
}
}
} else {
echo "Cannot save.";
}
function validate_form($campus_id, $faculty_id, $department_id, $course_id, $student_adm_yr, $assignment_no, $submission_date, $selected_course)
{
$form_filled = true;
if (empty($campus_id) || $campus_id == "select_campus") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';
$link = $conn;
if ($cb_campuses == "true") {
$campus_id = "ALL";
}
if ($cb_faculties == "true") {
$faculty_id = "ALL";
}
if ($cb_departments == "true") {
$department_id = "ALL";
}
if ($cb_courses == "true") {
$course_id = "ALL";
}
$query = "INSERT INTO notifications values ('{$notification_id}','{$notification_title}','{$notification_message}','{$notification_send_time}','{$notification_sender}','{$department_id}','{$faculty_id}','{$campus_id}','{$student_adm_yr}','{$course_id}')";
if (mysqli_query($link, $query)) {
increaseCommits("commits", "notifications");
echo "Notification added successfully<br />";
} else {
/*Delete file from server*/
echo "Error adding notification!<br />";
}
}
}
function validate_form($campus_id, $faculty_id, $department_id, $course_id, $student_adm_yr, $notification_title, $notification_message, $notification_sender)
{
$form_filled = true;
if (empty($campus_id) || $campus_id == "select_campus") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';
}
if (empty($faculty_id) || $faculty_id === "select_faculty") {
if (mysqli_query($conn, $sql)) {
echo '<span style="color:#00FF00;font-family:monospace;" >Thursday class added successfully</span><br />';
} else {
echo '<span style="color:#00FF00;font-family:monospace;" >Error adding thursday classes</span><br />';
}
}
if ($friday == "1") {
$class_days = "5";
$sql = "INSERT INTO classes values ('{$selected_course}','{$selected_lec}','{$class_room}','{$friday_start}','{$friday_stop}','{$class_days}','{$student_adm_yr}','{$department_id}','{$faculty_id}','{$campus_id}','{$course_id}')";
if (mysqli_query($conn, $sql)) {
echo '<span style="color:#00FF00;font-family:monospace;" >Friday class added successfully</span><br />';
} else {
echo '<span style="color:#00FF00;font-family:monospace;" >Error adding friday classes</span><br />';
}
}
increaseCommits("commits", "classes");
}
}
function validate_form($campus_id, $faculty_id, $department_id, $course_id, $student_adm_yr, $selected_course, $selected_lec, $class_room, $monday, $monday_start, $monday_stop, $tuesday, $tuesday_start, $tuesday_stop, $wednesday, $wednesday_start, $wednesday_stop, $thursday, $thursday_start, $thursday_stop, $friday, $friday_start, $friday_stop)
{
$form_filled = true;
if (empty($campus_id) || $campus_id == "select_campus") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';
}
if (empty($faculty_id) || $faculty_id === "select_faculty") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Faculty name.</span><br />';
}
if (empty($department_id) || $department_id == "select_department") {
$form_filled = false;
<?php
if (isset($_POST['add_varsity_campuses'])) {
$campus_name = $_POST['campus_name'];
if (validate_form($campus_name)) {
include 'db_auth.php';
$campus_id = generate_campus_id();
$query = "insert into campus values('{$campus_id}','{$campus_name}')";
if ($result = mysqli_query($conn, $query)) {
increaseCommits("commits", "campus");
echo "campus added";
} else {
echo "Could not add the campus \"" . $campus_name . "\"";
}
}
}
function validate_form($campus_name)
{
$form_filled = true;
if (empty($campus_name)) {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing campus name.</span><br />';
}
return $form_filled;
}
function generate_campus_id()
{
include 'db_auth.php';
$campus_id = "campus_" . rand(0, 999);
$existing_ids = mysqli_num_rows(mysqli_query($conn, "select `campus`.`campus_id` from `campus` where `campus`.`campus_id`='{$campus_id}'"));
switch ($existing_ids) {
<?php
if (isset($_POST['add_school_departments'])) {
$campus_id = $_POST['campus'];
$faculty_id = $_POST['faculty'];
$department_name = $_POST['department_name'];
if (validate_form($campus_id, $faculty_id, $department_name)) {
include 'db_auth.php';
$department_id = generate_department_id();
$query = "insert into departments values('{$department_id}','{$department_name}','{$faculty_id}','{$campus_id}')";
if ($result = mysqli_query($conn, $query)) {
increaseCommits("commits", "departments");
echo "Deparment added";
} else {
echo "Could not add the department \"" . $department_name . "\"";
}
}
}
function validate_form($campus_id, $faculty_id, $department_name)
{
$form_filled = true;
if (empty($campus_id) || $campus_id == "select_campus") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';
}
if (empty($faculty_id) || $faculty_id === "select_faculty") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Faculty name.</span><br />';
}
if (empty($department_name)) {
$form_filled = false;
if (isset($_POST['add_course'])) {
$course_code = $_POST['course_code'];
$course_name = $_POST['course_name'];
$course_lec = $_POST['course_lec'];
$student_adm_yr = $_POST['student_adm_yr'];
$course_id = $_POST['course'];
$campus_id = $_POST['campus'];
$faculty_id = $_POST['faculty'];
$department_id = $_POST['department'];
if (validate_form($campus_id, $faculty_id, $department_id, $course_id, $course_code, $course_lec, $course_name, $student_adm_yr)) {
include 'db_auth.php';
$link = $conn;
$query = "INSERT INTO courses values ('{$course_code}','{$course_name}','{$course_lec}','{$department_id}','{$faculty_id}','{$campus_id}','{$student_adm_yr}','{$course_id}')";
if (mysqli_query($link, $query)) {
increaseCommits("commits", "courses");
echo "Course saved successfully<br />";
} else {
/*Delete file from server*/
echo "Error saving course!<br />" . mysqli_error($link);
}
}
}
function validate_form($campus_id, $faculty_id, $department_id, $course_id, $course_code, $course_lec, $course_name, $student_adm_yr)
{
$form_filled = true;
if (empty($campus_id) || $campus_id == "select_campus") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';
}
if (empty($faculty_id) || $faculty_id === "select_faculty") {
$link = $conn;
if ($cb_campuses == "1") {
$campus_id = "ALL";
}
if ($cb_faculties == "1") {
$faculty_id = "ALL";
}
if ($cb_departments == "1") {
$department_id = "ALL";
}
if ($cb_courses == "1") {
$course_id = "ALL";
}
$query = "INSERT INTO downloads values ('{$course_code}','{$fileid}','{$department_id}','{$faculty_id}','{$campus_id}','{$student_adm_yr}','{$course_id}')";
if (mysqli_query($link, $query)) {
increaseCommits("commits", "downloads");
echo "Download saved successfully<br />";
} else {
/*Delete file from server*/
echo "Error saving download br />";
}
}
}
function validate_form($campus_id, $faculty_id, $department_id, $course_id, $student_adm_yr, $course_code, $fileid)
{
$form_filled = true;
if (empty($campus_id) || $campus_id == "select_campus") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';
}
if (empty($faculty_id) || $faculty_id === "select_faculty") {
<?php
if (isset($_POST['add_school_faculties'])) {
$faculty_name = $_POST['faculty_name'];
$campus_id = $_POST['campus'];
if (validate_form($faculty_name, $campus_id)) {
include 'db_auth.php';
$faculty_id = generate_faculty_id();
$query = "insert into faculty values('{$faculty_id}','{$faculty_name}','{$campus_id}')";
if ($result = mysqli_query($conn, $query)) {
increaseCommits("commits", "faculty");
echo "Faculty added";
} else {
echo "Could not add the faculty \"" . $faculty_name . "\"";
}
}
}
function validate_form($faculty_name, $campus_id)
{
$form_filled = true;
if (empty($faculty_name)) {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Faculty name.</span><br />';
}
if (empty($campus_id) || $campus_id == "select_campus") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';
}
return $form_filled;
}
function generate_faculty_id()
<?php
if (isset($_POST['add_school_courses'])) {
$course_code = $_POST['course_code'];
$course_name = $_POST['course_name'];
$campus_id = $_POST['campus'];
$faculty_id = $_POST['faculty'];
$department_id = $_POST['department'];
if (validate_form($campus_id, $faculty_id, $department_id, $course_code, $course_name)) {
include 'db_auth.php';
$link = $conn;
$query = "INSERT INTO school_courses values ('{$course_code}','{$course_name}','{$department_id}','{$faculty_id}','{$campus_id}')";
if (mysqli_query($link, $query)) {
increaseCommits("commits", "school_courses");
echo "School course saved successfully<br />";
} else {
/*Delete file from server*/
echo "Error saving school course!<br />" . mysqli_error($link);
}
}
}
function validate_form($campus_id, $faculty_id, $department_id, $course_code, $course_name)
{
$form_filled = true;
if (empty($campus_id) || $campus_id == "select_campus") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';
}
if (empty($faculty_id) || $faculty_id === "select_faculty") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Faculty name.</span><br />';
$full_name = $_POST['full_name'];
$pursuing_course = "";
$phonenumber = $_POST['phonenumber'];
$email = $_POST['email'];
$student_category = $_POST['student_category'];
$campus_id = $_POST['campus'];
$faculty_id = $_POST['faculty'];
$department_id = $_POST['department'];
$course_id = $_POST['course'];
$student_adm_yr = $_POST['student_adm_yr'];
$pursuing_course = $course_id;
if (validateStudent($campus_id, $faculty_id, $department_id, $course_id, $student_adm_yr, $reg_no, $full_name, $pursuing_course, $phonenumber, $email, $student_category)) {
$query = "insert into students values ('{$reg_no}','{$full_name}','{$pursuing_course}','{$department_id}','{$phonenumber}','{$email}','{$student_category}','{$student_adm_yr}','{$faculty_id}','{$campus_id}');";
include 'db_auth.php';
if (mysqli_query($conn, $query)) {
increaseCommits("commits", "students");
echo "Student added successfully<br />";
} else {
echo '<span style="color:#FF0000;">Error. Student could not be added.</span><br />';
}
}
} else {
echo "NOT SET";
}
function validateStudent($campus_id, $faculty_id, $department_id, $course_id, $student_adm_yr, $reg_no, $full_name, $pursuing_course, $phonenumber, $email, $student_category)
{
$form_filled = true;
if (empty($campus_id) || $campus_id == "select_campus") {
$form_filled = false;
echo '<span style="color:#FF0000;font-family:monospace;" >Missing Campus name.</span><br />';
}
