if ($semesterTargetArray != "") { database_table_create($CLASSROOM_TABLE_NAME, $CLASSROOM_TABLE_KEY_NAMES_ARRAY, $CLASSROOM_TABLE_KEY_TYPES_ARRAY); } //ADD the information to database if POST print $_POST['CLASSROOM_NAME']; if ($_POST["classroomInfoAdd"]) { //Load the POST info array foreach ($CLASSROOM_TABLE_KEY_NAMES_ARRAY as $value) { $classroomInfoArray[$value] = $_POST[$value]; } unset($value); table_data_add($CLASSROOM_TABLE_NAME, $CLASSROOM_TABLE_KEY_NAMES_ARRAY, $classroomInfoArray); } //DELETE the information from database if POST if ($_POST["classroomListDelete"]) { table_data_delete_by_id($CLASSROOM_TABLE_NAME, $targetId); } //CHANGE the information to database if POST if ($_POST["classroomInfoChanged"]) { foreach ($CLASSROOM_TABLE_KEY_NAMES_ARRAY as $value) { $classroomInfoChangeArray[$value] = $_POST[$CLASSROOM_TABLE_KEY_NAMES_ARRAY[$value]]; } unset($value); table_data_change($CLASSROOM_TABLE_NAME, $CLASSROOM_TABLE_KEY_NAMES_ARRAY, $targetId, $classroomInfoChangeArray); } //REQUERY the $classroomListArray for display $classroomListArray = table_data_query($CLASSROOM_TABLE_NAME, $CLASSROOM_TABLE_KEY_NAMES_ARRAY); //------ -[ Views Functions ]- ------ div_head_output_with_class_option("mainMiddle"); //Print Main Title main_title_output($PAGE_INFO_ARRAY, $PAGE_SWITCH);
database_table_create($TEACHER_TABLE_NAME, $TEACHER_TABLE_KEY_NAMES_ARRAY, $TEACHER_TABLE_KEY_TYPES_ARRAY); } //ADD the information to database if POST print $_POST['TEACHER_NAME']; if ($_POST["teacherInfoAdd"]) { //Load the POST info array foreach ($TEACHER_TABLE_KEY_NAMES_ARRAY as $value) { $teacherInfoArray[$value] = $_POST[$value]; } var_dump($teacherInfoArray); unset($value); table_data_add($TEACHER_TABLE_NAME, $TEACHER_TABLE_KEY_NAMES_ARRAY, $teacherInfoArray); } //DELETE the information from database if POST if ($_POST["teacherListDelete"]) { table_data_delete_by_id($TEACHER_TABLE_NAME, $targetId); } //CHANGE the information to database if POST if ($_POST["teacherInfoChanged"]) { foreach ($TEACHER_TABLE_KEY_NAMES_ARRAY as $value) { $teacherInfoChangeArray[$value] = $_POST[$value]; } unset($value); table_data_change($TEACHER_TABLE_NAME, $TEACHER_TABLE_KEY_NAMES_ARRAY, $targetId, $teacherInfoChangeArray); } //REQUERY the $teacherListArray for display $teacherListArray = table_data_query($TEACHER_TABLE_NAME, $TEACHER_TABLE_KEY_NAMES_ARRAY); //------ -[ Views Functions ]- ------ div_head_output_with_class_option("mainMiddle"); //Print Main Title main_title_output($PAGE_INFO_ARRAY, $PAGE_SWITCH);
//Load $studentsScheduleArray $STUDENTS_SCHEDULE_TABLE_NAME = table_name_form($PAGE_INFO_ARRAY, $STUDENTS_SCHEDULE_PAGE_SWITCH, $semesterListArray, $semesterTargetArray); $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY = $TABLE_KEY_NAMES_ARRAY[$STUDENTS_SCHEDULE_PAGE_SWITCH]; $STUDENTS_SCHEDULE_TABLE_KEY_TYPES_ARRAY = $TABLE_KEY_TYPES_ARRAY[$STUDENTS_SCHEDULE_PAGE_SWITCH]; //Database Query menthod if ($_POST['classListQuery']) { $studentsScheduleArray = table_data_query($STUDENTS_TABLE_NAME, $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY); } //Database Delete method //TODO: Test this method. if ($_POST['classListDelete']) { $studentsScheduleArray = table_data_query($STUDENTS_TABLE_NAME, $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY); $studentsScheduleArrayCount0 = count($studentsScheduleArray); for ($i = 0; $i < $studentsScheduleArrayCount0; $i++) { $targetDeleteId = $studentsScheduleArray[$i]['id']; table_data_delete_by_id($STUDENTS_SCHEDULE_TABLE_NAME, $targetDeleteId); } } //Create the dataabse table. database_table_create($STUDENTS_SCHEDULE_TABLE_NAME, $STUDENTS_SCHEDULE_TABLE_KEY_NAMES_ARRAY, $STUDENTS_SCHEDULE_TABLE_KEY_TYPES_ARRAY); //Load target class name. $classTargetArray = $_POST['classList']; //Reschedule determinative syntax if ($_POST['RESCHEDULE']) { $targetClassName = $classListArray[$classTargetArray]['CLASS_NAME']; //Load $courseWeekArray //$courseWeekArray structure describe //$courseWeekArray[0] = 0; // [1] = 2; //... $targetClassListArrayTemp = table_data_query($CLASS_TABLE_NAME, $CLASS_TABLE_KEY_NAMES_ARRAY, "CLASS_NAME = '{$targetClassName}'");