<?php
ini_set('memory_limit', '512M');
//ini_set('max_execution_time',300);
set_time_limit(0);
/**
 * Created by PhpStorm.
 * User: adisa
 * Date: 3/2/2016
 * Time: 3:18 PM
 */
include('headMain_2.php');

?>
<div class="row">
    <div class="col-lg-1"></div>
    <div class="col-lg-8">
        <div class="panel panel-default">
            <div class="panel-heading">
                Processing MY CANDIDATE
            </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;
    $cc=0;
while(($filesop = fgetcsv($handle, 1000000, ",")) !== false)
{
$formNo = $filesop[0];
    $sponsor = $filesop[1];
    $dept= $filesop[2];
   //$examSession  = $filesop[3];


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

    if($check_num==1){
        echo 'Already Exist=>'.$formNo.'=>'.$sponsor.'=><br>';
        echo 'Present Record =>'.$dataNow['formNo'].'=>'.$dataNow['spnspr'].'=>'.$dataNow['dept'].'<br>';
        $cc+=1;
    }else {
        $sola="INSERT INTO `fedpoly`.`my_data_2022` ( `formNo`, `sponsor`, `dept`) VALUES ( '$formNo', '$sponsor', '$dept')";
//        $sola="INSERT INTO `fedpoly`.`oralscore` ( `formNo`, `score`, `result`) VALUES ( '$formNo', '$score', '$dept')";
//      die($sola);
        $sql = $db->query($sola);
        $c+=1;
      //  $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 [".$c."]";
    echo "Sorry! There is some problem. [".$cc."]";
}else{
echo "Sorry! There is some problem. [".$cc."]";
    echo "Your database has imported successfully [".$c."]";
}
}
?>

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

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