Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/aqua-walrus-487298.hostingersite.com/public_html/admin

Free Space:

8.23 TB

🔧 Quick Actions

✏️ Editing: manage-students.php

<?php
// File: /esarthi/admin/manage-students.php (Admin Panel - Student Management List)

session_start();
// --- 1. SECURITY CHECK ---
if (!isset($_SESSION['admin'])) {
    header("Location: login.php");
    exit();
}

require_once("../config/db.php");

$message = "";
$search_query = "";

// --- 2. HANDLE SEARCH ---
if (isset($_GET['search']) && !empty($_GET['search'])) {
    $search_term = $conn->real_escape_string($_GET['search']);
    // Improved search: checks name, email, mobile, city, and batch name
    $search_query = " AND (s.full_name LIKE '%$search_term%' OR s.email LIKE '%$search_term%' OR s.mobile LIKE '%$search_term%' OR s.city LIKE '%$search_term%' OR b.batch_name LIKE '%$search_term%')";
}

// --- 3. FETCH ACTIVE STUDENT DATA (Robust Query) ---
$sql_students = "
    SELECT 
        s.student_id, s.full_name, s.email, s.mobile, s.city, s.admission_date, s.status,
        b.batch_name,
        c.course_name
    FROM students s
    LEFT JOIN enrollments e ON s.student_id = e.student_id AND e.status = 'Active'
    LEFT JOIN batches b ON e.batch_id = b.batch_id
    LEFT JOIN courses c ON b.course_id = c.course_id
    WHERE s.status IN ('active', 'inactive', 'suspended') /* Show all registered students */
    $search_query
    ORDER BY s.admission_date DESC
";

$q_students = $conn->query($sql_students);
$total_students = $q_students->num_rows; // Renamed to total_students as we show all statuses

// --- 4. HTML structure and output follow below ---
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Admin Panel - Manage Students</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
    <style>
        /* Admin UI Style Consistency */
        body { font-family: 'Poppins', sans-serif; padding: 0; margin: 0; background-color: #f4f4f9; color: #333; }
        .wrapper { padding: 20px 40px; max-width: 1400px; margin: 0 auto; }
        h1, h2 { color: #0f2b46; }
        
        /* Navigation Bar */
        .admin-nav { padding: 10px 0; margin-bottom: 20px; border-bottom: 2px solid #eee; }
        .admin-nav a { 
            color: #555; text-decoration: none; font-weight: 600; padding: 5px 10px; border-radius: 5px; 
            margin-right: 10px; transition: color 0.2s;
        }
        .admin-nav a:hover, .admin-nav a.active { color: #dc3545; }

/* Messages */
        .message { padding: 12px; border-radius: 6px; margin-bottom: 20px; font-weight: 600; }
        .success { background-color: #d4edda; color: #155724; border: 1px solid #c3e6cb; }
        .error { background-color: #f8d7da; color: #721c24; border: 1px solid #f5c6fb; }

/* Student List Table */
        .student-table {
            width: 100%; border-collapse: collapse; margin-top: 20px; 
            box-shadow: 0 4px 15px rgba(0,0,0,0.1); background: white; border-radius: 8px; overflow: hidden;
        }
        .student-table th, .student-table td { padding: 12px 15px; text-align: left; border-bottom: 1px solid #e0e0e0; font-size: 0.9em; }
        .student-table th { background-color: #0f2b46; color: white; font-weight: 600; }
        .student-table tbody tr:hover { background-color: #f9f9f9; }
        
        /* Action Buttons */
        .btn-action { 
            padding: 5px 10px; 
            text-decoration: none; 
            border-radius: 4px; 
            font-size: 0.8em; 
            margin-right: 5px; 
            display: inline-block;
        }
        .btn-view { background-color: #ffc107; color: #0f2b46; }
        .btn-fees { background-color: #28a745; color: white; }
        .btn-add { background-color: #dc3545; color: white; }
        
        /* Status Badges */
        .status-badge { padding: 3px 8px; border-radius: 4px; font-size: 0.8em; font-weight: <b>bold</b>; }
        .status-active { background-color: #d4edda; color: #155724; }
        .status-inactive { background-color: #f8d7da; color: #721c24; }
        .status-suspended { background-color: #fff3cd; color: #856404; }

/* Search Bar */
        .search-container { margin-bottom: 20px; display: flex; gap: 10px; align-items: center; }
        .search-container input { padding: 10px; border: 1px solid #ccc; border-radius: 4px; width: 300px; }
        .search-container button { padding: 10px 15px; background-color: #0f2b46; color: white; border: none; border-radius: 4px; cursor: pointer; }

/* Responsive Table */
        @media (max-width: 768px) {
            .search-container { flex-wrap: wrap; }
            .search-container input { width: 100%; }
            .search-container button { width: 45%; }
            .student-table, .student-table tbody, .student-table tr, .student-table td { display: block; width: 100%; }
            .student-table thead { display: none; }
            .student-table tr { margin-bottom: 15px; border: 1px solid #ccc; border-radius: 8px; }
            .student-table td {
                text-align: right; padding-left: 50%; position: relative;
            }
            .student-table td::before {
                content: attr(data-label); position: absolute; left: 10px; width: 45%; 
                padding-right: 10px; white-space: nowrap; font-weight: <b>bold</b>; text-align: left; color: #0f2b46;
            }
        }
    </style>
</head>
<body>
    <div class="wrapper">
        <?php if (isset($_GET['msg'])): ?>
            <div class="message <?= (strpos($_GET['msg'], '✅') !== false) ? 'success' : 'error' ?>">
                <?= urldecode($_GET['msg']) ?>
            </div>
        <?php endif; ?>
        
        <h1>👨‍🎓 Student Management Panel</h1>
        <div class="admin-nav">
            <a href="dashboard.php"><i class="fas fa-tachometer-alt"></i> Dashboard</a>
            <a href="manage-inquiries.php"><i class="fas fa-question-circle"></i> Inquiries</a>
            <a href="manage-students.php" class="active" style="color:#dc3545; border-bottom: 2px solid #dc3545;"><i class="fas fa-user-graduate"></i> Students</a>
            <a href="manage-courses.php"><i class="fas fa-book"></i> Courses</a>
            <a href="manage-payments.php"><i class="fas fa-dollar-sign"></i> Payments</a>
            <a href="logout.php" style="float: right;"><i class="fas fa-sign-out-alt"></i> Logout</a>
        </div>
        <hr>

<h2>All Student Records (<b><?= $total_students ?></b>)</h2>
        
        <form method="GET" action="manage-students.php" class="search-container">
            <input type="text" name="search" placeholder="Search by Name, Email, or Mobile..." value="<?= htmlspecialchars($_GET['search'] ?? '') ?>">
            <button type="submit"><i class="fas fa-search"></i> Search</button>
            <?php if (!empty($search_query)): ?>
                <a href="manage-students.php" class="btn-action" style="background-color: #555;"><i class="fas fa-times"></i> Clear</a>
            <?php endif; ?>
            <a href="add-student.php" class="btn-action btn-add" style="margin-left: auto;"><i class="fas fa-plus"></i> Add New Student</a>
        </form>

<?php if ($total_students > 0): ?>
        <table class="student-table">
            <thead>
                <tr>
                    <th>ID</th>
                    <th>Full Name / Contact</th>
                    <th>Admission Date</th>
                    <th>Course / Batch</th>
                    <th>Status</th>
                    <th>Actions</th>
                </tr>
            </thead>
            <tbody>
                <?php while($student = $q_students->fetch_assoc()): ?>
                <tr>
                    <td data-label="ID"><?= $student['student_id'] ?></td>
                    <td data-label="Full Name / Contact">
                        <b><?= htmlspecialchars($student['full_name']) ?></b><br>
                        <small style="color:#666;"><?= htmlspecialchars($student['email']) ?> | <?= htmlspecialchars($student['mobile']) ?></small>
                    </td>
                    <td data-label="Admission Date"><?= date('Y-m-d', strtotime($student['admission_date'])) ?></td>
                    <td data-label="Course / Batch">
                        <?= htmlspecialchars($student['course_name'] ?? 'N/A') ?><br>
                        <small style="color:#dc3545;"><?= htmlspecialchars($student['batch_name'] ?? 'N/A') ?></small>
                    </td>
                    <td data-label="Status">
                        <span class="status-badge status-<?= strtolower($student['status']) ?>">
                            <?= ucfirst($student['status']) ?>
                        </span>
                    </td>
                    <td data-label="Actions">
                        <a href="edit-student.php?id=<?= $student['student_id'] ?>" class="btn-action btn-view">
                            <i class="fas fa-edit"></i> Edit / Enroll
                        </a>
                        <a href="manage-payments.php?student_id=<?= $student['student_id'] ?>" class="btn-action btn-fees">
                            <i class="fas fa-rupee-sign"></i> Manage Fees
                        </a>
                    </td>
                </tr>
                <?php endwhile; ?>
            </tbody>
        </table>
        <?php else: ?>
            <p style="padding: 20px; background: white; border-radius: 8px;">
                <?php if (!empty($search_query)): ?>
                    No student records found matching your search criteria.
                <?php else: ?>
                    There are no registered student records yet.
                <?php endif; ?>
            </p>
        <?php endif; ?>
    </div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-students.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation