<?php
ob_start();
			 extract($_POST);
			 $schoolName='0';
			  $count1=count($sub1);
 			  $count2=count($sub2);
	
$result1='';
$result2='';
	for ($h=0;$h<9;++$h){
		if (($sub1[$h]!='0' )){
			if (($res1[$h]=='0' )){
				header('location:'.'olevelupdate.php?id=3');
			}
			$result1.= $sub1[$h].'-'.$res1[$h].' , ';
				echo '<br>';
		
		}
	}
	
	for ($h=0;$h<9;++$h){
		if (($sub2[$h]!='0' )){
			
			if (($res2[$h]=='0' )){
				header('location:'.'olevelupdate.php?id=3');
			}
						$result2.= $sub2[$h].'-'.$res2[$h].' , ';

		
		}
	}
		
		echo $result1;
						echo '<br>';
						echo $result2;
				 /*
			 $olevel1=$sub1a.'-'.$res1a.','.$sub2a.'-'.$res2a.','.$sub3a.'-'.$res3a.','.$sub4a.'-'.$res4a.','.$sub5a.'-'.$res5a.','.$sub6a.'-'.$res7a.','.$sub7a.'-'.$res7a.','.$sub8a.'-'.$res8a.','.$sub9a.'-'.$res9a;

			 $olevel2=$sub1b.'-'.$res1b.','.$sub2b.'-'.$res2b.','.$sub3b.'-'.$res3b.','.$sub4b.'-'.$res4b.','.$sub5b.'-'.$res5b.','.$sub6b.'-'.$res7b.','.$sub7b.'-'.$res7b.','.$sub8b.'-'.$res8b.','.$sub9b.'-'.$res9b;

*/
$eYear1=$month1.'/'.$year1;
$eYear2=$month2.'/'.$year2;

if(($examNo1<>"") and ($examNo2<>"")) {
	$noOfResult=2;
}else{
	$noOfResult=1;
}


session_start();
$matNo=$_SESSION['matNo'];
			 require_once('../connect.php');
$db=db_connect();

			 
			 $sql_check="select * from olevel where formNo='$matNo'";
			 $result_check=$db->query($sql_check);
			 $num_check=$result_check->rowCount();
			 if ($num_check>0){
//	$db->query("UPDATE `fedpoly`.`olevel` SET `olevel1` = '$result1', `examNo1` = '$examNo1',`eYear1` = '$eYear1',`schoolName` = 'schoolName',`eType1` = '$eType1',`noOfResult` = '$noOfResult',`olevel2` = '$result2',`examNo2` = '$examNo2',`eYear2` = '$eYear2',`eType2` = '$eType2' WHERE `olevel`.`formNo` = '$matNo'");

                 $aspoaOlevel=$db->prepare("UPDATE `fedpoly`.`olevel` SET `olevel1` = ?, `examNo1` = ?,`eYear1` = ?,`schoolName` = 'schoolName',`eType1` =? ,`noOfResult` =?,`olevel2` = ?,`examNo2` = ?,`eYear2` = ?,`eType2` =?  WHERE `olevel`.`formNo` = ?");
                 $aspoaOlevel->execute([$result1,$examNo1,$eYear1,$eType1,$noOfResult,$result2,$examNo2,$eYear2,$eType2,$matNo]);

                 header('location:'.'olevelupdate.php?id=1');
			 }else{	
			
			 
			 
			 $sql="INSERT INTO `fedpoly`.`olevel` (`sn`, `formNo`, `olevel1`, `examNo1`, `eYear1`, `schoolName`, `eType1`, `noOfResult`, `olevel2`, `examNo2`, `eYear2`, `eType2`) VALUES (NULL, '$matNo', '$result1', '$examNo1', '$eYear1', 'schoolname', '$eType1', '$noOfResult', '$result2', '$examNo2', '$eYear2', '$eType2')";
			 
			 $result=$db->query($sql);
			 		header('location:'.'olevelupdate.php?id=2');
			 }
			 ob_end_flush();
?>