Server IP : 162.240.98.243 / Your IP : 52.15.139.228 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++) { $ivid=$worksheet->getCellByColumnAndRow(0,$row)->getValue(); $methodid=$worksheet->getCellByColumnAndRow(1,$row)->getValue(); $parametersid=$worksheet->getCellByColumnAndRow(2,$row)->getValue(); $Test_Description=$worksheet->getCellByColumnAndRow(3,$row)->getValue(); $Unit=$worksheet->getCellByColumnAndRow(4,$row)->getValue(); $gender=$worksheet->getCellByColumnAndRow(5,$row)->getValue(); $same_to_all=$worksheet->getCellByColumnAndRow(6,$row)->getValue(); $all_min=$worksheet->getCellByColumnAndRow(7,$row)->getValue(); $all_max=$worksheet->getCellByColumnAndRow(8,$row)->getValue(); $mNewborn_min=$worksheet->getCellByColumnAndRow(9,$row)->getValue(); $mNewborn_max=$worksheet->getCellByColumnAndRow(10,$row)->getValue(); $mChild_min=$worksheet->getCellByColumnAndRow(11,$row)->getValue(); $mChild_max=$worksheet->getCellByColumnAndRow(12,$row)->getValue(); $mAdult_min=$worksheet->getCellByColumnAndRow(13,$row)->getValue(); $mAdult_max=$worksheet->getCellByColumnAndRow(14,$row)->getValue(); $mSenior_Citizen_min=$worksheet->getCellByColumnAndRow(15,$row)->getValue(); $mSenior_Citizen_max=$worksheet->getCellByColumnAndRow(16,$row)->getValue(); $mold_min=$worksheet->getCellByColumnAndRow(17,$row)->getValue(); $mold_max=$worksheet->getCellByColumnAndRow(18,$row)->getValue(); $fNewborn_min=$worksheet->getCellByColumnAndRow(19,$row)->getValue(); $fNewborn_max=$worksheet->getCellByColumnAndRow(20,$row)->getValue(); $fChild_min=$worksheet->getCellByColumnAndRow(21,$row)->getValue(); $fChild_max=$worksheet->getCellByColumnAndRow(22,$row)->getValue(); $fAdult_min=$worksheet->getCellByColumnAndRow(23,$row)->getValue(); $fAdult_max=$worksheet->getCellByColumnAndRow(24,$row)->getValue(); $fSenior_Citizen_min=$worksheet->getCellByColumnAndRow(25,$row)->getValue(); $fSenior_Citizen_max=$worksheet->getCellByColumnAndRow(26,$row)->getValue(); $fold_min=$worksheet->getCellByColumnAndRow(27,$row)->getValue(); $fold_max=$worksheet->getCellByColumnAndRow(28,$row)->getValue(); $entered_by=$worksheet->getCellByColumnAndRow(29,$row)->getValue(); $created_at=$worksheet->getCellByColumnAndRow(30,$row)->getValue(); if($created_at!='') { $insertqry="INSERT INTO Test_Description_final (`ivid`,`methodid`,`parametersid`,`Test_Description`,`Unit`,`gender`, `same_to_all`,`all_min`,`all_max`,`mNewborn_min`,`mNewborn_max`, `mChild_min`,`mChild_max`,`mAdult_min`,`mAdult_max`,`mSenior_Citizen_min`,`mSenior_Citizen_max`,`mold_min`,`mold_max`,`fNewborn_min`,`fNewborn_max`,`fChild_min`,`fChild_max`,`fAdult_min`,`fAdult_max`,`fSenior_Citizen_min`,`fSenior_Citizen_max`,`fold_min`,`fold_max`,`entered_by`,`created_at`) VALUES ('$ivid','$methodid','$parametersid','$Test_Description','$Unit','$gender','$same_to_all','$all_min','$all_max','$mNewborn_min','$mNewborn_max','$mChild_min','$mChild_max','$mAdult_min','$mAdult_max','$mSenior_Citizen_min','$mSenior_Citizen_max','$mold_min','$mold_max','$fNewborn_min','$fNewborn_max','$fChild_min','$fChild_max','$fAdult_min','$fAdult_max','$fSenior_Citizen_min','$fSenior_Citizen_max','$fold_min','$fold_max','$entered_by','$created_at')"; $insertres=mysqli_query($con,$insertqry); } } } header('Location: testvalueexcell.php'); ?>