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/udan.org.in/public_htmlbkp/webadmin

Free Space:

1.91 TB

🔧 Quick Actions

✏️ Editing: viewusers.php

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

// --- Handle toggle status ---
if (isset($_GET['toggle_status'], $_GET['id'])) {
    $id = intval($_GET['id']);
    $new_status = intval($_GET['toggle_status']);

// Update users table
    $con->query("UPDATE users SET status='$new_status' WHERE id='$id'");

// Update admin table
    $con->query("UPDATE admin SET status='$new_status' WHERE ref='$id' AND type='user'");

$_SESSION['msg'] = $new_status ? "User activated successfully." : "User deactivated successfully.";
    header("Location: viewusers.php");
    exit();
}

// --- Handle delete ---
if (isset($_GET['delete_id'])) {
    $id = intval($_GET['delete_id']);

// Delete from users table
    $con->query("DELETE FROM users WHERE id='$id'");

// Delete from admin table
    $con->query("DELETE FROM admin WHERE ref='$id' AND type='user'");

$_SESSION['msg'] = "User deleted successfully.";
    header("Location: viewusers.php");
    exit();
}

// --- Filters ---
$name = $_GET['name'] ?? '';
$username = $_GET['username'] ?? '';

// --- Build query ---
$sql = "SELECT * FROM users WHERE 1 ";
$params = [];
$types = "";

// Name filter
if ($name) {
    $sql .= " AND name LIKE ?";
    $params[] = "%$name%";
    $types .= "s";
}

// Username filter
if ($username) {
    $sql .= " AND username LIKE ?";
    $params[] = "%$username%";
    $types .= "s";
}

$sql .= " ORDER BY id DESC";

// --- Pagination ---
$limit = 20;
$page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
$offset = ($page - 1) * $limit;

// Count total rows
$countSql = str_replace("SELECT *", "SELECT COUNT(*)", $sql);
$stmt = $con->prepare($countSql);
if ($types) $stmt->bind_param($types, ...$params);
$stmt->execute();
$stmt->bind_result($totalRows);
$stmt->fetch();
$stmt->close();

// Fetch paginated rows
$sql .= " LIMIT $offset, $limit";
$stmt = $con->prepare($sql);
if ($types) $stmt->bind_param($types, ...$params);
$stmt->execute();
$res = $stmt->get_result();
$users = $res->fetch_all(MYSQLI_ASSOC);
$stmt->close();

// --- Flash Messages ---
$flash_success = $_SESSION['msg'] ?? '';
$flash_error = $_SESSION['msgerr'] ?? '';
unset($_SESSION['msg'], $_SESSION['msgerr']);

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

<body>
    
    
    <div id="preloader">
        <div class="loader"></div>
    </div>
    
    
    <div class="page-container">
        
        <?php include("includes/leftmenu.php"); ?>
        
        
        <div class="main-content">
            
            <?php include("includes/header.php"); ?>
            
            <div class="main-content-inner">
                
                <div> 
                    <div class="col-lg-12 mt-4">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="header-title">List of Users</h4>

<?php if ($flash_success): ?>
                                    <div class="alert alert-success"><?= htmlspecialchars($flash_success) ?></div>
                                <?php endif; ?>
                                <?php if ($flash_error): ?>
                                    <div class="alert alert-danger"><?= htmlspecialchars($flash_error) ?></div>
                                <?php endif; ?>

<form class="row g-2 mb-3" method="GET">
                                    <div class="col-md-4 mb-3">
                                        <label class="form-label fw-bold">Name</label>
                                        <input type="text" name="name" value="<?= htmlspecialchars($name) ?>" class="form-control" placeholder="Search by Name">
                                    </div>
                                    <div class="col-md-4 mb-3">
                                        <label class="form-label fw-bold">Username</label>
                                        <input type="text" name="username" value="<?= htmlspecialchars($username) ?>" class="form-control" placeholder="Search by Username">
                                    </div>
                                    <div class="col-md-12 mt-2 d-flex gap-2">
                                        <button type="submit" class="btn btn-primary">Search</button>&nbsp;&nbsp;
                                        <a href="viewusers.php" class="btn btn-primary">Show All</a>
                                    </div>
                                </form>

<div class="table-responsive">
                                    <table class="table table-hover">
                                        <thead class="bg-primary text-white text-uppercase">
                                            <tr>
                                                <th>Sl</th>
                                                <th>Date</th>
                                                <th>Name</th>
                                                <th>Username</th>
                                                <th>Password</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            $sl = $offset + 1;
                                            foreach ($users as $user):
                                                $row_class = $user['status'] == 0 ? 'table-danger' : '';
                                                $decoded_password = base64_decode($user['password']);
                                            ?>
                                                <tr class="<?= $row_class ?>">
                                                    <td><?= $sl++ ?></td>
                                                    <td><?= date('d-m-Y', strtotime($user['created_at'])) ?></td>
                                                    <td><?= htmlspecialchars($user['name']) ?></td>
                                                    <td><?= htmlspecialchars($user['username']) ?></td>
                                                    <td><?= htmlspecialchars($decoded_password) ?></td>
                                                    <td>
                                                        <a href="adduser.php?action=Update&eid=<?= $user['id'] ?>">Edit</a> |
                                                        <a href="viewusers.php?delete_id=<?= $user['id'] ?>" onclick="return confirm('Are you sure to delete this user?');">Delete</a> |
                                                        <?php if ($user['status'] == 1): ?>
                                                            <a href="viewusers.php?toggle_status=0&id=<?= $user['id'] ?>">Deactivate</a>
                                                        <?php else: ?>
                                                            <a href="viewusers.php?toggle_status=1&id=<?= $user['id'] ?>">Activate</a>
                                                        <?php endif; ?>
                                                    </td>
                                                </tr>
                                            <?php endforeach; ?>
                                        </tbody>
                                    </table>
                                </div>

<nav>
                                    <ul class="pagination">
                                        <?php for ($i = 1; $i <= ceil($totalRows / $limit); $i++): ?>
                                            <li class="page-item <?= $i == $page ? 'active' : '' ?>">
                                                <a class="page-link" href="?<?= http_build_query(array_merge($_GET, ['page' => $i])) ?>"><?= $i ?></a>
                                            </li>
                                        <?php endfor; ?>
                                    </ul>
                                </nav>

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

</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: viewusers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation