Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-570.21.1.el9_6.x86_64

PHP Version:

8.2.28

User:

u612101220

Directory:

/home/u612101220/domains/esgpos.shop/public_html/tabulation/admin

Free Space:

9.72 TB

🔧 Quick Actions

✏️ Editing: manageUser.php

<?php
include("header.php");
include("topnav.php");

if (isset($_POST['add_employee'])) {

$fname = $_POST['fname'];
    $position = $_POST['position'];
    $contact_num = $_POST['contact_num'];
    $username = $_POST['username'];
    $password = $_POST['password'];
    $barangay_id = $_POST['barangay_id'];

$sql = "INSERT INTO `users`(`fullname`, `contact_num`, `username`, `password`, `usertype`, `barangay_id`) VALUES
   ('$fname','$contact_num','$username','$password','$position','$barangay_id')";
    $result = mysqli_query($conn, $sql);

$_SESSION['status'] = "Data Successfully Added!";
    $_SESSION['code'] = "success";
}

if (isset($_POST['id'])) {
    $user_id = $_POST['id'];

$sql = "DELETE FROM users where user_id = $user_id ";
    $res = $conn->query($sql);

if ($res == TRUE) {
        $_SESSION['status'] = "Data Successfully Deleted";
        $_SESSION['code'] = "info";
    }
}

if (isset($_POST['update_user'])) {

$user_id = $_POST['user_id'];
    $fullname = $_POST['fullname'];
    $position = $_POST['position'];
    $contact_num = $_POST['contact'];
    $username = $_POST['username'];
    $password = $_POST['password'];

$sql = "UPDATE `users` SET `fullname`='$fullname',`contact_num`='$contact_num',
    `username`='$username',`password`='$password]',`usertype`='$position' WHERE user_id= '$user_id'";
    $result = mysqli_query($conn, $sql);

$_SESSION['status'] = "Data Successfully Update!";
    $_SESSION['code'] = "success";
}
?>

<nav class="mt-2">
    <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false">
        
        <li class="nav-item">
            <a href="index.php" class="nav-link ">
                <i class="nav-icon fas fa-tachometer-alt"></i>
                <p>
                    Dashboard
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageUser.php" class="nav-link active">
                <i class="fa-solid fa-people-line nav-icon"></i>
                <p>
                    Manage User
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageCandidate.php" class="nav-link">
                <i class="fa-solid fa-building-columns nav-icon"></i>
                <p>
                    Manage Candidate
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="manageBarangay.php" class="nav-link">
                <i class="fa-solid fa-building-columns nav-icon"></i>
                <p>
                    Manage Barangay
                    
                </p>
            </a>
        </li>

<li class="nav-item">
            <a href="managePrecinct.php" class="nav-link">
                <i class="fa-solid fa-archway nav-icon"></i>
                <p>
                    Manage Precinct
                    
                </p>
            </a>
        </li>

</ul>
</nav>

</div>

</aside>

<div class="content-wrapper">
    
    <div class="content-header">
        <div class="container-fluid">
            <div class="row mb-2">
                <div class="col-sm-6">
                    
                </div>
                <div class="col-sm-6">
                    <ol class="breadcrumb float-sm-right">

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

<div class="content">
        <div class="container-fluid">

<div class="card">
                <div class="card-header">
                    <h3 class="card-title font-weight-bold mt-1">USERS</h3>

</div>

<div class="card-body">
                    <table id="example2" class="table table-bordered table-striped">
                        <thead class="text-white bg-dark">
                            <tr>
                                <th>Full Name</th>
                                <th>Position</th>
                                <th>Contact Number</th>
                                <th>Username</th>
                                <th>Barangay</th>
                                <th>Precinct</th>
                                <th class="col-2 text-center">Action</th>
                            </tr>
                        </thead>

<tbody>
                            <?php
                            $sql = "select * from users, barangay where users.barangay_id = barangay.barangay_id and users.usertype='Tabulator'";
                            $res = $conn->query($sql);
                            while ($row = $res->fetch_assoc()) {
                            ?>
                                <tr>
                                    <td><?php echo $row['fullname'] ?></td>
                                    <td><?php echo $row['usertype'] ?></td>
                                    <td><?php echo $row['contact_num'] ?></td>
                                    <td><?php echo $row['username'] ?></td>
                                    <td><?php echo $row['barangay_name'] ?></td>
                                    <td><a href="viewPrecint.php?id=<?php echo $row['user_id']; ?>"><button class="btn btn-info btn-sm"><i class="fa-solid fa-eye"></i> View</button></a></td>

<td class="text-center">
                                        <a href="#" class="btn btn-sm btn-warning edit-btn" data-id="<?php echo $row['user_id']; ?>"
                                            data-fullname="<?php echo $row['fullname']; ?>"
                                            data-position="<?php echo $row['usertype']; ?>"
                                            data-contact="<?php echo $row['contact_num']; ?>"
                                            data-username="<?php echo $row['username']; ?>"
                                            data-password="<?php echo $row['password']; ?>"><i class="fas fa-edit"></i> Edit</a>

<a class="btn btn-sm btn-danger delete" data-id="<?php echo $row['user_id']; ?>" onclick="confirmDelete(this);">
                                            <i class="fas fa-trash"></i> Delete</a>&nbsp;
                                    </td>
                                </tr>
                            <?php } ?>
                        </tbody>

