| Server IP : 162.240.98.243 / Your IP : 18.188.4.83 Web Server : Apache System : Linux server.bti.yaw.mybluehostin.me 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : btiyawmy ( 1003) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/btiyawmy/www/login.easenup.in/ |
Upload File : |
<?php
include 'database.php';
$uploadfile=$_FILES['uploadfile']['tmp_name'];
require 'PHPExcel/Classes/PHPExcel.php';
require_once 'PHPExcel/Classes/PHPExcel/IOFactory.php';
$objExcel=PHPExcel_IOFactory::load($uploadfile);
foreach($objExcel->getWorksheetIterator() as $worksheet)
{
$highestrow=$worksheet->getHighestRow();
for($row=0;$row<=$highestrow;$row++)
{
$Investigation=$worksheet->getCellByColumnAndRow(0,$row)->getValue();
$labdepartmentid=$worksheet->getCellByColumnAndRow(1,$row)->getValue();
$radiobodypartid=$worksheet->getCellByColumnAndRow(2,$row)->getValue();
$adminid=$worksheet->getCellByColumnAndRow(3,$row)->getValue();
if($adminid!='')
{
$insertqry="INSERT INTO `list_Investigation`( `Investigation`, `labdepartmentid`,`radiobodypartid`,`adminid`) VALUES ('$Investigation','$labdepartmentid','$radiobodypartid','$adminid')";
$insertres=mysqli_query($con,$insertqry);
}
}
}
header('Location: unspecifiedexcell.php');
?>