Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/admin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: importexceludata.php

<?php
ob_start();
session_start();
include("includes/inall.php");  
$action=isset($_REQUEST['action'])?addslashes(trim($_REQUEST['action'])):'Add';
if(isset($_POST['submitin']) && $_POST['submitin']=="Add") {
	$dt=date("Y-m-d");
	$cdate=isset($_POST['cdate'])?addslashes(trim($_POST['cdate'])):'';
	$user=isset($_POST['user'])?addslashes(trim($_POST['user'])):'';
	$insert_sql_data=array('date'=>$dt,
	'cdate'=>$cdate,
	'user'=>$user
	);
	$ins_query=tep_db_perform("callingdataex",$insert_sql_data,"insert");
	$id=mysqli_insert_id($con);
	if(isset($_FILES['dexcel']['name'])) {
		$userfile_name=$_FILES['dexcel']['name'];
		$userfile_tmp=$_FILES['dexcel']['tmp_name'];
		$img=$_FILES['dexcel']['tmp_name'];
		$userfile_size=$_FILES['dexcel']['size'];
		$userfile_type=$_FILES['dexcel']['type'];
		$t=explode(".",$userfile_name);
		if($t[1]=="xls" || $t[1]=="xlsx") {
			$path=time().$userfile_name; //original path
			$uppath="docs/".$path;
			move_uploaded_file($_FILES['dexcel']['tmp_name'], $uppath);
		}
		$insert_sql_data=array('dexcel'=>$path);
		$ins_query=tep_db_perform("callingdataex",$insert_sql_data,"update","id=".$id);
		require_once 'excel_reader.php';
		$excel=new PhpExcelReader;
		$excel->read($uppath);
		$nr_sheets=count($excel->sheets);
		for($x=1;$x<=$excel->sheets[0]['numRows'];$x++) {
			$name=addslashes(trim($excel->sheets[0]["cells"][$x][1]));
			$phone=addslashes(trim($excel->sheets[0]["cells"][$x][2]));
			$email=addslashes(trim($excel->sheets[0]["cells"][$x][3]));
			$age=addslashes(trim($excel->sheets[0]["cells"][$x][4]));
			$dob=addslashes(trim($excel->sheets[0]["cells"][$x][5]));
			$company=addslashes(trim($excel->sheets[0]["cells"][$x][6]));
			$designation=addslashes(trim($excel->sheets[0]["cells"][$x][7]));
			$csalary=addslashes(trim($excel->sheets[0]["cells"][$x][8]));
			if($name!="Name") { 
				$insert_sql_data=array('date'=>$cdate,
				'ref'=>$id,
				'user'=>$user,
				'name'=>$name,
				'phone'=>$phone,
				'email'=>$email,
				'age'=>$age,
				'dob'=>$dob,
				'company'=>$company,
				'designation'=>$designation,
				'csalary'=>$csalary
				);
				$ins_query=tep_db_perform("callingdatadet",$insert_sql_data,"insert");
			}	
		}
	}		
	if($ins_query) {
		$_SESSION['msg']="Excel is successfully uploaded.";
		header("location:importexceludata.php");
		exit();
	} else {
		$_SESSION['msgerrr']="Some error occured.";
		header("location:importexceludata.php");
		exit();
	}
}
include("includes/headermain.php"); 
?>
<body class="body-bg">


<div id="preloader">
	<div class="loader"></div>
</div>


<div class="horizontal-main-wrapper">
	<?php include("includes/header.php"); ?>
	
	<div class="main-content">
	 	<div class="main-content-inner">
			<div> 
				<div class="col-lg-12 mt-5">
					<div class="card">
						<div class="card-body">
							<h4 class="header-title">Upload Data</h4>
							<form action="#" method="post" name="rform" enctype="multipart/form-data">
								<input type="hidden" name="submitin" value="Add">
								<?php if($_SESSION['msgerr']) { ?><span class="redtxt"><?php print $_SESSION['msgerr']; $_SESSION['msgerr']=""; ?></span><div class="cleaner h10"></div><?php } ?>
								<?php if($_SESSION['msg']) { ?><span class="grtxt"><?php print $_SESSION['msg']; $_SESSION['msg']=""; ?></span><div class="cleaner h10"></div><?php } ?>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label"><span>*</span>Date</label>
									<input class="form-control" type="date" name="cdate" id="cdate" required>
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label"><span>*</span>User</label>
									<select class="form-control spslc" name="user" id="user" required>
										<option value="">Select
										<?php
										$resc=mysqli_query($con,"select * from `admin` where `type`='Userrole'");
										while($rowc=mysqli_fetch_object($resc)) {
										?>
											<option value="<?php print $rowc->id; ?>" <?php if($rowc->id==$rowm['user']) { ?>selected<?php } ?>><?php print $rowc->name; ?>
										<?php } ?>
									</select>
								</div>
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label"><span>*</span>Data</label>
									<input class="form-control" type="file" name="dexcel" id="dexcel" required>
								</div>
								<div class="cleaner"></div>
								<button type="submit" class="btn btn-primary mt-2 pr-4 pl-4">Submit</button>
								&nbsp;&nbsp;<a href="docs/SampleData.xls" target="_blank">Sample</a>
							</form>	
						</div>
					</div>
				</div>
			</div>
		</div>
	</div>
	
	<?php include("includes/footer.php"); ?>
</div>


<script src="assets/js/vendor/jquery-2.2.4.min.js"></script>

<script src="assets/js/popper.min.js"></script>
<script src="assets/js/bootstrap.min.js"></script>
<script src="assets/js/owl.carousel.min.js"></script>
<script src="assets/js/metisMenu.min.js"></script>
<script src="assets/js/jquery.slimscroll.min.js"></script>
<script src="assets/js/jquery.slicknav.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.7.2/Chart.min.js"></script>

<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>

<script src="https://www.amcharts.com/lib/3/amcharts.js"></script>
<script src="https://www.amcharts.com/lib/3/ammap.js"></script>
<script src="https://www.amcharts.com/lib/3/maps/js/worldLow.js"></script>
<script src="https://www.amcharts.com/lib/3/serial.js"></script>
<script src="https://www.amcharts.com/lib/3/plugins/export/export.min.js"></script>
<script src="https://www.amcharts.com/lib/3/themes/light.js"></script>

<script src="assets/js/line-chart.js"></script>

<script src="assets/js/pie-chart.js"></script>

<script src="assets/js/bar-chart.js"></script>

<script src="assets/js/maps.js"></script>

<script src="assets/js/plugins.js"></script>
<script src="assets/js/scripts.js"></script>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: importexceludata.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation