<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 2016-05-07
 * Time: 05:32 PM
 */
ob_start();
//echo $examNo1;
$result1='';
$result2='';
$num_count1=0;
$num_count2=0;
$total_olevel=0;
//echo $sub1[8];
	for ($h=0;$h<=9;++$h){
        if (isset($sub1[$h])){
            if ((isset($res1[$h])) and ($res1[$h]<>'0')) {//and ($res1[$h]=='0' )){
                // header('location:'.'apply.php?id=1');
                //echo 'item';
                    $num_count1+=1;
                $result1 .= $sub1[$h] . '-' . $res1[$h] . ' , ';
                echo '<br>';
            }
        }
    }
//echo $result1;
	for ($h=0;$h<=9;++$h) {
        if (isset($sub2[$h])) {//($sub2[$h]!='0' )){
            if ((isset($res2[$h])) and ($res2[$h] <> '0')) {//($res2[$h]=='0' )){
                //header('location:'.'apply.php?id=1');
                $num_count2 += 1;
                $result2 .= $sub2[$h] . '-' . $res2[$h] . ' , ';
            }
        }
    }
$result1.'='.$num_count1;
$result2.'='.$num_count2;
$_SESSION['total_olevel']=$total_olevel=$num_count1+$num_count2;
//$eYear1=$month1.'/'.$year1;
//$eYear2=$month2.'/'.$year2;

if ($total_olevel==0) {
    header('location:'.'apply.php?id="o_level"');

}else{

    if ($result2<>'') {
        $noOfResult = 2;
//        $material_namePix2=$_FILES['olevelPix2']['name'];
//        if((!$material_namePix2)and ($levelid=="UTME")){
//            header('location:'.'apply.php?id=O_Level');
//            die();
//        }
//        $material_typePix2=$_FILES['olevelPix2']['type'];
//        $material_tmpPix2=$_FILES['olevelPix2']['tmp_name'];
//        $material_sizePix2=$_FILES['olevelPix2']['size'];
//        $oldPix2=$_FILES['olevelPix2']['tmp_name'];
//        $newPix2="../olevelScanned/".$formNo."_2.jpg";
//        move_uploaded_file($oldPix2,$newPix2);



    } else {
        $noOfResult = 1;
    }
    //die();         //require_once('../connect.php');
    $db = db_connect();
    $sql_check = "select * from preolevel where formNo='$formNo'";
    $result_check = $db->query($sql_check);
    $num_check = $result_check->rowCount();
    if ($num_check ==1) {
        $db->query("UPDATE `fedpoly`.`preolevel` SET `olevel1` = '$result1', `examNo1` = '$examNo1',`eYear1` = '$eYear1',`schoolName` = '$schoolName',`eType1` = '$eType1',`noOfResult` = '$noOfResult',`olevel2` = '$result2',`examNo2` = '$examNo2',`eYear2` = '$eYear2',`eType2` = '$eType2' WHERE `preolevel`.`formNo` = '$formNo'");
    } else {
         $sql = "INSERT INTO `fedpoly`.`preolevel` (`sn`, `formNo`, `olevel1`, `examNo1`, `eYear1`, `schoolName`, `eType1`, `noOfResult`, `olevel2`, `examNo2`, `eYear2`, `eType2`)
VALUES (NULL, '$formNo', '$result1', '$examNo1', '$eYear1', '$sname', '$eType1', '$noOfResult', '$result2', '$examNo2', '$eYear2', '$eType2')";
        $result = $db->query($sql);
        //echo 'ghfhfg';
    }
}
ob_end_flush();
?>