|
Server IP : 2a02:4780:3:1493:0:3736:a38e:7 / Your IP : 216.73.216.139 Web Server : LiteSpeed System : Linux sg-nme-web1393.main-hosting.eu 4.18.0-553.40.1.lve.el8.x86_64 #1 SMP Wed Feb 12 18:54:57 UTC 2025 x86_64 User : u926327694 ( 926327694) PHP Version : 7.4.33 Disable Function : system, exec, shell_exec, passthru, mysql_list_dbs, ini_alter, dl, symlink, link, chgrp, leak, popen, apache_child_terminate, virtual, mb_send_mail MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : OFF Directory (0755) : /home/u926327694/domains/smsoft.in/public_html/demo/src/../update/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
require_once './config/config.php';
if(isset($_POST["bulk"]))
{
$filename=$_FILES["file"]["tmp_name"];
//echo $ext=substr($filename,strrpos($filename,"."),(strlen($filename)-strrpos($filename,".")));
if($_FILES["file"]["size"] > 0)
{
$file = fopen($filename, "r");
while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
{
//print_r($emapData);
$mobile = $emapData[0];
$sql ="INSERT INTO `stud_basic` (`Name`, `Gender`, `Class`, `Division`, `Reg_No`, `Phone`, `Email`) VALUES ('$emapData[0]', '', '$emapData[1]', '$emapData[2]', '$emapData[3]', '$emapData[4]','')";
// echo "$sql<br>";
if(!mysqli_query($con,$sql))
{
?> <script>
alert( "<?php echo "Error description:" . mysqli_error($con); ?>")
</script>
<?php
}
} ?>
<script> alert(" CSV File has been successfully Imported");
document.location="dashboard.php";
</script> <?php
}
else{
echo "Invalid File:Please Upload CSV File";
?>
<script>
document.location="Student_entry.php";
</script> <?php
}
}
?>