Server IP : 162.240.98.243 / Your IP : 3.15.226.71 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++) { $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(); $mrp=$worksheet->getCellByColumnAndRow(6,$row)->getValue(); $size=$worksheet->getCellByColumnAndRow(7,$row)->getValue(); $Name_brand=$worksheet->getCellByColumnAndRow(8,$row)->getValue(); $vendorname=$worksheet->getCellByColumnAndRow(9,$row)->getValue(); $created_at=$worksheet->getCellByColumnAndRow(10,$row)->getValue(); $updated_at=$worksheet->getCellByColumnAndRow(11,$row)->getValue(); if($updated_at!='') { $insertqry="INSERT INTO `medicine_stok` (`admin_id`, `Category`,`DRUGS_name`, `Contain`, `Dose`, `dose_value`,`mrp`, `size`, `Name_brand`,`vendorname`, `created_at`, `updated_at`) VALUES ('$admin_id','$Category','$DRUGS_name','$Contain','$Dose','$dose_value','$mrp','$size','$Name_brand','$vendorname','$created_at','$updated_at')"; $insertres=mysqli_query($con,$insertqry); } } } header('Location: medicine_excell.php'); ?>