<?php
    $file = $_FILES['file']['tmp_name'];
    $handle = fopen($file, "r");
    $c = 0;
    $counter=0;
    while(($filesop = fgetcsv($handle, 100000000, ",")) !== false)
    {


        $formNo = $filesop[1];
        $day = $filesop[2];
        $venue = $filesop[3];
        $session = $filesop[4];
require_once('../connect.php');
        $db=db_connect();
$sql=$db->query("INSERT INTO `fedpoly`.`venuetb` (`sn`, `formNo`, `examDay`, `examSession`, `venue`) VALUES (NULL, '$formNo', '$day', '$session', '$venue')");

        if($sql){
            $counter+=1;
            }
            // $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";
        header('location:scheduleList.php?id=$counter');
       // echo '<br>'.$counter.'Records imported successfully';

    }else{
        echo "Sorry! There is some problem.";
    }


                            ?>