<?php
include("../include/config.inc.php");
$conn = $con;
require_once('spreadsheet-reader-master/php-excel-reader/excel_reader2.php');
require_once('spreadsheet-reader-master/SpreadsheetReader.php');

if (isset($_POST["import"]))
{
       
  $allowedFileType = ['application/vnd.ms-excel','text/xls','text/xlsx','application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'];
  
  if(in_array($_FILES["file"]["type"],$allowedFileType)){

        $targetPath = 'uploads/'.$_FILES['file']['name'];
        move_uploaded_file($_FILES['file']['tmp_name'], $targetPath);
        
        $Reader = new SpreadsheetReader($targetPath);
        
        $sheetCount = count($Reader->sheets());
        
        $course_id=$_REQUEST['course_id'];
        $session_id=$_REQUEST['session_id'];
        for($i=0;$i<$sheetCount;$i++)
        {
            if($i==1){
                break;
            }
            $Reader->ChangeSheet($i);
            $x=0;
            foreach ($Reader as $Row)
            {$x++;
                if(!empty($Row[0])) {
                    $student_name = mysqli_real_escape_string($conn,$Row[0]);
                    $gender = mysqli_real_escape_string($conn,$Row[1]);
                    $mobile = mysqli_real_escape_string($conn,$Row[2]);
                    echo "$x".$gender."hello<br>";
                $query = "insert into register (course_id,session_id,student_name,gender,student_mobile) 
                        values('$course_id','$session_id',
                    '$student_name','$gender','$mobile')";
                $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.";
  }
}
?>