<?php

$student_admission_number = "";

if($_SERVER["REQUEST_METHOD"] == "POST" && (($_POST["submit"] == "upload_result") || ($_POST["submit"] == "update_result")) )
{


	if(isset($_FILES['fileUpload']['name'])) 
	{
 		$file = $_FILES["fileUpload"]["tmp_name"];

 		$objPHPExcel = PHPExcel_IOFactory::load("$file");  

    foreach ($objPHPExcel->getWorksheetIterator() as $worksheet)
    {
      $highestRow = $worksheet->getHighestRow();
      

      for ($row=8; $row <= $highestRow ; $row++) { 
        # code...


        $student_admission_number = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(0, $row)->getValue());

         $class = strtoupper(mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(4, $row)->getValue())); 
        
         $level = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(5, $row)->getValue()); 
        if($class == 'SSS')
        {

           $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(8, 7)->getValue());

          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(8, $row)->getValue());
         
          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
        
        elseif($class == 'SHS')
        {


 $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(8, 7)->getValue());

          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(8, $row)->getValue());
          
          
          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
        
        elseif($class == 'JSS' )
        {
               $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, 7)->getValue());
            
          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, $row)->getValue());

          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
        
        
     elseif($class == 'JHS' )
        {
               $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, 7)->getValue());
            
          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, $row)->getValue());

          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
        

    elseif($class == 'NURSERY' || $class == 'RECEPTION'  )
        {

               $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, 7)->getValue());
            
          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, $row)->getValue());
          
          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
    
        elseif($class == 'PRE-NURSERY' )
        {

               $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, 7)->getValue());
            
          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, $row)->getValue());

          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
    

    elseif($class == 'KINDERGARTEN')
        {
               $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, 7)->getValue());
            
          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, $row)->getValue());
         

          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
    
        
    elseif($class == 'PRIMARY')
        {
                  $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, 7)->getValue());
            
          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, $row)->getValue());
         

          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
    
         elseif($class == 'GRADE')
        {
               $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, 7)->getValue());
            
          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, $row)->getValue());
          
          
          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
        
        
      elseif($class == 'YEAR')
        {
               $subject_titles = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, 7)->getValue());
            
          $subject = (int)mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(7, $row)->getValue());
          
          
          $academic_year = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 2)->getValue());
          $term_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 3)->getValue());
          $result_type = mysqli_real_escape_string($conx, $worksheet->getCellByColumnAndRow(1, 5)->getValue());
        }
        
        
        if($student_admission_number != "" || !empty($student_admission_number))
        {


          $search_num_query = "SELECT DISTINCT student_admission_number, current_class, current_level FROM registered_students WHERE student_admission_number ='$student_admission_number'";

          $search_num_result = mysqli_query($conx, $search_num_query);

          $search_num_num = mysqli_num_rows($search_num_result);
          $search_num_row = mysqli_fetch_assoc($search_num_result);


          if ($search_num_num > 0 && $search_num_row['current_class'] == $class && $search_num_row['current_level'] == $level) {


              $tablename = strtolower($class).'_result';
               if($tablename == "pre-nursery_result")
              {
                  $tablename = "nursery_result";
              }
               if($tablename == "reception_result")
              {
                  $tablename = "nursery_result";
              }
               if($tablename == "year_result")
              {
                  $tablename = "primary_result";
              }
               if($tablename == "grade_result")
              {
                  $tablename = "primary_result";
              }
            if($_POST['result_status'] == 'import')
            {


$search_query = "SELECT * FROM $tablename WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

            $search_result = mysqli_query($conx, $search_query);

            $row_num = mysqli_num_rows($search_result);
      
            if($row_num == 0)
                        {

    	        if($class == 'SSS')
    	        {
    	            $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
                         if(mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
    	        }
    	        
    	        elseif($class == 'SHS')
    	        {
    	            $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
                         if(mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
    	        }
    	        
    	        elseif($class == 'PRIMARY' ){
    	            $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
                         if($rp = mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
    	        }
          
           elseif($class == 'GRADE' ){
    	            $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
                         if($rp = mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
    	        }
 
          elseif($class == 'YEAR' ){
    	            $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
                         if($rp = mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
    	        }
          
           elseif($class == 'NURSERY' || $class == 'RECEPTION' ){
               
                   $chkcol = "SELECT * FROM $tablename LIMIT 1";
$val_chkcol = mysqli_query($conx, $chkcol);

$value_chkcol = mysqli_fetch_assoc($val_chkcol);
if(!isset($value_chkcol['Religion_and_National_Value']))
{

  $addcol = "ALTER TABLE $tablename ADD `Religion_and_National_Value` INT(3) NOT NULL AFTER `HANDWRITING`, ADD `Current_Affairs` INT(3) NOT NULL AFTER `Religion_and_National_Value`, ADD `Spellings` INT(3) NOT NULL AFTER `Current_Affairs`,ADD `Computer` INT(3) NOT NULL AFTER `Spellings`";
mysqli_query($conx, $addcol);
    
}
if(!isset($value_chkcol['next_resumption_date']))
{

  $addcol = "ALTER TABLE $tablename ADD `next_resumption_date` INT(3) NOT NULL AFTER `result_type`";
mysqli_query($conx, $addcol);
    
} 
               
    	            $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
                         if(mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
    	        }

 elseif($class == 'PRE-NURSERY' ){
     
  $chkcol = "SELECT * FROM $tablename LIMIT 1";
$val_chkcol = mysqli_query($conx, $chkcol);

$value_chkcol = mysqli_fetch_assoc($val_chkcol);
if(!isset($value_chkcol['Religion_and_National_Value']))
{

  $addcol = "ALTER TABLE $tablename ADD `Religion_and_National_Value` INT(3) NOT NULL AFTER `HANDWRITING`, ADD `Current_Affairs` INT(3) NOT NULL AFTER `Religion_and_National_Value`, ADD `Spellings` INT(3) NOT NULL AFTER `Current_Affairs`,ADD `Computer` INT(3) NOT NULL AFTER `Spellings`";
mysqli_query($conx, $addcol);
    
}
if(!isset($value_chkcol['next_resumption_date']))
{

  $addcol = "ALTER TABLE $tablename ADD `next_resumption_date` INT(3) NOT NULL AFTER `result_type`";
mysqli_query($conx, $addcol);
    
} 
     
     
    	             $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
                         if(mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
    	        }

 
                   elseif($class == 'KINDERGARTEN'){
                       
                       
$chkcol = "SELECT * FROM $tablename LIMIT 1";
$val_chkcol = mysqli_query($conx, $chkcol);

$value_chkcol = mysqli_fetch_assoc($val_chkcol);
if(!isset($value_chkcol['Phonics']))
{

  $addcol = "ALTER TABLE $tablename ADD `Phonics` INT(3) NOT NULL AFTER `Rhymes`, ADD `Picture_Reading` INT(3) NOT NULL AFTER `Phonics`, ADD `Moral_Instruction` INT(3) NOT NULL AFTER `Picture_Reading`,ADD `Spellings` INT(3) NOT NULL AFTER `Moral_Instruction`,ADD `Current_affairs` INT(3) NOT NULL AFTER `Spellings`";
mysqli_query($conx, $addcol);
    
}
if(!isset($value_chkcol['next_resumption_date']))
{

  $addcol = "ALTER TABLE $tablename ADD `next_resumption_date` INT(3) NOT NULL AFTER `result_type`";
mysqli_query($conx, $addcol);
    
} 
                       
    	             $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
                         if(mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
    	        }  
          
           elseif($class == 'JHS' ){

    	            $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
                         if(mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
    	        }
          elseif($class == 'JSS' ){

    	             $query = "INSERT INTO $tablename (class,level,student_admission_number,$subject_titles,academic_year,term_type,result_type) VALUES ('$class','$level','$student_admission_number','$subject','$academic_year','$term_type','$result_type')";
    
              
                         if(mysqli_query($conx, $query))
           {
              $msg = "New student result(s) added!!!";
}
else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
              
    	        }
            }
            else
{
    $msg = "Error: upload failed contact eSchool administrator!!!";
}
            }
            
            elseif($_POST['result_status'] == 'update') {
                $search_query = "SELECT * FROM $tablename WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

            $search_result = mysqli_query($conx, $search_query);

            $row_num = mysqli_num_rows($search_result);
                if($row_num > 0)
                        {

                
                if($class == 'SSS' )
              {
                  $query = "UPDATE $tablename SET class='$class',level='$level',student_admission_number='$student_admission_number',$subject_titles = '$subject' WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

           if(mysqli_query($conx, $query))
           {
              $msg_u = "Student result(s) updated!!!";
}
else
{
    $msg_u = "Error: update failed contact eSchool administrator!!!";
}

              }
              

 elseif($class == 'SHS' )
              {
                  $query = "UPDATE $tablename SET class='$class',level='$level',student_admission_number='$student_admission_number',$subject_titles = '$subject' WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";


           if(mysqli_query($conx, $query))
           {
              $msg_u = "Student result(s) updated!!!";
}
else
{
    $msg_u = "Error: update failed contact eSchool administrator!!!";
}

              }
              

              elseif($class == 'PRIMARY' ){

                 $query = "UPDATE $tablename SET class='$class',level='$level',student_admission_number='$student_admission_number',$subject_titles = '$subject' WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

           if($pr = mysqli_query($conx, $query))
           {
              $msg_u = "Student result(s) updated!!!";
}
else
{
    $msg_u = "Error: update failed contact eSchool administrator!!!";
}


              }   
              
            elseif($class == 'GRADE' ){

                 $query = "UPDATE $tablename SET class='$class',level='$level',student_admission_number='$student_admission_number',$subject_titles = '$subject' WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

           if(mysqli_query($conx, $query))
           {
              $msg_u = "Student result(s) updated!!!";
}
else
{
    $msg_u = "Error: update failed contact eSchool administrator!!!";
}


              }      
               elseif($class == 'NURSERY' || $class == 'RECEPTION'  ){
                   
                      $chkcol = "SELECT * FROM $tablename LIMIT 1";
$val_chkcol = mysqli_query($conx, $chkcol);

$value_chkcol = mysqli_fetch_assoc($val_chkcol);
if(!isset($value_chkcol['Religion_and_National_Value']))
{

  $addcol = "ALTER TABLE $tablename ADD `Religion_and_National_Value` INT(3) NOT NULL AFTER `HANDWRITING`, ADD `Current_Affairs` INT(3) NOT NULL AFTER `Religion_and_National_Value`, ADD `Spellings` INT(3) NOT NULL AFTER `Current_Affairs`,ADD `Computer` INT(3) NOT NULL AFTER `Spellings`";
mysqli_query($conx, $addcol);
    
}
if(!isset($value_chkcol['next_resumption_date']))
{

  $addcol = "ALTER TABLE $tablename ADD `next_resumption_date` INT(3) NOT NULL AFTER `result_type`";
mysqli_query($conx, $addcol);
    
} 
                   

                 $query = "UPDATE $tablename SET class='$class',level='$level',student_admission_number='$student_admission_number',$subject_titles = '$subject' WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

           if(mysqli_query($conx, $query))
           {
              $msg_u = "Student result(s) updated!!!";
}
else
{
    $msg_u = "Error: update failed contact eSchool administrator!!!";
}


              }   

 elseif($class == 'PRE-NURSERY' ){

    $chkcol = "SELECT * FROM $tablename LIMIT 1";
$val_chkcol = mysqli_query($conx, $chkcol);

$value_chkcol = mysqli_fetch_assoc($val_chkcol);
if(!isset($value_chkcol['Religion_and_National_Value']))
{

  $addcol = "ALTER TABLE $tablename ADD `Religion_and_National_Value` INT(3) NOT NULL AFTER `HANDWRITING`, ADD `Current_Affairs` INT(3) NOT NULL AFTER `Religion_and_National_Value`, ADD `Spellings` INT(3) NOT NULL AFTER `Current_Affairs`,ADD `Computer` INT(3) NOT NULL AFTER `Spellings`";
mysqli_query($conx, $addcol);
    
}
if(!isset($value_chkcol['next_resumption_date']))
{

  $addcol = "ALTER TABLE $tablename ADD `next_resumption_date` INT(3) NOT NULL AFTER `result_type`";
mysqli_query($conx, $addcol);
    
} 


                $query = "UPDATE $tablename SET class='$class',level='$level',student_admission_number='$student_admission_number',$subject_titles = '$subject' WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

           if(mysqli_query($conx, $query))
           {
              $msg_u = "Student result(s) updated!!!";
}
else
{
    $msg_u = "Error: update failed contact eSchool administrator!!!";
}


              }   


           elseif($class == 'KINDERGARTEN'){


$chkcol = "SELECT * FROM $tablename LIMIT 1";
$val_chkcol = mysqli_query($conx, $chkcol);

$value_chkcol = mysqli_fetch_assoc($val_chkcol);
if(!isset($value_chkcol['Phonics']))
{

  $addcol = "ALTER TABLE $tablename ADD `Phonics` INT(3) NOT NULL AFTER `Rhymes`, ADD `Picture_Reading` INT(3) NOT NULL AFTER `Phonics`, ADD `Moral_Instruction` INT(3) NOT NULL AFTER `Picture_Reading`,ADD `Spellings` INT(3) NOT NULL AFTER `Moral_Instruction`,ADD `Current_affairs` INT(3) NOT NULL AFTER `Spellings`";
mysqli_query($conx, $addcol);
    
}
if(!isset($value_chkcol['next_resumption_date']))
{

  $addcol = "ALTER TABLE $tablename ADD `next_resumption_date` INT(3) NOT NULL AFTER `result_type`";
mysqli_query($conx, $addcol);
    
} 


                 $query = "UPDATE $tablename SET class='$class',level='$level',student_admission_number='$student_admission_number',$subject_titles = '$subject' WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

           if(mysqli_query($conx, $query))
           {
              $msg_u = "Student result(s) updated!!!";
}
else
{
    $msg_u = "Error: update failed contact eSchool administrator!!!";
}


              }   

    
elseif($class == 'JSS' ){

                 $query = "UPDATE $tablename SET class='$class',level='$level',student_admission_number='$student_admission_number',$subject_titles = '$subject' WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

            if(mysqli_query($conx, $query))
           {
              $msg_u = "Student result(s) updated!!!";
}
else
{
    $msg_u = "Error: update failed contact eSchool administrator!!!";
}

              }   
              elseif($class == 'JHS' ){

                $query = "UPDATE $tablename SET class='$class',level='$level',student_admission_number='$student_admission_number',$subject_titles = '$subject' WHERE student_admission_number = '$student_admission_number' AND term_type='$term_type' AND result_type = '$result_type' AND academic_year = '$academic_year'";

           if(mysqli_query($conx, $query))
           {
              $msg_u = "Student result(s) updated!!!";
}
else
{
    $msg_u = "Error: update failed contact eSchool administrator!!!";
}
              }   
            }
            }
            else
            {
               $msg_u = "Error: update failed contact eSchool administrator!!!";  
            }
          }

 
            header("Location: $_SERVER[PHP_SELF]?student_import_status=yes&msg=$msg&msg_u=$msg_u");         
        }
       
      }
      
    }
 	}
}
?>