| Server IP : 172.64.80.1 / Your IP : 172.71.120.135 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/httpdocs/admin_main/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: adisa
* Date: 3/2/2016
* Time: 3:18 PM
*/
ini_set('memory_limit','-1');
//include('headMain.php');
require_once('../connect.php');
$db=db_connect();
?>
<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 General Records
</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;
$dup=0;
$real=0;
while(($filesop = fgetcsv($handle, 100000000, ",")) !== false)
{
$level=$_POST['level'];
$jambNo = $filesop[1];
$fullName = $filesop[2];
$dept = $filesop[3];
$admDate=$filesop[4];
// $admDate='2021-06-30';
// $originalNo = $filesop[4];
$fullName=str_replace("'","''",$fullName);
if ($level==1){
$mode='NFT';
$sql_jambNo=$db->query("select jambNo from stddata where formNo='$jambNo'");
$sql_jambNo_num=$sql_jambNo->rowCount();
if ($sql_jambNo_num==1){
$sql_jambNo_fetch=$sql_jambNo->fetch(PDO::FETCH_BOTH);
$formNo=$jambNo;
$jambNo=$sql_jambNo_fetch['jambNo'];
}else{
$formNo=$jambNo;
}
}else if($level==8){
$formNo = $filesop[1];
$mode='DPT';
$formTypea='dptForm';
}else if($level==5){
$formNo = $filesop[1];
$mode="RPT";
$formTypea='ptForm';
}else if($level==3){
$formNo = $filesop[1];
$mode="HFT";
}else if($level==10){
$formNo = $filesop[1];
$mode="PFT";
}else if($level==11){
$formNo = $filesop[1];
$mode="HDPT";
}
//$postScore = $filesop[18];
$sql_a=$db->query("select * from admitted where jambNo='$jambNo' or formNo='$formNo'");
// $sql_a=$db->query("select * from admitted where sex='$originalNo'");
// $sql_a=$db->query("select * from ace_admitted where jambNo='$jambNo'");
// $sql_a=$db->query("select * from realdata 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: ' . $formNo . '--> Names:' . $sql_a_fetch['names'] . '-->Department:' . $sql_a_fetch['course'] . '-->Batch:' . $sql_a_fetch['batch'] . '<br>';
echo 'Current Record :ID No: ' . $formNo . '--> Names:' . $fullName . '-->Department:' . $dept . '<br>';
$dup=$dup+1;
}else {
// $sql=$db->query("INSERT INTO check_phoneno(`sn`,`formNo`)values('',$jambNo)");
// echo $sola="INSERT INTO `fedpoly`.`admitted` (`sn`, `formNo`, `jambNo`, `names`, `course`, `levelID`, `mode`, `state`, `lga`, `address`, `email`, `gsm`, `sex`, `batch`, `acceptance`, `datepay`,`formStatus`) VALUES (NULL, '$formNo', '$jambNo', '$fullName', '$dept', '$level', '$mode', '0', '0', '0', '0', '0', '0', '14', '0', CURRENT_TIMESTAMP,'0')";
// echo $sola="INSERT INTO `fedpoly`.`ace_admitted` (`sn`, `formNo`, `jambNo`, `names`, `course`, `levelID`, `mode`, `state`, `lga`, `address`, `email`, `gsm`, `sex`, `batch`, `acceptance`, `datepay`,`formStatus`) VALUES (NULL, '$formNo', '$jambNo', '$fullName', '$dept', '$level', '$mode', '0', '0', '0', '0', '$gsm', '0', '4', '0', CURRENT_TIMESTAMP,'0')";
$sola="INSERT INTO `fedpoly`.`admitted` (`sn`, `formNo`, `jambNo`, `names`, `course`, `levelID`, `mode`, `state`, `lga`, `address`, `email`, `gsm`, `sex`, `batch`, `acceptance`, `datepay`,`formStatus`,`admDate`) VALUES (NULL, '$formNo', '$jambNo', '$fullName', '$dept', '$level', '$mode', '0', '0', '0', '0', '0', '0', '3', '0', CURRENT_TIMESTAMP,'0','$admDate')";
// echo $sola="INSERT INTO `fedpoly`.`realdata` (`sn`, `formNo`, `matNo`, `names`, `course`, `levelID`, `mode`, `usernamea`, `passworda`) VALUES (NULL, '$formNo', '$jambNo', '$fullName', '$dept', '$level', '$mode', '$matNo', '$matNo')";
//die();
$sql = $db->query($sola);
// die();
$real = $real + 1;
// //=========================Conversion column Start
////
// $courseDept = $db->query("select sn from dept where dOption='$dept'");
//// $courseDept_fetch = $courseDept->fetch(PDO::FETCH_BOTH);
// $dOption = $courseDept_fetch['sn'];
//
// $na = explode(' ', $fullName);
// $surName = $na[0];
// if (isset($na[2])) {
// $otherNames = $na[1] . ' ' . $na[2];
// }
// else{
// $otherNames=$na[1];
// }
//
// $pass2=md5($jambNo);
// $phoneNumber='';
// $eMail='';
// $transID=$jambNo;
//
// $formNo='';
// $saheed="INSERT INTO `fedpoly`.`entrancetable` (`sn`, `surname`, `othernames`, `password`, `gsm`, `email`, `course`, `transID`,`formType`,`dept`)
// VALUES (NULL, '$surName', '$otherNames', '$pass2', '$phoneNumber', '$eMail', '$dOption', '$transID','$formTypea','$dOption')";
// $sql_a = $db->query($saheed);
// die($dept);
//=======================================Conversion column End
}
}
if($sql){
echo $real. " Record imported successfully<br>";
echo $dup. " Record(s) Duplicated Found";
}else{
echo "Sorry! There is some problem.";
echo $real. " Record imported successfully<br>";
echo $dup. " Record(s) Duplicated Found";
echo $sola;
}
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
<?php
include('footMain.php');
?>