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

?>
                    <script src="../SpryAssets/SpryMenuBar.js" type="text/javascript"></script>

                    <script type="text/javascript" language="javascript" src="../js/jquery-1.7.1.js"></script>
                    <script type="text/javascript" language="javascript" src="../js/scriptFileLong.js"></script>

    <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
if(isset($_POST["submit"]))
{
    $file = $_FILES['file']['tmp_name'];
    $handle = fopen($file, "r");
    $c = 0;
    while(($filesop = fgetcsv($handle, 100000000, ",")) !== false)
    {

        /*$id = $filesop[0];
        $deptId = $filesop[1];
        $jambNo = $filesop[2];
        $fullName = $filesop[3];
        $fullName=str_replace("'","''",$fullName);
        $state = $filesop[4];
        $lga=$filesop[5];
        $sex = $filesop[6];
        $age = strtoupper($filesop[7]);
        $eng = $filesop[8];
        $sub2 = $filesop[9];
        $sub2Score = $filesop[10];
        $sub3 = $filesop[11];
        $sub3Score = $filesop[12];
        $sub4 = $filesop[13];
        $sub4Score = $filesop[14];
        $totalScore=$filesop[15];
        $choiceID=$filesop[16];
        $school = $filesop[17];
        $dept = $filesop[18];
        $courseId = $filesop[19];*/
        $matNo = $filesop[0];
        $names = $filesop[1];

$sql=$db->query("INSERT INTO `fedpoly`.`jambregu` (`sn`, `matNo`, `names`, `dateSent`) VALUES (NULL, '$matNo', '$names', 'datestamp')");
       // $sql = mysql_query("INSERT INTO `fedpoly`.`admitted` (`sn`, `formNo`, `jambNo`, `names`, `course`, `levelID`, `mode`, `state`, `lga`, `address`, `dob`, `email`, `gsm`, `sex`, `batch`, `acceptance`, `datepay`) VALUES (NULL, '$formNo', '$jambNo', '$fullName', '$dept', '$level', '$mode', '0', '0', '0', '0', '0', '0', '0', '4', '0', CURRENT_TIMESTAMP)");

       /* $sql_query="INSERT INTO `fedpoly`.`jambrelease` (`id`, `deptSn`, `candName`, `state`, `lga`, `sex`, `age`, `eng`, `sub2`, `sub2Score`, `sub3`, `sub3Score`, `sub4`, `sub4Score`, `totalScore`, `choiceNo`, `faculty`, `dept`, `courseID`, `jambNo`, `dateIn`, `utmeScore`, `aggregate`, `formNo`, `gsm`, `batch`)VALUES (NULL, '$deptId', '$fullName', '$state', '$lga', '$sex', '$age', '$eng', '$sub2', '$sub2Score','$sub3', '$sub3Score', '$sub4', '$sub4Score', '$totalScore', '$choiceID', '$school', '$dept', '$courseId','$jambNo',  CURRENT_TIMESTAMP, '', '', '', '', '')";
$sql=$db->query($sql_query);*/
//$sql = mysql_query("INSERT INTO `fedpoly`.`nooo` (`formNo`, `course`, `names`) VALUES ('$formNo', '$dept', '$fullName')");

    }
    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');
?>