<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */
include('headMain_ord.php');

?>
<div class="row">
    <div class="col-lg-1"></div>
    <div class="col-lg-8">
        <div class="panel panel-default">
            <div class="panel-heading">
                Uploading JAMB List
            </div>
            <div class="panel-body">

                <div class="row">
                    <div class="col-lg-12">
                        <?php
require_once('../connect.php');
                        $db=db_connect();
                       // echo $_POST['submit'];
if(isset($_POST["submit"])) {
    $file = $_FILES['file']['tmp_name'];
    $handle = fopen($file, "r");
    $c = 0;
    while (($filesop = fgetcsv($handle, 1000000, ",")) !== false) {

        $school = $filesop[0];
        $dept = $filesop[1];
        $matNo = $filesop[2];
        $level = $filesop[3];
        $courseC = $filesop[4];
        $score = $filesop[5];
        $grade = $filesop[6];
        $cpoint = $filesop[7];
        $asession=$_POST['asession'];

        $check_data = $db->query("select * from rawscore where matNo='$matNo' and level='$level' and courseCode='$courseC' and asession='$asession'");
        $check_num = $check_data->rowCount();
        $dataNow = $check_data->fetch(PDO::FETCH_BOTH);

        if ($check_num > 0) {
            echo 'Already Exist=>' . $matNo . '=>' . $level . '=>' . $score . '=>' . $grade . '<br>';
            echo 'Present Record =>' . $matNo . '=>' . $level . '=>' . $dataNow['score'] . '=>' . $dataNow['grade'] . '=>' . $dataNow['courseCode'] . '<br>';
        } else {

            $sql = $db->query("INSERT INTO `fedpoly`.`rawscore` (`sn`, `school`, `dept`, `matno`, `level`, `courseCode`, `score`, `grade`, `cpoint`,`asession`) VALUES (NULL, '$school', '$dept', '$matNo', '$level', '$courseC', '$score', '$grade', '$cpoint','$asession')");
        }
    }
        if ($sql) {
            echo "Your database has imported successfully";
        } else {
            echo "Sorry! There is some problem.";
        }

}
?>

                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<?php
include('footMain.php');
?>