</table>

</div>
                
            </div>

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

<aside class="control-sidebar control-sidebar-dark">
    
    <div class="p-3">
        <h5>Title</h5>
        <p>Sidebar content</p>
    </div>
</aside>

<div class="modal fade" id="exampleModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog" role="document">
        <div class="modal-content">
            <div class="modal-header bg-dark text-white">
                <h5 class="modal-title" id="exampleModalLabel">Add User</h5>

<button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <form action="" method="post">
                    <label Class="text-secondary">Fullname:</label>
                    <input type="text" class="form-control mb-2" name="fname" placeholder="Enter Fullname" required>

<label Class="text-secondary">Position:</label>
                    <select name="position" class="form-control mb-2" id="">
                        <option value="">---Select Position -----</option>
                        <option value="Tabulator">Tabulator</option>
                    </select>
                    <label Class="text-secondary">Barangay:</label>
                    <select name="barangay_id" class="form-control mb-2" id="">
                        <option value="">---Select Barangay -----</option>
                        <?php
                        $sql2 = "select * from barangay";
                        $res2 = $conn->query($sql2);
                        while ($row2 = $res2->fetch_assoc()) {
                        ?>
                            <option value="<?php echo $row2['barangay_id'] ?>"><?php echo $row2['barangay_name'] ?></option>
                        <?php } ?>
                    </select>
                    <label Class="text-secondary">Contact Number:</label>
                    <input type="number" class="form-control mb-2" name="contact_num" placeholder="Contact Number" required>

<label Class="text-secondary">Username:</label>
                    <input type="text" class="form-control mb-2" name="username" placeholder="Username" required>

<label Class="text-secondary">Password:</label>
                    <input type="password" class="form-control mb-2" name="password" placeholder="Password" required>

</div>
            <div class="modal-footer">
                <button type="button" class="btn btn-danger" data-dismiss="modal">Close</button>
                <button type="submit" name="add_employee" class="btn btn-primary pl-4 pr-4">Add</button>
            </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="deleteModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
    <div class="modal-dialog modal-dialog-centered" role="document">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title text-dark font-weight-bold" id="exampleModalLabel">DELETE CONFIRMATION</h5>
                <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <div class="modal-body">
                <form method="POST" id="form-delete">

<h6>Are sure you want to Delete this Data?</h6>

</div>
            <div class="modal-footer">
                <button class="btn btn-danger" type="button" data-dismiss="modal">Cancel</button>
                <button type="submit" form="form-delete" class="btn btn-primary">Yes. Delete It!</button>
            </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="updateModal" tabindex="-1" aria-labelledby="updateModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header bg-dark">
                <h5 class="modal-title" id="updateModalLabel">Update User</h5>
                <button class="close" type="button" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">×</span>
                </button>
            </div>
            <div class="modal-body">
                
                <form id="updateForm" method="POST">
                    <input type="hidden" id="user_id" name="user_id">
                    <div class="mb-3">
                        <label for="fullname" class="form-label">Full Name</label>
                        <input type="text" class="form-control" id="fullname" name="fullname" required>
                    </div>
                    <div class="mb-3">
                        <label for="position" class="form-label">Position</label>
                        <input type="text" class="form-control" id="position" name="position" required readonly>
                    </div>
                    <div class="mb-3">
                        <label for="contact" class="form-label">Contact Number</label>
                        <input type="text" class="form-control" id="contact" name="contact" required>
                    </div>
                    <div class="mb-3">
                        <label for="username" class="form-label">Username</label>
                        <input type="text" class="form-control" id="username" name="username" required>
                    </div>
                    <div class="mb-3">
                        <label for="password" class="form-label">Password</label>
                        <input type="password" class="form-control" id="password" name="password" required>
                    </div>
                    <button type="submit" name="update_user" class="btn btn-primary">Save Changes</button>
                </form>
            </div>
        </div>
    </div>
</div>

<?php
include("footer.php");
include("alert.php");
?>

document.getElementById("form-delete").id.value = id;
        $("#deleteModal").modal("show");
    }
</script>

// Populate the form fields with the user data
            $("#user_id").val(userId);
            $("#fullname").val(fullname);
            $("#position").val(position);
            $("#contact").val(contact);
            $("#username").val(username);
            $("#password").val(password);
            $("#precinct").val(precinct);

// Open the modal
            $("#updateModal").modal('show');
        });
    });
</script>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manageUser.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation