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: study-material.php

<?php
// File: /esarthi/student/study-material.php (Student Portal - Access to Uploaded Notes/PDFs)

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

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

$student_id = $_SESSION['student_id'];
$student_name = $_SESSION['student_name'] ?? 'Student';
$institute_name = 'eSarthi Education';

// --- 2. FETCH ALL STUDY MATERIALS RELEVANT TO THE STUDENT'S ACTIVE BATCHES ---
// This query joins notes/materials with the batches the student is actively enrolled in.
$q_materials = $conn->query("
    SELECT 
        sm.material_id, sm.title, sm.description, sm.file_path, sm.material_type, sm.upload_date,
        b.batch_name,
        c.course_name
    FROM study_materials sm
    JOIN batches b ON sm.batch_id = b.batch_id
    JOIN courses c ON b.course_id = c.course_id
    WHERE sm.status = 'Published'
      AND sm.batch_id IN (
        SELECT batch_id FROM enrollments WHERE student_id = $student_id AND status = 'Active'
      )
    ORDER BY sm.upload_date DESC
");

$total_materials = $q_materials->num_rows;

// Define the base path for downloaded files (assuming uploads/notes is relative to the root)
$base_download_path = "../";

// --- 3. 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>Study Material | <?= htmlspecialchars($student_name) ?></title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0/css/all.min.css">
    <style>
        /* Shared Student 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; }
        
        /* Dashboard Header/Banner */
        .dashboard-header { 
            background-color: #0f2b46;
            color: white; 
            padding: 25px 40px; 
            border-bottom: 5px solid #ffc107;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }
        .dashboard-header h1 { margin: 0; font-size: 2em; color: white; }
        .logout-link { background-color: #dc3545; color: white; padding: 8px 15px; border-radius: 5px; font-weight: <b>bold</b>; text-decoration: none; }

/* Navigation */
        .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; }

/* Materials Table */
        .materials-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;
        }
        .materials-table th, .materials-table td { padding: 15px; text-align: left; border-bottom: 1px solid #e0e0e0; font-size: 0.9em; }
        .materials-table th { background-color: #0f2b46; color: white; font-weight: 600; }
        .materials-table tbody tr:hover { background-color: #f9f9f9; }
        
        /* Action Button */
        .btn-download { 
            background-color: #28a745; 
            color: white; 
            padding: 8px 15px; 
            text-decoration: none; 
            border-radius: 5px; 
            font-weight: <b>bold</b>; 
            display: inline-block;
            transition: background-color 0.2s;
        }
        .btn-download:hover { background-color: #1e7e34; }
        .file-type-tag { background-color: #ffc107; color: #0f2b46; padding: 4px 8px; border-radius: 4px; font-size: 0.75em; font-weight: <b>bold</b>; }

/* Responsive Table */
        @media (max-width: 768px) {
            .materials-table thead { display: none; }
            .materials-table tr { margin-bottom: 15px; border: 1px solid #ccc; border-radius: 8px; display: block; }
            .materials-table td {
                display: block; text-align: right; padding-left: 50%; position: relative;
            }
            .materials-table td::before {
                content: attr(data-label); position: absolute; left: 10px; width: 45%; 
                font-weight: <b>bold</b>; text-align: left; color: #0f2b46;
            }
        }
    </style>
</head>
<body>
    
    <div class="dashboard-header">
        <div>
            <h1>📚 Study Material Access</h1>
            <p>Student ID: <b><?= $student_id ?></b> | Welcome, <b><?= htmlspecialchars($student_name) ?></b></p>
        </div>
        <a href="logout.php" class="logout-link"><i class="fas fa-sign-out-alt"></i> Logout</a>
    </div>

<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"><i class="fas fa-certificate"></i> Certificates</a>
        <a href="profile.php"><i class="fas fa-user-circle"></i> Profile Update</a>
        <a href="classes.php"><i class="fas fa-video"></i> Live Classes</a>
        <a href="study-material.php" class="active"><i class="fas fa-book-open"></i> Study Material</a>
    </nav>

<div class="wrapper">
        <h1>📖 Notes and Resources</h1>
        
        <p>Resources uploaded by your teachers for your active batches are listed below. Total <b><?= $total_materials ?></b> materials available.</p>

<?php if ($total_materials > 0): ?>
        
        <table class="materials-table">
            <thead>
                <tr>
                    <th>Title</th>
                    <th>Course / Batch</th>
                    <th>Type</th>
                    <th>Description</th>
                    <th>Upload Date</th>
                    <th>Action</th>
                </tr>
            </thead>
            <tbody>
                <?php while($material = $q_materials->fetch_assoc()): ?>
                <tr>
                    <td data-label="Title"><b><?= htmlspecialchars($material['title']) ?></b></td>
                    <td data-label="Course / Batch">
                        <?= htmlspecialchars($material['course_name']) ?><br>
                        <small style="color:#dc3545;">Batch: <?= htmlspecialchars($material['batch_name']) ?></small>
                    </td>
                    <td data-label="Type">
                        <span class="file-type-tag"><?= htmlspecialchars($material['material_type']) ?></span>
                    </td>
                    <td data-label="Description"><?= htmlspecialchars(substr($material['description'], 0, 50)) ?>...</td>
                    <td data-label="Upload Date"><?= date('Y-m-d', strtotime($material['upload_date'])) ?></td>
                    <td data-label="Action">
                        <?php if ($material['material_type'] == 'File'): ?>
                            <a href="<?= $base_download_path . htmlspecialchars($material['file_path']) ?>" target="_blank" class="btn-download">
                                <i class="fas fa-download"></i> Download PDF/File
                            </a>
                        <?php elseif ($material['material_type'] == 'Link'): ?>
                             <a href="<?= htmlspecialchars($material['file_path']) ?>" target="_blank" class="btn-download" style="background-color: #0f2b46;">
                                <i class="fas fa-external-link-alt"></i> View Link
                            </a>
                        <?php endif; ?>
                    </td>
                </tr>
                <?php endwhile; ?>
            </tbody>
        </table>

<?php else: ?>
            <p style="padding: 20px; background: white; border-radius: 8px;">No study materials have been uploaded for your active courses yet.</p>
        <?php endif; ?>
    </div>
</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: study-material.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation