Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/hifi11.in/public_html/ems/admin

Free Space:

10.26 TB

🔧 Quick Actions

✏️ Editing: student-registrations.php

<?php include('config/db.php'); ?>

<!doctype html>
<html lang="en">

<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Admin | New Enrollments</title>
    <?php include('links/head.php'); ?>

<link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.15.1/css/all.min.css" rel="stylesheet">
</head>

<div class="main-content">
            <div class="page-content">
                <div class="container-fluid">
                    <?php
include('../../db_config.php'); // Database connection using PDO

// Fetch data from the 'enrollments' table
try {
    $db = getDBConnection();
    $query = "SELECT * FROM enrollments ORDER BY id DESC";
    $stmt = $db->query($query);
    $enrollments = $stmt->fetchAll(PDO::FETCH_ASSOC);

// Fetch the total count of enrollments
    $countQuery = "SELECT COUNT(*) as total FROM enrollments";
    $countStmt = $db->query($countQuery);
    $totalEnrollments = $countStmt->fetch(PDO::FETCH_ASSOC)['total'];
} catch (PDOException $e) {
    die("Error fetching enrollments: " . $e->getMessage());
}
?>
 <div class="container-fluid">
        <div class="row">
            
            <div class="col-md-6 col-xl-3">
                <div class="card text-center">
                    <div class="mb-2 card-body text-muted">
                        <h3 class="text-info mt-2"><?php echo $totalEnrollments; ?></h3> Total Enrollments
                    </div>
                </div>
            </div>
            
            <div class="col-md-6 col-xl-3">
                <div class="card text-center">
                    <div class="mb-2 card-body text-muted">
                        <h3 class="text-purple mt-2"><?php echo $totalEnrollments*499; ?></h3> Total Revenue
                    </div>
                </div>
            </div>

</div>
    </div>
                    <div class="row">
                        <div class="col-12">
                            <div class="card">
                                <div class="card-body">

<table id="datatable" class="table table-bordered dt-responsive nowrap"
                                        style="border-collapse: collapse; border-spacing: 0; width: 100%;">
                                        <thead>
                                            <tr>
                                                <th>S.No.</th>
                                                <th>Full Name</th>
                                                <th>Whatsapp</th>
                                                <th>Email</th>
                                                <th>Screenshot</th>
                                                <th>Created At</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        
                                        <tbody>
                                            <?php
                                            if ($enrollments) {
                                                $serial = 1;
                                                foreach ($enrollments as $row) {
                                                    echo "<tr>";
                                                    echo "<td>" . $serial++ . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['fullname']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['whatsapp']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['email']) . "</td>";
                                                    // Thumbnail Image with Modal Trigger
                                                    echo "<td>
                                                            <a href='#' data-toggle='modal' data-target='#viewImageModal{$row['id']}'>
                                                                <img src='../../" . htmlspecialchars($row['screenshot']) . "' width='100' height='100' alt='Screenshot'>
                                                            </a>
                                                          </td>";
                                                    echo "<td>" . htmlspecialchars($row['created_at']) . "</td>";
                                                    // View button
                                                   echo "<td>
        <a href='delete-enrollment.php?id={$row['id']}' class='btn btn-sm btn-danger' title='Delete' onclick=\"event.preventDefault(); alert('You are about to delete this enrollment. Please confirm deletion.'); window.location.href='delete-enrollment.php?id={$row['id']}';\">
            <i class='fas fa-trash'></i>
        </a>
      </td>";

echo "</tr>";

// Modal for each row
                                                    echo "<div class='modal fade' id='viewImageModal{$row['id']}' tabindex='-1' role='dialog' aria-labelledby='viewImageModalLabel' aria-hidden='true'>
                                                            <div class='modal-dialog' role='document'>
                                                                <div class='modal-content'>
                                                                    <div class='modal-header'>
                                                                        <h5 class='modal-title' id='viewImageModalLabel'>View Screenshot</h5>
                                                                        <button type='button' class='close' data-dismiss='modal' aria-label='Close'>
                                                                            <span aria-hidden='true'>&times;</span>
                                                                        </button>
                                                                    </div>
                                                                    <div class='modal-body'>
                                                                        <img src='../../" . htmlspecialchars($row['screenshot']) . "' class='img-fluid' alt='Screenshot'>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </div>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='7' class='text-center'>No enrollments found.</td></tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>

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

</div> 
            </div>

<?php include('includes/footer.php'); ?> 
        </div> 
    </div>

<?php include('includes/rightbar.php'); ?>

<div class="rightbar-overlay"></div>

<script src="https://code.jquery.com/jquery-3.5.1.slim.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/@popperjs/core@2.9.3/dist/umd/popper.min.js"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>

<?php include('links/scripts.php'); ?> 
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: student-registrations.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation