Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.40.1.lve.el8.x86_64

PHP Version:

8.2.27

User:

u176930106

Directory:

/home/u176930106/domains/inputdata.in/public_html/edusystem

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: tviewstudentss.php

<?php
ob_start();
session_start();
include("includes/connection.php");

// Ensure teacher is logged in
if (!isset($_SESSION['teacher'])) {
    header("Location: teacherlogin.php"); // Redirect to teacher login if not authenticated
    exit();
}

// Fetch the teacher's unique identifier (e.g., mobile) from the session
$teacher_identifier = $_SESSION['teacher']; // Assuming the session stores teacher's mobile

// Fetch the teacher ID from the database using the mobile number
$query = "SELECT id FROM teachers WHERE mobile = '$teacher_identifier' LIMIT 1";
$result = mysqli_query($con, $query);

// Check if the teacher exists in the database and fetch the teacher's ID
if (mysqli_num_rows($result) > 0) {
    $teacher_row = mysqli_fetch_assoc($result);
    $teacher_id = $teacher_row['id'];
} else {
    // If no teacher is found, redirect to the login page
    header("Location: teacherlogin.php");
    exit();
}

// Fetch student ID and teacher ID from the URL
$student_id_from_url = isset($_GET['id']) ? $_GET['id'] : null;
$teacher_id_from_url = isset($_GET['teacherid']) ? $_GET['teacherid'] : null;

if (!$student_id_from_url || !$teacher_id_from_url) {
    echo "Error: Student ID or Teacher ID is missing or invalid.";
    exit();
}

// Fetch the student name and class for displaying
$sql = "SELECT name, class FROM students WHERE id = '$student_id_from_url'";
$res = mysqli_query($con, $sql);
if (mysqli_num_rows($res) > 0) {
    $student = mysqli_fetch_assoc($res);
    $student_name = $student['name'];
    $student_class = $student['class'];
} else {
    echo "Error: No student found with the provided ID.";
    exit();
}

// Fetch the application details for the student
$sql = "SELECT applications.*, 
               students.name AS student_name, 
               students.class AS student_class, 
               students.id AS student_id
        FROM applications 
        LEFT JOIN students ON applications.studentid = students.id
        WHERE applications.studentid = '$student_id_from_url' 
        AND applications.teacherid = '$teacher_id_from_url' 
        ORDER BY applications.id";  // Filtered by both student_id and teacher_id

$res = mysqli_query($con, $sql);

include("includes/headermain.php");
?>

<body>
<div id="main-wrapper">
    <?php include("includes/header.php"); ?>
    <?php include("includes/tbarmenu.php"); ?>
    <div class="page-wrapper">
        <div class="page-breadcrumb">
            <div class="row">
                <div class="col-12 d-flex no-block align-items-center">
                    <h4 class="page-title">List of Applications</h4>
                </div>
            </div>
        </div>
        <div class="container-fluid">
            <div class="row">
                <div class="col-md-12">
                    <div class="card pd-20" style="overflow: auto;">
                        <table class="table text-center">
                            <thead class="text-uppercase bg-primary">
                                <tr class="text-white">
                                    <td align="left"><strong>Student Name</strong></td>
                                    <td align="left"><strong>Subject</strong></td>
                                    <td align="left"><strong>Class</strong></td>
                                    <td align="left"><strong>Message</strong></td>
                                    <td align="left"><strong>Status</strong></td>
                                    <td align="left"><strong>Application Date</strong></td>
                                    <td align="center"><strong>Option</strong></td>
                                </tr>
                            </thead>
                            <tbody>
                                <?php
                                if (mysqli_num_rows($res) > 0) {
                                    while ($row = mysqli_fetch_assoc($res)) {
                                ?>
                                    <tr>
                                        <td align="left"><?php echo stripslashes($row['student_name']); ?></td>
                                        <td align="left"><?php echo stripslashes($row['subject']); ?></td>
                                        <td align="left"><?php echo stripslashes($row['student_class']); ?></td>
                                        <td align="left"><?php echo stripslashes($row['message']); ?></td>
                                        <td align="left">
                                            <?php 
                                                if ($row['status'] == "1") {
                                                    echo "Approved";
                                                } elseif ($row['status'] == "2") {
                                                    echo "Rejected";
                                                } else {
                                                    echo "Pending";
                                                }
                                            ?>
                                        </td>
                                        <td align="left"><?php echo $row['application_date']; ?></td>
                                        <td>
                                            
                                            <a href="tviewstudentdetails.php?id=<?php echo $row['student_id']; ?>&teacherid=<?php echo $teacher_id; ?>" class="btn btn-info">View Student Details</a>
                                            <a href="viewclassschedule.php?student_id=<?php echo $row['student_id']; ?>&teacher_id=<?php echo $teacher_id; ?>"" class="btn btn-warning">Class Schedule</a>
                                        </td>
                                    </tr>
                                <?php 
                                    }
                                } else {
                                    echo "<tr><td colspan='7'>No applications found for this student.</td></tr>";
                                }
                                ?>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <?php include("includes/footer.php"); ?>
</div>

<script src="assets/libs/jquery/dist/jquery.min.js"></script>
<script src="assets/libs/popper.js/dist/umd/popper.min.js"></script>
<script src="assets/libs/bootstrap/dist/js/bootstrap.min.js"></script>
<script src="assets/libs/perfect-scrollbar/dist/perfect-scrollbar.jquery.min.js"></script>
<script src="assets/extra-libs/sparkline/sparkline.js"></script>
<script src="dist/js/waves.js"></script>
<script src="dist/js/sidebarmenu.js"></script>
<script src="dist/js/custom.min.js"></script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: tviewstudentss.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation