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/jkma.co.in/public_html

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: exportstudents.php

<?php
ob_start();
session_start();
include("includes/inall.php");
$filename="Stdents ".date("d-m-Y").".xls";
$contents="Name\tMobile\tEmail\tClass\tRFID\tLoyalty\n";
$where = "where 1";
if (!empty($_REQUEST['name'])) {
    $pn = $_REQUEST['name'];
    $where .= " AND name LIKE '%$pn%'";
    //$filters[] = "name=" . urlencode($pn);
}
if(isset($_REQUEST['idno']) && $_REQUEST['idno']!="") {
    $where.=" and `idno` like '%".$_REQUEST['idno']."%'";
}
if(isset($_REQUEST['mobile']) && $_REQUEST['mobile']!="") {
    $where.=" and `mobile` like '%".$_REQUEST['mobile']."%'";
}
if(isset($_REQUEST['class']) && $_REQUEST['class']!="") {
    $where.=" and `class`='".$_REQUEST['class']."'";
}
$res = mysqli_query($con, "SELECT * FROM students $where ORDER BY id DESC");
//print "SELECT * FROM students $where ORDER BY id DESC";exit();
while ($row = mysqli_fetch_assoc($res)) {
	$lps = mysqli_fetch_assoc(mysqli_query($con, "SELECT sum(points) as total FROM points where idno = '".$row['idno']."'"));
	$contents.=$row['name']."\t".$row['mobile']."\t".$row['email']."\t".$row['class']."\t".$row['idno']."\t".$lps['total']."\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: exportstudents.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation