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/jkma.co.in/public_html

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewclasses.php

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

$heading = 'Class';
$limit = 100;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$start = ($page - 1) * $limit;

$filters = [];
$where = "WHERE 1";
if (!empty($_GET['from_date'])) {
    $from = $_GET['from_date'];
    $where .= " AND DATE(created_at) >= '$from'";
    $filters[] = "from_date=$from";
}
if (!empty($_GET['to_date'])) {
    $to = $_GET['to_date'];
    $where .= " AND DATE(created_at) <= '$to'";
    $filters[] = "to_date=$to";
}
if (!empty($_GET['name'])) {
    $pn = mysqli_real_escape_string($con, $_GET['name']);
    $where .= " AND name LIKE '%$pn%'";
    $filters[] = "name=" . urlencode($pn);
}

$filterQuery = implode("&", $filters);

if (isset($_GET['activate'])) {
    $id = (int)$_GET['activate'];
    mysqli_query($con, "UPDATE classes SET status = 1 WHERE id = $id");
    $_SESSION['success'] = "Record activated successfully.";
    header("Location: viewclasses.php");
    exit;
}

if (isset($_GET['deactivate'])) {
    $id = (int)$_GET['deactivate'];
    mysqli_query($con, "UPDATE classes SET status = 0 WHERE id = $id");
    $_SESSION['success'] = "Record deactivated successfully.";
    header("Location: viewclasses.php");
    exit;
}

// Handle delete
if (isset($_GET['delete']) && is_numeric($_GET['delete'])) {
    $id = (int)$_GET['delete'];
    mysqli_query($con, "DELETE FROM classes WHERE id = $id");
    $_SESSION['success'] = "Record deleted successfully.";
    header("Location: viewclasses.php");
    exit;
}

// Fetch data
$res = mysqli_query($con, "SELECT * FROM classes $where ORDER BY id DESC LIMIT $start, $limit");
$totalRes = mysqli_query($con, "SELECT COUNT(*) as total FROM classes $where");
$total = mysqli_fetch_assoc($totalRes)['total'];
$totalPages = ceil($total / $limit);
include("includes/headermain.php");
?>
<body>
    <div id="main-wrapper">
        <?php include("includes/header.php"); ?>
        <?php include("includes/leftmenu.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 <?php print $heading; ?>(s)</h4>
                    </div>
                </div>
            </div>
            <div class="container-fluid">
                <div class="row">
                    <div class="col-md-12">
                        <div class="card pd-20">
                            <?php if (isset($_SESSION['success'])): ?>
                                <div class="alert alert-success"><?php echo htmlspecialchars($_SESSION['success']); ?></div>
                                <?php unset($_SESSION['success']); ?>
                            <?php elseif (isset($_SESSION['error'])): ?>
                                <div class="alert alert-danger"><?php echo htmlspecialchars($_SESSION['error']); ?></div>
                                <?php unset($_SESSION['error']); ?>
                            <?php endif; ?>
                            
                            <div class="table-responsive">
                                <table class="table">
                                    <thead class="text-uppercase bg-primary">
                                        <tr class="text-white">
                                            <th align="left">Sl.</th>
                                            <th align="left">Date</th>
                                            <th align="left">Class</th>
                                            <th align="left">Options</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        $sl = $start + 1;
                                        while ($row = mysqli_fetch_assoc($res)) {
                                            $rowClass = $row['status'] == 0 ? 'table-danger' : '';
                                        ?>
                                            <tr class="<?= $rowClass ?>">
                                                <td align="left"><?php print $sl++; ?></td>
                                                <td align="left"><?php print dtconvert($row['created_at']); ?></td>
                                                <td align="left"><?php print htmlspecialchars($row['class']); ?></td>
                                                <td align="left">
                                                    <a href="addclass.php?id=<?= $row['id'] ?>" class="btn btn-sm btn-info">Edit</a>&nbsp;
                                                    <a href="?delete=<?= $row['id'] ?>" class="btn btn-sm btn-danger" onclick="return confirm('Delete this?')">Delete</a>&nbsp;
                                                    <?php if ($row['status'] == 1): ?>
                                                        <a href="?deactivate=<?= $row['id'] ?>" class="btn btn-sm btn-warning">Deactivate</a>
                                                    <?php else: ?>
                                                        <a href="?activate=<?= $row['id'] ?>" class="btn btn-sm btn-success">Activate</a>
                                                    <?php endif; ?>
                                                </td>
                                            </tr>
                                        <?php
                                        }
                                        ?>
                                    </tbody>
                                </table>

<?php if ($totalPages > 1): ?>
                                    <nav>
                                        <ul class="pagination">
                                            <?php for ($i = 1; $i <= $totalPages; $i++): ?>
                                                <li class="page-item <?= $i == $page ? 'active' : '' ?>">
                                                    <a class="page-link" href="?<?= $filterQuery ?>&page=<?= $i ?>"><?= $i ?></a>
                                                </li>
                                            <?php endfor; ?>
                                        </ul>
                                    </nav>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <?php include("includes/footer.php"); ?>
        </div>
    </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>
    
    
    
    <script src="assets/libs/flot/excanvas.js"></script>
    <script src="assets/libs/flot/jquery.flot.js"></script>
    <script src="assets/libs/flot/jquery.flot.pie.js"></script>
    <script src="assets/libs/flot/jquery.flot.time.js"></script>
    <script src="assets/libs/flot/jquery.flot.stack.js"></script>
    <script src="assets/libs/flot/jquery.flot.crosshair.js"></script>
    <script src="assets/libs/flot.tooltip/js/jquery.flot.tooltip.min.js"></script>
    <script src="dist/js/pages/chart/chart-page-init.js"></script>
</body>

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewclasses.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation