} elseif (strcasecmp($reg_no, "major & section:") == 0) { $block = $reg_date; //block name } elseif (strcasecmp($reg_no, "units:") == 0) { $units = $reg_date; } elseif (strcasecmp($reg_no, "time:") == 0) { $time = $reg_date; } elseif (strcasecmp($reg_no, "days:") == 0) { $days = $reg_date; } elseif (strcasecmp($reg_no, "regid") == 0) { break; } } $block_name = $block; $block_id = get_block_id($temp_db_con, $course_code, $class_year_level, $block, $sem_id); $faculty_id = get_faculty_id($temp_db_con, $faculty); $query_class = mysqli_query($temp_db_con, "SELECT class_id FROM class_t WHERE block_id='{$block_id}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND faculty_id='{$faculty_id}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND subject_code='{$subject_code}'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t") or die("Error at upload_student_lis_class.php : line 97 :: " . mysqli_error($temp_db_con)); if (mysqli_num_rows($query_class) > 0) { $row_class = mysqli_fetch_array($query_class); $class_id = $row_class['class_id']; } else { $query_class_add = 'INSERT INTO class_t VALUES("' . '' . '", "' . $faculty_id . '", "' . $sem_id . '", "' . $subject_code . '", "' . $course_code . '", "' . $class_year_level . '", "' . $block_name . '", "' . $block_id . '")'; echo $query_class_add; mysqli_query($temp_db_con, $query_class_add) or die("Error at upload_student_lis_class.php : line 118 :: " . mysqli_error($temp_db_con));
function faculty_id() { echo get_faculty_id(); }
function delete_faculty_link() { return admin_url("faculty.php?action=delete&faculty=" . get_faculty_id()); }