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.93 TB

🔧 Quick Actions

✏️ Editing: exportapplicationstc.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$filename="Teacher_Applications.xls";
$table="teachers";
$pkey="s_id";
$status="status";
$count=1;
$contents="Sl.\tDate\tType\tCategory\tClass\tSubject\tName\tFather Name\tDOB\tGender\tEmail-ID\tMobile No.\tVillage/Town\tBlock/Municipality\tPanchayat/Ward\tPS\tPIN\tDistrict\n";
$sql="select * from `".$table."` st where 1";
if(isset($_REQUEST['scode']) && $_REQUEST['scode']!="") {
	$sid=-3509+$_REQUEST['scode'];
	$sql.=" and st.s_id='".$sid."'";
}
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']."'";
}
if(isset($_REQUEST['ctype']) && $_REQUEST['ctype']!="") {
	$sql.=" and st.ctype='".$_REQUEST['ctype']."'";
}
if(isset($_REQUEST['subject']) && $_REQUEST['subject']!="") {
	$sql.=" and st.course='".$_REQUEST['subject']."'";
}
$sql.=" order by st.".$pkey." desc";
$res=mysqli_query($con,$sql);
while($row=mysqli_fetch_assoc($res)) {
	$sid=$row['s_id']-3509;
	$contents=$contents.$sid."\t".dtconvert($row['date'])."\t".$row['ctype']."\t".$row['tchtype']."\t".$row['class']."\t".$row['course']."\t".$row['sfname']."\t".$row['fname']."\t".dtconvert($row['sddate'])."\t".$row['sgender']."\t".$row['semail']."\t".$row['smobile']."\t".$row['saddress']."\t".$row['sblkmn']."\t".$row['spnward']."\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: exportapplicationstc.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation