| 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 : |
<?php
session_start();
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++)
{
$state_name=$worksheet->getCellByColumnAndRow(0,$row)->getValue();
$cityname=$worksheet->getCellByColumnAndRow(1,$row)->getValue();
if($state_name!='')
{
$insertqry="INSERT INTO `cityrecords`(`state_name`, `cityname`) VALUES ('$state_name','$cityname')";
$insertres=mysqli_query($con,$insertqry);
}
}
}
header('Location: excell.php');
?>