sheets());
for($i=0;$i<$sheetCount;$i++)
{
$Reader->ChangeSheet($i);
foreach ($Reader as $Row)
{
$code = "";
if(isset($Row[0])) {
$code = mysqli_real_escape_string($conn,$Row[0]);
}
$fname = "";
if(isset($Row[1])) {
$fname = mysqli_real_escape_string($conn,$Row[1]);
}
$lname = "";
if(isset($Row[2])) {
$lname = mysqli_real_escape_string($conn,$Row[2]);
}
$designation = "";
if(isset($Row[3])) {
$designation = mysqli_real_escape_string($conn,$Row[3]);
}
$father_name = "";
if(isset($Row[4])) {
$father_name = mysqli_real_escape_string($conn,$Row[4]);
}
$gender = "";
if(isset($Row[5])) {
$gender = mysqli_real_escape_string($conn,$Row[5]);
}
$blood_group = "";
if(isset($Row[6])) {
$blood_group = mysqli_real_escape_string($conn,$Row[6]);
}
$primary_phone = "";
if(isset($Row[7])) {
$primary_phone = mysqli_real_escape_string($conn,$Row[7]);
}
$is_first_aider = "";
if(isset($Row[8])) {
$is_first_aider = mysqli_real_escape_string($conn,$Row[8]);
}
if (!empty($code) || !empty($fname) ||!empty($lname) ||!empty($designation) ||!empty($father_name) ||!empty($gender) ||!empty($blood_group) ||!empty($primary_phone) ||!empty($is_first_aider) ) {
$query = "insert into employee(emp_code,fname,lname,designation_id,father_name,gender,blood_group,primary_phone,is_first_aid) values('".$code."','".$fname."','".$lname."','".$designation."','".$father_name."','".$gender."','".$blood_group."','".$primary_phone."','".$is_first_aider."')";
$result = mysqli_query($conn, $query);
if (! empty($result)) {
$type = "success";
$message = "Excel Data Imported into the Database";
} else {
$type = "error";
$message = "Problem in Importing Excel Data";
}
}
}
}
}
else
{
$type = "error";
$message = "Invalid File Type. Upload Excel File.";
}
}
?>
">