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.09 TB

🔧 Quick Actions

✏️ Editing: member_list.php

<?php
include "header.php";
global $con;

// Fetch club list for filter dropdown
$clubs = mysqli_query($con, "SELECT * FROM club WHERE delete_status = 0 ORDER BY club_name ASC");

// Get filter values
$filter_club  = isset($_GET['club_id']) ? intval($_GET['club_id']) : 0;
$reg_status   = isset($_GET['reg_status']) ? $_GET['reg_status'] : "";

// Build query
$query = "SELECT m.*, c.club_name 
          FROM member m 
          LEFT JOIN club c ON m.club_id = c.club_id 
          WHERE m.delete_status = 0";

// Club filter
if ($filter_club > 0) {
    $query .= " AND m.club_id = '$filter_club'";
}

// Registered/Unregistered filter
if($reg_status == "registered"){
    $query .= " AND m.member_id IN (
        SELECT member_id FROM registration WHERE delete_status=0 AND approve_status=1
    )";
} elseif($reg_status == "unregistered") {
    $query .= " AND m.member_id NOT IN (
        SELECT member_id FROM registration WHERE delete_status=0 AND approve_status=1
    )";
}

$query .= " ORDER BY m.member_id DESC";
$members = mysqli_query($con, $query);
?>

<div class="row">
                        <div class="col-12">
                            <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0">Member List</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                                    <li class="breadcrumb-item active">Member List</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header d-flex justify-content-between align-items-center">
                                <h5 class="card-title mb-0">Member List</h5>
                                <div>
                                    <a href="add_member.php" class="btn btn-success btn-sm">Add New</a>
                                    <a href="export_member_excel.php?club_id=<?= $filter_club ?>&reg_status=<?= $reg_status ?>" class="btn btn-primary btn-sm">
                                        Export Excel
                                    </a>
                                </div>
                            </div>

<form method="GET" class="row g-3 mb-3">
                                    
                                    <div class="col-md-3">
                                        <select name="club_id" class="form-select">
                                            <option value="">Filter by Club</option>
                                            <?php 
                                            mysqli_data_seek($clubs, 0);
                                            while($club = mysqli_fetch_assoc($clubs)) { ?>
                                                <option value="<?= $club['club_id'] ?>" 
                                                    <?= ($filter_club == $club['club_id']) ? 'selected' : '' ?>>
                                                    <?= $club['club_name'] ?>
                                                </option>
                                            <?php } ?>
                                        </select>
                                    </div>

<div class="col-md-4 d-flex align-items-center">
                                        <label class="me-3">
                                            <input type="radio" name="reg_status" value="registered" <?= ($reg_status=="registered")?"checked":"" ?>>
                                            Registered
                                        </label>
                                        <label class="ms-3">
                                            <input type="radio" name="reg_status" value="unregistered" <?= ($reg_status=="unregistered")?"checked":"" ?>>
                                            Unregistered
                                        </label>
                                        <label class="ms-3">
                                            <input type="radio" name="reg_status" value="" <?= ($reg_status=="")?"checked":"" ?>>
                                            All
                                        </label>
                                    </div>

<div class="col-md-3">
                                        <button type="submit" class="btn btn-success">Filter</button>
                                        <a href="member_list.php" class="btn btn-secondary">Reset</a>
                                    </div>
                                </form>

<table id="scroll-horizontal"
                                       class="table table-bordered table-striped align-middle nowrap"
                                       style="width:100%">
                                    <thead class="table-light">
                                        <tr>
                                            <th width="5%">Sl. No</th>
                                            <th>Rotarian Name</th>
                                            <th>Club Name</th>
                                            <th>Rotary ID</th>
                                            <th>Phone Number</th>
                                            <th>Email</th>
                                            <th>Gender</th>
                                            <th>T-Shirt Size</th>
                                            <th width="10%">Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        $sl = 1;
                                        while ($member = mysqli_fetch_assoc($members)) {
                                        ?>
                                        <tr>
                                            <td><?= $sl++ ?></td>
                                            <td><?= htmlspecialchars($member['rotarian_name']) ?></td>
                                            <td><?= htmlspecialchars($member['club_name']) ?></td>
                                            <td><?= htmlspecialchars($member['rotary_id']) ?></td>
                                            <td><?= htmlspecialchars($member['phone_number']) ?></td>
                                            <td><?= htmlspecialchars($member['rotarian_email']) ?></td>
                                            <td><?= htmlspecialchars($member['gender'] == 1 ? 'Male' : ($member['gender'] == 2 ? 'Female' : '')) ?></td>
                                            <td><?= htmlspecialchars($member['t_shirt_and_shirt_size']) ?></td>
                                            <td>
                                                <a href="edit_member.php?member_id=<?= $member['member_id'] ?>" 
                                                   class="btn btn-info btn-sm">
                                                    <i class="ri-pencil-fill"></i>
                                                </a>
                                            </td>
                                        </tr>
                                        <?php } ?>
                                    </tbody>
                                </table>

</div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

<?php include "footer.php"; ?>
    </div>
</div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: member_list.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation