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: interns.php

<?php include('config/db.php'); ?>
<!doctype html>
<html lang="en">

<head>
    <title>Admin | Interns</title>
    <?php include('links/head.php'); ?>
    <style>
        .intern-badge {
            background-color: #20c997;
            color: white;
            padding: 3px 8px;
            border-radius: 4px;
            font-size: 0.8rem;
            margin-left: 5px;
        }
    </style>
</head>

<div class="d-flex justify-content-between align-items-center mb-3">
                                        <h2 class="card-title">Interns <span class="intern-badge">INTERN</span></h2>
                                        <a href="add-intern.php" class="btn btn-primary">+ Add Intern</a>
                                    </div>

<form method="GET" class="mb-4">
                                        <div class="row">
                                            <div class="col-md-4">
                                                <label>Filter by Project Manager:</label>
                                                <select name="manager_id" class="form-select">
                                                    <option value="">All Interns</option>
                                                    <?php
                                                    // Get all project managers
                                                    $managers_query = "SELECT id, name FROM interns WHERE role LIKE '%Project Manager%' AND status = 'active'";
                                                    $managers_result = mysqli_query($conn, $managers_query);
                                                    while ($manager = mysqli_fetch_assoc($managers_result)) {
                                                        $selected = isset($_GET['manager_id']) && $_GET['manager_id'] == $manager['id'] ? 'selected' : '';
                                                        echo "<option value='{$manager['id']}' $selected>{$manager['name']}</option>";
                                                    }
                                                    ?>
                                                </select>
                                            </div>
                                            <div class="col-md-2 align-self-end">
                                                <button type="submit" class="btn btn-primary">Filter</button>
                                                <a href="interns.php" class="btn btn-secondary">Reset</a>
                                            </div>
                                        </div>
                                    </form>

<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>Intern ID</th>
                                                <th>Name</th>
                                                <th>Email</th>
                                                <th>Phone</th>
                                                <th>Role</th>
                                                <th>Duration</th>
                                                <th>Under By</th>
                                                <th>Status</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>

<tbody>
                                            <?php
                                            // Base query
                                            $query = "SELECT i.*, 
                                                     CONCAT(DATEDIFF(i.end_date, i.start_date), ' days') AS duration,
                                                     m.name AS manager_name
                                                     FROM interns i
                                                     LEFT JOIN interns m ON i.under_by = m.id";
                                            
                                            // Add filter if manager is selected
                                            if (isset($_GET['manager_id']) && !empty($_GET['manager_id'])) {
                                                $manager_id = (int)$_GET['manager_id'];
                                                $query .= " WHERE i.under_by = $manager_id";
                                            }
                                            
                                            $query .= " ORDER BY i.id DESC";
                                            
                                            $result = mysqli_query($conn, $query);
                                            $serial = 1;
                        
                                            if ($result && mysqli_num_rows($result) > 0) {
                                                while ($row = mysqli_fetch_assoc($result)) {
                                                    echo "<tr>";
                                                    echo "<td>" . $serial++ . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['intern_id']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['name']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['email']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['phone']) . "</td>";
                                                    echo "<td>" . htmlspecialchars($row['role']) . "</td>";
                                                    echo "<td>";
                                                    if ($row['start_date'] && $row['end_date']) {
                                                        $start = new DateTime($row['start_date']);
                                                        $end = new DateTime($row['end_date']);
                                                        $interval = $start->diff($end);
                                                        echo $interval->format('%m months %d days');
                                                    } else {
                                                        echo "N/A";
                                                    }
                                                    echo "</td>";
                                                    echo "<td>" . ($row['manager_name'] ? htmlspecialchars($row['manager_name']) : 'GM') . "</td>";
                                                    echo "<td><span class='badge bg-" . 
                                                         ($row['status'] == 'active' ? 'success' : 'danger') . 
                                                         "'>" . ucfirst($row['status']) . "</span></td>";
                                                    echo "<td>
                                                            <a href='view-intern.php?id={$row['id']}' class='btn btn-sm btn-info' title='View'><i class='fas fa-eye'></i></a>
                                                            <a href='edit-intern.php?id={$row['id']}' class='btn btn-sm btn-warning' title='Edit'><i class='fas fa-edit'></i></a>
                                                            <a href='delete-intern.php?id={$row['id']}' class='btn btn-sm btn-danger' title='Delete' onclick=\"return confirm('Are you sure you want to delete this intern?');\"><i class='fas fa-trash'></i></a>
                                                        </td>";
                                                    echo "</tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='10' class='text-center'>No interns 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>

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: interns.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation