$f_name .= $name . " ";
} else {
$m_name .= $name . " ";
}
}
$reg_date = date("Y-m-d", strtotime($reg_date));
#identify gender
$gender = $gender == "M" ? "Male" : "Female";
#initialize status
$status = is_numeric(stripos($status, "regular")) ? "regular" : "irregular";
$birthdate = NULL;
$address = NULL;
//$student_id =get_student_id($db_con, $student_id, $student_name, $gender, $age, $status);
$student_id = insert_student($db_con, $student_id, $f_name, $m_name, $l_name, $gender, $birthdate, $address, $status);
//echo $reg_no."<br>";
$reg_no = insert_reg($db_con, $student_id, $reg_no, $reg_date, $year_level, $program, $sem_id);
}
echo "Finnished Uploading File.";
$_SESSION['kiosk']['error'] = 1;
header("location: " . $referer);
} else {
echo "No file selected <br />";
}
}
function verify_student_list_file($allDataInSheet, $len)
{
echo "verifying student load file...<br>";
$valid = 0;
$check = ["A" => "RegID", "B" => "Reg.Date", "C" => "Student No.", "D" => "Student's Full Name", "E" => "Gender", "F" => "Age", "G" => "Program", "H" => "YearLevel", "I" => "ValidationDate", "J" => "ORNo", "K" => "Load Status"];
for ($i = 1; $i <= $len; $i++) {
$entry = trim($allDataInSheet[$i]["A"]);
$status = $row_personnel_src['status'];
insert_personnel($dest_db_con, $personnel_id, $f_name, $m_name, $l_name, $gender, $academic_rank, $status, $b_day);
$count++;
}
echo "Copy personnel success :: {$count} entries<br>";
$count = 0;
#Copy Student Registration data
$query_reg_src = mysqli_query($src_db_con, "SELECT * FROM student_registration_t") or die("Error in save_content.php : line 68 :: " . mysql_error($src_db_con));
while ($row_reg_src = mysqli_fetch_array($query_reg_src)) {
$reg_no = $row_reg_src['reg_no'];
$student_id = $row_reg_src['student_id'];
$reg_date = $row_reg_src['reg_date'];
$sem_id = $row_reg_src['sem_id'];
$course_code = $row_reg_src['course_code'];
$year_level = $row_reg_src['year_level'];
insert_reg($dest_db_con, $student_id, $reg_no, $reg_date, $year_level, $course_code, $sem_id);
$count++;
}
echo "Copy student registration success :: {$count} entries<br>";
$count = 0;
#Copy class data
$query_class_src = mysqli_query($src_db_con, "SELECT * FROM class_t") or die("Error in save_content.php : line 82 :: " . mysql_error($src_db_con));
while ($row_class_src = mysqli_fetch_array($query_class_src)) {
$subject_id = $row_class_src['subject_id'];
$faculty_id = $row_class_src['faculty_id'];
$block_id = $row_class_src['block_id'];
$sem_id = $row_class_src['sem_id'];
insert_class($dest_db_con, $subject_id, $faculty_id, $block_id, $sem_id);
$count++;
}
echo "Copy class success :: {$count} entries<br>";
