<?php
include ('connect_john.php');	
	$con = new mysqli($hostname,$username,$password,$database);
	if(mysqli_connect_errno()) {
		printf("Failed to Connect to MYSQL", mysqli_connect_error());
		exit();
	}
	$qry_admit= "select * from stddata where `level`='utmeForm'";
	$result = $con->query($qry_admit);
	while ($row=mysqli_fetch_array($result)){
		$value_Olevel=0;
		$jambNo = $row['jambNo'];
		$formNo = $row['formNo'];
		$jambScore = $row['jambScore'];
		$qry_olevel = "select * from preolevel  where formNo='$formNo'";
		$result_olevel = $con->query($qry_olevel);
		$count = $result_olevel->num_rows;
		if ($count>0){
			$all_olevel=$result_olevel->fetch_assoc();
			$olevel=$all_olevel['olevel1'].$all_olevel['olevel2'];
		}else{
			$olevel='';
		}
		$olevelResult=explode(',',$olevel);
		$num=count($olevelResult);
		for ($a=0;$a<$num-1;++$a){
			$splitOlevel=explode('-',$olevelResult[$a]);
			$score=$splitOlevel[1];
			switch ($score){
			case 'A1 ': $realScore=6; break;
			case 'B2 ': $realScore=5; break;
			case 'B3 ': $realScore=4; break;
			case 'C4 ': $realScore=3; break;
			case 'C5 ': $realScore=2; break;
			case 'C6 ': $realScore=1; break;
			default:$realScore=0;
			}
			$value_Olevel+=$realScore;
		}
		$computeA = ($value_Olevel/30) * 100;
		$computeB = $jambScore/4;
		$computedScore = ($computeA + $computeB)/2;
		$qry_compute = "UPDATE `fedpoly`.`stddata` SET  `computedScore` = '$computedScore' WHERE `stddata`.`formNo` = '$formNo'";
		$con->query($qry_compute);						
		}
	header("Location:admission_req.php");
?>