$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 />'; }