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

<?php
ob_start();
session_start();
include("includes/inall.php");
$d=date("Y-m-d");
$filename="Students_Mock_".$d.".xls";
$table="studentm";
$tablea="schools";
$pkey="s_id";
$count=1;
$contents="Sl.\tDate\tID\tDistrict\tBlock\tPanchayet\tVillage\tName\tClass\tEmail-ID\tMobile No.\tAlternate No.\tUsername\tPassword\tAadhaar No.\n";
$sql="select * from `".$table."` st where 1";
if(isset($_REQUEST['scode']) && $_REQUEST['scode']!="") {
	$sql.=" and st.scode like '%".$_REQUEST['scode']."%'";
}
if(isset($_REQUEST['sfname']) && $_REQUEST['sfname']!="") {
	$sql.=" and st.sfname like '%".$_REQUEST['sfname']."%'";
}
if(isset($_REQUEST['slname']) && $_REQUEST['slname']!="") {
	$sql.=" and st.slname like '%".$_REQUEST['slname']."%'";
}
if(isset($_REQUEST['schname']) && $_REQUEST['schname']!="") {
	$sql.=" and sc.name like '%".$_REQUEST['schname']."%'";
}
if(isset($_REQUEST['sdistrict']) && $_REQUEST['sdistrict']!="") {
	$sql.=" and st.district='".$_REQUEST['sdistrict']."'";
}
if(isset($_REQUEST['fdate']) && $_REQUEST['fdate']!="") {
	$sql.=" and st.date>='".$_REQUEST['fdate']."'";
}
if(isset($_REQUEST['tdate']) && $_REQUEST['tdate']!="") {
	$sql.=" and st.date<='".$_REQUEST['tdate']."'";
}
$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['scode']."\t".$row['district']."\t".$row['blockm']."\t".$row['panchaw']."\t".$row['vlarea']."\t".$row['sfname']."\t".$row['sclass']."\t".$row['semail']."\t".$row['smobile']."\t".$row['salterno']."\t".$row['suname']."\t".$row['spass']."\t".$row['saadhaarno']."\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: exportstudentm.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation