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

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: sdataexcel.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$page="sdataexcel.php";
if($_REQUEST['editid']=="" && isset($_POST['submitin']) && $_POST['submitin']=="Formyes") {
	$dt=date("Y-m-d");
	if(isset($_FILES['mexcel']['name'])) {
		$userfile_name=$_FILES['mexcel']['name'];
		$userfile_tmp=$_FILES['mexcel']['tmp_name'];
		$img=$_FILES['mexcel']['tmp_name'];
		$userfile_size=$_FILES['mexcel']['size'];
		$userfile_type=$_FILES['mexcel']['type'];
		$t=explode(".",$userfile_name);
		if($t[1]=="xls" || $t[1]=="xlsx") {
			$path=time().$userfile_name; //original path
			$uppath="excls/".$path;
			move_uploaded_file($_FILES['mexcel']['tmp_name'], $uppath);
		}
		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++) {
			$position=trim($excel->sheets[0]["cells"][$x][1]);  
			$date=addslashes(trim($excel->sheets[0]["cells"][$x][2]));
			$name=addslashes(trim($excel->sheets[0]["cells"][$x][3]));
			$email=addslashes(trim($excel->sheets[0]["cells"][$x][4]));
			$contact=addslashes(trim($excel->sheets[0]["cells"][$x][5]));
			$curlocation=addslashes(trim($excel->sheets[0]["cells"][$x][6]));
			$prflocation=addslashes(trim($excel->sheets[0]["cells"][$x][7]));
			$texperience=addslashes(trim($excel->sheets[0]["cells"][$x][8]));
			$pcompany=addslashes(trim($excel->sheets[0]["cells"][$x][9]));
			$pdesignation=addslashes(trim($excel->sheets[0]["cells"][$x][10]));
			$department=addslashes(trim($excel->sheets[0]["cells"][$x][11]));
			$role=addslashes(trim($excel->sheets[0]["cells"][$x][12]));
			$industry=addslashes(trim($excel->sheets[0]["cells"][$x][13]));
			$keyskills=addslashes(trim($excel->sheets[0]["cells"][$x][14]));
			$pctc=addslashes(trim($excel->sheets[0]["cells"][$x][15]));
			$nperiod=addslashes(trim($excel->sheets[0]["cells"][$x][16]));
			$rheadline=addslashes(trim($excel->sheets[0]["cells"][$x][17]));
			$ugdegree=addslashes(trim($excel->sheets[0]["cells"][$x][18]));
			$ugspec=addslashes(trim($excel->sheets[0]["cells"][$x][19]));
			$uguiname=addslashes(trim($excel->sheets[0]["cells"][$x][20]));
			$ugyear=addslashes(trim($excel->sheets[0]["cells"][$x][21]));
			$pgdegree=addslashes(trim($excel->sheets[0]["cells"][$x][22]));
			$pgspec=addslashes(trim($excel->sheets[0]["cells"][$x][23]));
			$pguiname=addslashes(trim($excel->sheets[0]["cells"][$x][24]));
			$pgyear=addslashes(trim($excel->sheets[0]["cells"][$x][25]));
			$dcdegree=addslashes(trim($excel->sheets[0]["cells"][$x][26]));
			$dcspec=addslashes(trim($excel->sheets[0]["cells"][$x][27]));
			$dcuiname=addslashes(trim($excel->sheets[0]["cells"][$x][28]));
			$dcyear=addslashes(trim($excel->sheets[0]["cells"][$x][29]));
			$gender=addslashes(trim($excel->sheets[0]["cells"][$x][30]));
			$mstatus=addslashes(trim($excel->sheets[0]["cells"][$x][31]));
			$hometown=addslashes(trim($excel->sheets[0]["cells"][$x][32]));
			$pincode=addslashes(trim($excel->sheets[0]["cells"][$x][33]));
			$wpusa=addslashes(trim($excel->sheets[0]["cells"][$x][34]));
			$dob=addslashes(trim($excel->sheets[0]["cells"][$x][35]));
			$address=addslashes(trim($excel->sheets[0]["cells"][$x][36]));
			$cname=addslashes(trim($excel->sheets[0]["cells"][$x][37]));
			$unix_date=($date-25569)*86400;
			$excel_date=25569+($unix_date/86400);
			$unix_date=($excel_date-25569)*86400;
			$date=gmdate("Y-m-d",$unix_date);
			$unix_date=($dob-25569)*86400;
			$excel_date= 25569+($unix_date/86400);
			$unix_date=($excel_date-25569)*86400;
			$dob=gmdate("Y-m-d",$unix_date);
			if($name!="") {
				$insert_sql_data=array('date'=>$date,
				'position'=>$position,
				'location'=>$location,
				'cname'=>$cname,
				'name'=>$name,
				'contact'=>$contact,
				'email'=>$email,
				'texperience'=>$texperience,
				'pcompany'=>$pcompany,
				'pdesignation'=>$pdesignation,
				'department'=>$department,
				'role'=>$role,
				'industry'=>$industry,
				'keyskills'=>$keyskills,
				'pctc'=>$pctc,
				'nperiod'=>$nperiod,
				'curlocation'=>$curlocation,
				'prflocation'=>$prflocation,
				'rheadline'=>$rheadline,
				'ugdegree'=>$ugdegree,
				'ugspec'=>$ugspec,
				'uguiname'=>$uguiname,
				'ugyear'=>$ugyear,
				'pgdegree'=>$pgdegree,
				'pgspec'=>$pgspec,
				'pguiname'=>$pguiname,
				'pgyear'=>$pgyear,
				'dcdegree'=>$dcdegree,
				'dcspec'=>$dcspec,
				'dcuiname'=>$dcuiname,
				'dcyear'=>$dcyear,
				'gender'=>$gender,
				'mstatus'=>$mstatus,
				'hometown'=>$hometown,
				'pincode'=>$pincode,
				'wpusa'=>$wpusa,
				'dob'=>$dob,
				'address'=>$address,
				'cdate'=>$dt,
				'status'=>'1'
				);
				$ins_query=tep_db_perform("ssidata",$insert_sql_data,"insert");
			}
		}	
	}
	if($ins_query) {
		$_SESSION['msg']="Achievement is successfully added.";
		header("location:".$page);
		exit();
	} else {
		$_SESSION['msgerrr']="Some error occured.";
		header("location:".$page);
		exit();
	}
}
include("includes/headermain.php"); 
?>
<?php if($_SESSION['msg']) { ?>
	<script src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.js"></script>
	<script>
	$(document).ready(function() {	
		var id = '#dialog';
			
		//Get the screen height and width
		var maskHeight = $(document).height();
		var maskWidth = $(window).width();
			
		//Set heigth and width to mask to fill up the whole screen
		$('#mask').css({'width':maskWidth,'height':maskHeight});
	
		//transition effect
		$('#mask').fadeIn(500);	
		$('#mask').fadeTo("slow",0.9);	
			
		//Get the window height and width
		var winH = $(window).height();
		var winW = $(window).width();
					  
		//Set the popup window to center
		$(id).css('top',  winH/2-$(id).height()/2);
		$(id).css('left', winW/2-$(id).width()/2);
		
		//transition effect
		$(id).fadeIn(2000); 	
		
		//if close button is clicked
		$('.window .close').click(function (e) {
			//Cancel the link behavior
			e.preventDefault();
		
			$('#mask').hide();
			$('.window').hide();
		});
	
		//if mask is clicked
		$('#mask').click(function () {
			$(this).hide();
			$('.window').hide();
		});
	});
	</script>
	<style>
	#mask {
		position: absolute;
		left: 0;
		top: 0;
		z-index: 9000;
		display: none;
	}
	#boxes .window {
		position: absolute;
		left: 0;
		top: 0;
		width: 300px;
		height: 200px;
		display: none;
		z-index: 9999;
		padding: 20px;
		border-radius: 5px;
		text-align: center;
	}
	#boxes #dialog {
		width: 300px;
		height: 200px;
		padding: 10px;
		background: #F9F9F9;
		font-size: 16px;
		font-weight: bold;
		webkit-box-shadow: 0 0 10px #999999;
  		box-shadow: 0 0 10px #999999;
	}
	#popupfoot {
		position: absolute;
		margin: auto;
		bottom: 20px;
		color: #005CB9;
	}
	.close {
		font-size: 12px !important;
	}
	</style>
	<div id="boxes">
		<div id="dialog" class="window">
			<?php if($_SESSION['msg']) { ?><span><?php print $_SESSION['msg']; $_SESSION['msg']=""; ?></span><?php } ?>
			<?php if($_SESSION['msgerr']) { ?><span class="redtxt"><?php print $_SESSION['msgerr']; $_SESSION['msgerr']=""; ?></span><?php } ?>
			<div id="popupfoot"><a href="#" class="close">Close</a></div>
		</div>
		<div id="mask"></div>
	</div>
<?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">
							<?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 } ?>
							<form action="#" method="post" name="rform" id="rform" enctype="multipart/form-data">
								<input type="hidden" name="submitin" value="Formyes">
								<input type="hidden" name="editid" id="editid" value="<?php print $_REQUEST['editid']; ?>">
								<input type="hidden" name="flag" id="flag" value="<?php print $_REQUEST['flag']; ?>">
								<div class="form-group col-md-4 floatleft">
									<label for="example-text-input" class="col-form-label">Uplaod Excel</label>
									<input class="form-control" type="file" name="mexcel" id="mexcel" value="<?php print $rowdt['hometown']; ?>">
									<?php /*if($rowdt['cvfile']) { ?>
										<div class="cleaner"></div><a href="docs/<?php print $rowdt['cvfile']; ?>" target="_new">View</a>
                               		<?php }*/ ?>
								</div>
								<div class="cleaner"></div>
								<button type="submit" class="btn btn-primary mt-2 pr-4 pl-4">Submit</button>
							</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: sdataexcel.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation