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/student

Free Space:

8.3 TB

🔧 Quick Actions

✏️ Editing: certificates.php

<?php
// File: student/certificates.php (UPDATED FOR PROFESSIONAL STUDENT UI)

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

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

$student_id = $_SESSION['student_id'];
$student_name = $_SESSION['student_name'] ?? 'Student';

// --- DATABASE SCHEMA ASSUMPTION ---
// We assume a 'certificates' table exists with the necessary columns.

// === 2. FETCH EARNED CERTIFICATES ===
$q_certificates = $conn->query("
    SELECT 
        cert.title, 
        cert.issue_date, 
        cert.certificate_path,
        c.course_name
    FROM certificates cert
    JOIN courses c ON cert.course_id = c.course_id
    WHERE cert.student_id = $student_id AND cert.status = 'Issued'
    ORDER BY cert.issue_date DESC
");

// --- 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>Certificates | <?= htmlspecialchars($student_name) ?></title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
    <style>
        /* Color Palette: Dark Navy #0f2b46, Accent Red #dc3545, Accent Orange #ffc107 */
        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 (Replicating dashboard nav style) */
        .dashboard-nav { 
            background-color: white;
            padding: 10px 40px;
            box-shadow: 0 2px 8px rgba(0, 0, 0, 0.1);
            display: flex;
            flex-wrap: wrap;
            gap: 20px;
            margin-bottom: 20px;
        }
        .dashboard-nav a { 
            text-decoration: none; 
            color: #555; 
            font-weight: 600; 
            padding: 10px 0;
            border-bottom: 2px solid transparent; 
            transition: all 0.2s;
        }
        .dashboard-nav a:hover, .dashboard-nav a.active {
            color: #0f2b46;
            border-bottom-color: #ffc107;
        }

h2 { color: #0f2b46; margin-top: 30px; border-bottom: 2px solid #eee; padding-bottom: 5px; }

/* Certificates Table */
        .cert-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;
        }
        .cert-table th, .cert-table td {
            padding: 15px;
            text-align: left;
            border-bottom: 1px solid #e0e0e0;
            font-size: 0.9em;
        }
        .cert-table th {
            background-color: #0f2b46;
            color: white;
            font-weight: 600;
        }
        .cert-table tbody tr:hover {
            background-color: #f9f9f9;
        }
        
        /* Download Button */
        .download-btn { 
            background-color: #dc3545; /* Red for emphasis */
            color: white; 
            padding: 8px 12px; 
            text-decoration: none; 
            border-radius: 5px; 
            display: inline-block; 
            font-weight: bold; 
            transition: background-color 0.2s;
        }
        .download-btn:hover {
            background-color: #b82c3a;
        }

/* Responsive Table */
        @media (max-width: 768px) {
            .dashboard-nav { flex-direction: column; gap: 10px; padding: 10px 20px; }
            
            .cert-table, .cert-table tbody, .cert-table tr, .cert-table td {
                display: block;
                width: 100%;
            }
            .cert-table thead { display: none; }
            .cert-table tr { margin-bottom: 15px; border: 1px solid #ccc; border-radius: 8px; }
            .cert-table td {
                text-align: right;
                padding-left: 50%;
                position: relative;
            }
            .cert-table td::before {
                content: attr(data-label);
                position: absolute;
                left: 10px;
                width: 45%;
                padding-right: 10px;
                white-space: nowrap;
                font-weight: bold;
                text-align: left;
                color: #0f2b46;
            }
            .cert-table td:last-child {
                text-align: center;
            }
        }
    </style>
</head>
<body>
    <div class="wrapper">
        <h1>🏅 My Certificates</h1>
        
        <nav class="dashboard-nav">
            <a href="dashboard.php"><i class="fas fa-home"></i> Dashboard</a>
            <a href="fees.php"><i class="fas fa-receipt"></i> Fee Receipts</a>
            <a href="attendance.php"><i class="fas fa-user-check"></i> Attendance Report</a>
            <a href="results.php"><i class="fas fa-poll-h"></i> Results / Tests</a>
            <a href="certificates.php" class="active"><i class="fas fa-certificate"></i> Certificates</a>
            <a href="profile.php"><i class="fas fa-user-circle"></i> Profile Update</a>
            <a href="logout.php" style="margin-left: auto; color: #dc3545;"><i class="fas fa-sign-out-alt"></i> Logout</a>
        </nav>
        <hr>
        
        <h2>Certificates Earned for Completed Courses</h2>
        
        <?php if ($q_certificates->num_rows > 0): ?>
        <p>Congratulations! You have earned **<?= $q_certificates->num_rows ?>** certificate<?= ($q_certificates->num_rows > 1 ? 's' : '') ?>.</p>

<table class="cert-table">
            <thead>
                <tr>
                    <th data-label="Certificate Title">Certificate Title</th>
                    <th data-label="Course Name">Course Name</th>
                    <th data-label="Issue Date">Issue Date</th>
                    <th data-label="Download">Download</th>
                </tr>
            </thead>
            <tbody>
                <?php while($cert = $q_certificates->fetch_assoc()): ?>
                <tr>
                    <td data-label="Certificate Title"><strong><?= htmlspecialchars($cert['title']) ?></strong></td>
                    <td data-label="Course Name"><?= htmlspecialchars($cert['course_name']) ?></td>
                    <td data-label="Issue Date"><?= date('Y-m-d', strtotime($cert['issue_date'])) ?></td>
                    <td data-label="Download">
                        <?php if (!empty($cert['certificate_path'])): ?>
                            <a href="../<?= $cert['certificate_path'] ?>" target="_blank" class="download-btn">
                                <i class="fas fa-download"></i> Download PDF
                            </a>
                        <?php else: ?>
                            <span style="color: #ffc107; font-weight: bold;">Processing...</span>
                        <?php endif; ?>
                    </td>
                </tr>
                <?php endwhile; ?>
            </tbody>
        </table>
        <?php else: ?>
            <p style="padding: 20px; background: white; border-radius: 8px;">You have not been issued any certificates yet. Certificates are issued upon successful completion of a course.</p>
        <?php endif; ?>
    </div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: certificates.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation