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_pdf.php

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

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

// CREATE EXCEL OBJECT
$objPHPExcel = new PHPExcel();
$objPHPExcel->removeSheetByIndex(0); // remove default blank sheet

// GET ALL CLUBS (or only one if filtered)
$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);

// LOOP THROUGH CLUBS → ONE SHEET PER CLUB
while ($club = mysqli_fetch_assoc($clubs)) {

$club_id   = $club['club_id'];
    $club_name = $club['club_name'];

// CREATE SHEET
    $sheet = new PHPExcel_Worksheet($objPHPExcel, $club_name);
    $objPHPExcel->addSheet($sheet);
    $objPHPExcel->setActiveSheetIndexByName($club_name);

// HEADER STYLE
    $headerStyle = array(
        "font" => array(
            "bold" => true,
            "color" => array("rgb" => "000000"),
            "size" => 11,
            "name" => "Arial"
        )
    );

// TABLE HEADINGS
    $headers = [
        "A1" => "Sl No",
        "B1" => "Rotarian Name",
        "C1" => "Club Name",
        "D1" => "Rotary ID",
        "E1" => "Phone Number",
        "F1" => "Email"
    ];

foreach ($headers as $cell => $text) {
        $sheet->setCellValue($cell, $text);
    }

$sheet->getStyle("A1:F1")->applyFromArray($headerStyle);

// GET MEMBERS OF THIS CLUB
    $memberQuery = "
        SELECT 
            m.*,
            c.club_name
        FROM member m
        LEFT JOIN club c ON m.club_id = c.club_id
        WHERE m.delete_status = 0
        AND m.club_id = '$club_id'
        ORDER BY m.member_id DESC
    ";
    $members = mysqli_query($con, $memberQuery);

// FILLED ROWS
    $row = 2;
    $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['club_name']);
        $sheet->setCellValue("D".$row, $mem['rotary_id']);
        $sheet->setCellValue("E".$row, $mem['phone_number']);
        $sheet->setCellValue("F".$row, $mem['rotarian_email']);

$row++;
        $sl++;
    }

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

// OUTPUT EXCEL FILE
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="MemberList_'.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_pdf.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation