<?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-10">
            <div class="panel panel-default">
                <div class="panel-heading">
                    Uploading Uncompleted Olevel
                </div>
                <div class="panel-body">

                    <div class="row">
                        <div class="col-lg-12">
                            <?php
                            //echo 'here';
                            if(isset($_POST["submit"]))
                            {
                               // echo 'here';
                                $file = $_FILES['file']['tmp_name'];
                                $handle = fopen($file, "r");
                                $c = 0;
                                $dup=0;
                                $real=0;

                                while(($filesop = fgetcsv($handle, 100000000, ",")) !== false)
                                {
                                    $jambNo = $filesop[0];
                                    $fullName = $filesop[1];
;
                                    $sql_a=$db->query("select * from admittedolevel where jambNo='$jambNo'");
                                    $sql_a_num=$sql_a->rowCount();
                                    if($sql_a_num>0){
                                        $sql_a_fetch = $sql_a->fetch(PDO::FETCH_BOTH);
                                        echo 'Previous Record :ID No: ' .$sql_a_fetch['jambNo'] . '--> Names:' . $sql_a_fetch['fullName'] .  '-->Date:' . $sql_a_fetch['dateCreated'] . '<br>';
                                        echo 'Current Record :ID No: ' . $jambNo . '--> Names:' . $fullName . '<br>';
                                        $dup=$dup+1;
                                    }else {
                                        $sql = $db->query("INSERT INTO `fedpoly`.`admittedolevel` (`sn`, `jambNo`, `fullName`,`dateCreated`) VALUES (NULL, '$jambNo', '$fullName', NOW() )");
                                        $real=$real+1;
                                    }
                                }
                                if($sql){
                                    echo $real. " Record imported successfully<br>";
                                    echo $dup. " Record(s) Duplicated Found";
                                }else{
                                    echo "Sorry! There is some problem.";

                                }

                            }
                            echo 'here';
                            ?>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

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