<?php
@session_start();
include_once "../db/db.php";
include "actions/class_functions.php";
include "actions/subject_functions.php";
//require "actions/sched_functions.php";
$msg = NULL;
if (isset($_POST['add'])) {
$section = $_GET['section_id'];
$subject = $_POST['subject'];
$sy_id = get_active_sy();
$teacher = $_POST['teacher'];
if ($section) {
if (does_yr_level_match($section, $subject)) {
if (is_available($section, $subject, $teacher)) {
if (!($msg = is_teacher_max($teacher, $subject))) {
//is_unit_maxed($lvl_id, 0, $subject_unit)
//$subject_unit = $_POST['subject_unit'];
mysql_query("INSERT INTO class_t VALUES('','{$section}', '{$sy_id}', '{$subject}',{$teacher})") or die(mysql_error());
mysql_query("COMMIT;");
//header("location: subjects.php?curriculum_code={$get_curriculum_code}");
$msg = "SUCCESS!";
} else {
//$msg = "Units maxed out.";
}
} else {
$msg = "Class Already Exists";
}
} else {
$msg = "Year level does not match.";
}
<?php
@session_start();
if (isset($_POST['add_load'])) {
$load_id = '';
//$section_id = $_POST['section_menu'];
$subject_code = $_POST['subject_menu'];
$room_no = $_POST['room_menu'];
$emp_id = $_POST['teacher_menu'];
if (isset($_POST['day_menu'])) {
//$days = array($_POST['day_menu']);
$time_index = $_POST['time_menu'];
$start_time = $start_times[$time_index] . ":00";
$end_time = $end_times[$time_index] . ":00";
if ($start_time < $end_time) {
if (!($msg = is_loaded())) {
if (!($msg = is_teacher_max($emp_id, $subject_code))) {
if (!($msg = is_subj_max($section_id, $subject_code))) {
foreach ($_POST['day_menu'] as $day) {
$sy_id = get_school_yr();
mysql_query("START TRANSACTION;");
mysql_query("INSERT INTO class_schedule_temp_t \n\t\t\t\t\t\t\t\t\t\t\t VALUES ('', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$section_id}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$subject_code}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$room_no}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$emp_id}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$day}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$start_time}', \n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$end_time}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t '{$sy_id}');") or die("error po {$start_time} ");
mysql_query("COMMIT;");
}
$msg = "Successfuly added Load";
}
//else
//$msg = "hello";
}
//else
//$msg = "Teacher has reached maximum loads available";
} else {
