Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.54.1.lve.el8.x86_64

PHP Version:

7.3.33

User:

u435171512

Directory:

/home/u435171512/domains/rotary2982.org/public_html/conf2026/admin

Free Space:

4.1 TB

🔧 Quick Actions

✏️ Editing: export_member_excel.php

<?php
include "../config.php";
require_once 'PHPExcel.php';

// FETCH FILTER VALUE
$filter_club  = isset($_GET['club_id']) ? intval($_GET['club_id']) : 0;
$reg_status   = isset($_GET['reg_status']) ? $_GET['reg_status'] : "";

// CREATE EXCEL OBJECT
$objPHPExcel = new PHPExcel();
$sheet = $objPHPExcel->getActiveSheet();
$sheet->setTitle("Members");

// Styles
$titleStyle = [
    "font" => ["bold" => true, "size" => 14]
];
$headerStyle = [
    "font" => ["bold" => true, "size" => 11]
];

// GET CLUBS
$clubQuery = "SELECT * FROM club WHERE delete_status = 0";
if ($filter_club > 0) {
    $clubQuery .= " AND club_id = '$filter_club'";
}
$clubQuery .= " ORDER BY club_name ASC";
$clubs = mysqli_query($con, $clubQuery);

$row = 1; // Excel row pointer

// LOOP CLUBS
while ($club = mysqli_fetch_assoc($clubs)) {
    $club_id   = $club['club_id'];
    $club_name = $club['club_name'];

// CLUB TITLE ROW
    $sheet->setCellValue("A".$row, "Club: " . $club_name);
    $sheet->mergeCells("A".$row.":F".$row);
    $sheet->getStyle("A".$row)->applyFromArray($titleStyle);
    $row += 2;

// TABLE HEADER
    $sheet->setCellValue("A".$row, "Sl No");
    $sheet->setCellValue("B".$row, "Rotarian Name");
    $sheet->setCellValue("C".$row, "Rotary ID");
    $sheet->setCellValue("D".$row, "Phone Number");
    $sheet->setCellValue("E".$row, "Email");
    $sheet->getStyle("A".$row.":E".$row)->applyFromArray($headerStyle);
    $row++;

// GET MEMBERS OF THIS CLUB WITH REGISTRATION FILTER
    $memberQuery = "SELECT * FROM member WHERE delete_status = 0 AND club_id = '$club_id'";

if($reg_status == "registered"){
        $memberQuery .= " AND member_id IN (
            SELECT member_id FROM registration WHERE delete_status=0 AND approve_status=1
        )";
    } elseif($reg_status == "unregistered") {
        $memberQuery .= " AND member_id NOT IN (
            SELECT member_id FROM registration WHERE delete_status=0 AND approve_status=1
        )";
    }

$memberQuery .= " ORDER BY member_id DESC";
    $members = mysqli_query($con, $memberQuery);

// IF NO MEMBERS AVAILABLE
    if (mysqli_num_rows($members) == 0) {
        $sheet->setCellValue("A".$row, "No Members Found");
        $row += 3;
        continue;
    }

// MEMBER DATA ROWS
    $sl = 1;
    while ($mem = mysqli_fetch_assoc($members)) {
        $sheet->setCellValue("A".$row, $sl);
        $sheet->setCellValue("B".$row, $mem['rotarian_name']);
        $sheet->setCellValue("C".$row, $mem['rotary_id']);
        $sheet->setCellValue("D".$row, $mem['phone_number']);
        $sheet->setCellValue("E".$row, $mem['rotarian_email']);
        $row++;
        $sl++;
    }

$row += 3; // spacing before next club
}

// Auto width for all columns
foreach (range('A', 'F') as $col) {
    $sheet->getColumnDimension($col)->setAutoSize(true);
}

// OUTPUT FILE
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="Members_Club_Wise_' . date('d-m-Y_H-i-s') . '.xlsx"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: export_member_excel.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation