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: sexport.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$filename="Data ".date("d-m-Y").".xls";
$contents="Job Title\tDate Of Application\tCandidate's Name\tEmail ID\tPhoneNumber\tCurrent Location\tPreferred Locations\tTotal Experience\tCurr-Company name\tCurr-Company Designation\tDepartment\tRole\tIndustry\tKey Skills\tAnnual Salary\tNotice period/Availability to join\tResume Headline\tUnder Graduation Degree\tUG Specialization\tUG University/institute Name\tUG Graduation year\tPost Graduation Degree\tPG specialization\tPG University/Institute Name\tPG Graduation Year\tDoctorate Degree\tDoctorate Specialization\tDoctorate University/Institute Name\tDoctorate Graduation Year\tGender\tMarital Status\tHome Town/City\tPin Code\tWork permit for USA\tDate of Birth\tPermanent Address\tClient Name\n";
$sql="select * from `ssidata` where `status`='1'";
if(isset($_REQUEST['name']) && $_REQUEST['name']!="") {
	$sql.=" and `name` like '%".$_REQUEST['name']."%'";
}
if(isset($_REQUEST['position']) && $_REQUEST['position']!="") {
	$sql.=" and `position` like '%".$_REQUEST['position']."%'";
}
if(isset($_REQUEST['location']) && $_REQUEST['location']!="") {
	$sql.=" and `location` like '%".$_REQUEST['location']."%'";
}
if(isset($_REQUEST['contact']) && $_REQUEST['contact']!="") {
	$sql.=" and `contact` like '%".$_REQUEST['contact']."%'";
}
if(isset($_REQUEST['minsal']) && $_REQUEST['minsal']!="") {
	$sql.=" and cast(pctc as int)>='".$_REQUEST['minsal']."'";
}
if(isset($_REQUEST['maxsal']) && $_REQUEST['maxsal']!="") {
	$sql.=" and cast(pctc as int)<='".$_REQUEST['maxsal']."'";
}
if(isset($_REQUEST['minexp']) && $_REQUEST['minexp']!="") {
	$sql.=" and cast(texperience as int)>='".$_REQUEST['minexp']."'";
}
if(isset($_REQUEST['maxexp']) && $_REQUEST['maxexp']!="") {
	$sql.=" and cast(texperience as int)<='".$_REQUEST['maxexp']."'";
}
if(isset($_REQUEST['clocation']) && $_REQUEST['clocation']!="") {
	$sql.=" and `curlocation` like '%".$_REQUEST['clocation']."%'";
}
if(isset($_REQUEST['plocation']) && $_REQUEST['plocation']!="") {
	$sql.=" and `prflocation` like '%".$_REQUEST['plocation']."%'";
}
if(isset($_REQUEST['hometown']) && $_REQUEST['hometown']!="") {
	$sql.=" and `hometown` like '%".$_REQUEST['hometown']."%'";
}
if(isset($_REQUEST['edudet']) && $_REQUEST['edudet']!="") {
	$sql.=" and (`qualification` like '%".$_REQUEST['edudet']."%' or `ugdegree` like '%".$_REQUEST['edudet']."%' or `ugspec` like '%".$_REQUEST['edudet']."%' or `uguiname` like '%".$_REQUEST['edudet']."%' or `ugyear` like '%".$_REQUEST['edudet']."%' or `pgdegree` like '%".$_REQUEST['edudet']."%' or `pgspec` like '%".$_REQUEST['edudet']."%' or `pguiname` like '%".$_REQUEST['edudet']."%' or `pgyear` like '%".$_REQUEST['edudet']."%' or `dcdegree` like '%".$_REQUEST['edudet']."%' or `dcspec` like '%".$_REQUEST['edudet']."%' or `dcuiname` like '%".$_REQUEST['edudet']."%' or `dcyear` like '%".$_REQUEST['edudet']."%')";
}
if(isset($_REQUEST['empdet']) && $_REQUEST['empdet']!="") {
	$sql.=" and (`pcompany` like '%".$_REQUEST['empdet']."%' or `pdesignation` like '%".$_REQUEST['empdet']."%' or `department` like '%".$_REQUEST['empdet']."%' or `role` like '%".$_REQUEST['empdet']."%' or `industry` like '%".$_REQUEST['empdet']."%')";
}
if(isset($_REQUEST['anykey']) && $_REQUEST['anykey']!="") {
	$sql.=" and (`keyskills` like '%".$_REQUEST['anykey']."%' or `rheadline` like '%".$_REQUEST['anykey']."%')";
}
$sql.=" order by `id` desc";
//print $sql;
$res=mysqli_query($con,$sql);
if(mysqli_num_rows($res)>=1) {
	while($row=mysqli_fetch_array($res)) {
		$contents.=stripslashes($row['position'])."\t".dtconvert($row['date'])."\t".stripslashes($row['name'])."\t".stripslashes($row['email'])."\t".stripslashes($row['contact'])."\t".stripslashes($row['curlocation'])."\t".stripslashes($row['prflocation'])."\t".stripslashes($row['texperience'])."\t".stripslashes($row['pcompany'])."\t".stripslashes($row['pdesignation'])."\t".stripslashes($row['department'])."\t".stripslashes($row['role'])."\t".stripslashes($row['industry'])."\t".stripslashes($row['keyskills'])."\t".stripslashes($row['pctc'])."\t".stripslashes($row['nperiod'])."\t".stripslashes($row['rheadline'])."\t".stripslashes($row['ugdegree'])."\t".stripslashes($row['ugspec'])."\t".stripslashes($row['uguiname'])."\t".stripslashes($row['ugyear'])."\t".stripslashes($row['pgdegree'])."\t".stripslashes($row['pgspec'])."\t".stripslashes($row['pguiname'])."\t".stripslashes($row['pgyear'])."\t".stripslashes($row['dcdegree'])."\t".stripslashes($row['dcspec'])."\t".stripslashes($row['dcuiname'])."\t".stripslashes($row['dcyear'])."\t".stripslashes($row['gender'])."\t".stripslashes($row['mstatus'])."\t".stripslashes($row['hometown'])."\t".stripslashes($row['pincode'])."\t".stripslashes($row['wpusa'])."\t".dtconvert($row['dob'])."\t".stripslashes($row['address'])."\t".stripslashes($row['cname'])."\n";
	}
}	
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo $contents;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: sexport.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation