Server IP : 162.240.98.243 / Your IP : 18.226.187.233 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/public_html/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'); ?>