<?php
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */
include('headMain.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 CBT Result
                </div>
                <div class="panel-body">

                    <div class="row">
                        <div class="col-lg-12">

                            <?php
                            require_once('../connect.php');
                            $db=db_connect();
                            if(isset($_POST["submit"]))
                            {
                                $file = $_FILES['file']['tmp_name'];
                                $handle = fopen($file, "r");
                                $c = 0;
                                while(($filesop = fgetcsv($handle, 1000000, ",")) !== false)
                                {
                                    $formNo = $filesop[0];
                                    $score = $filesop[3];
                                   // $dept= $filesop[2];
                                    //$examSession  = $filesop[3];


//$names=str_replace("'","''",$names);
//                                    $check_data=$db->query("select * from oralscore where formNo='$formNo'");
                                    $check_data=$db->query("select * from cbtscore where formNo='$formNo'");
                                    $check_num=$check_data->rowCount();
                                    $dataNow=$check_data->fetch(PDO::FETCH_BOTH);

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

//                                        $sql = $db->query("INSERT INTO `fedpoly`.`oralscore` (`sn`, `formNo`, `score`) VALUES ('', '$formNo', '$score')");
                                        $aspoa="INSERT INTO `fedpoly`.`cbtscore` ( `formNo`, `score`) VALUES ('$formNo', '$score')";
//                                        die($aspoa);
                                        $sql = $db->query($aspoa);
                                        //  $sql = $db->query("INSERT INTO `fedpoly`.`venuetb` (`sn`, `formNo`, `examDay`, `examSession`, `venue`) VALUES (NULL, '$formNo', '$examDay', '$examSession', '$examVenue')");
                                    }
                                    /*$sql=mysql_query('LOAD DATA LOCAL INFILE "'.$file.'"
                                            INTO TABLE rawcgpa
                                            FIELDS TERMINATED by ","
                                            OPTIONALLY ENCLOSED BY "\'"
                                            LINES TERMINATED BY "\n"');*/
                                }
                                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');
?>