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/goldartsdpi.in/public_html/admin

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: manage_customers.php

<!doctype html>
<html lang="en">

<?php 
// Start session at the very beginning
session_start();

include('includes/head.php');
include('config.php');

// Check if user is logged in
if (!isset($_SESSION['admin_id'])) {
    header("Location: login.php");
    exit();
}

// Check if user has appropriate privileges
$admin_id = $_SESSION['admin_id'];
$role_check = mysqli_query($conn, "SELECT role FROM admin_users WHERE id = '$admin_id'");
if (!$role_check) {
    die("Database error: " . mysqli_error($conn));
}

$admin_data = mysqli_fetch_assoc($role_check);

// Allow both admin and super_admin to manage customers
if ($admin_data['role'] != 'super_admin' && $admin_data['role'] != 'admin') {
    header("Location: index.php");
    exit();
}

// Handle delete action
if (isset($_GET['delete_id'])) {
    $delete_id = mysqli_real_escape_string($conn, $_GET['delete_id']);
    
    $delete_sql = "DELETE FROM users WHERE id = '$delete_id'";
    if (mysqli_query($conn, $delete_sql)) {
        $_SESSION['success_msg'] = "Customer deleted successfully!";
    } else {
        $_SESSION['error_msg'] = "Error deleting customer: " . mysqli_error($conn);
    }
    
    header("Location: manage_customers.php");
    exit();
}

// Handle toggle active status if you add that field later
/*
if (isset($_GET['toggle_status'])) {
    $toggle_id = mysqli_real_escape_string($conn, $_GET['toggle_status']);
    
    $status_sql = "UPDATE users SET is_active = NOT is_active WHERE id = '$toggle_id'";
    if (mysqli_query($conn, $status_sql)) {
        $_SESSION['success_msg'] = "Customer status updated successfully!";
    } else {
        $_SESSION['error_msg'] = "Error updating customer status: " . mysqli_error($conn);
    }
    
    header("Location: manage_customers.php");
    exit();
}
*/
?>

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>

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

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-flex align-items-center justify-content-between">
                            <h4 class="mb-0">Manage Customers</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="javascript: void(0);">Customer Management</a></li>
                                    <li class="breadcrumb-item active">Manage Customers</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center mb-3">
                                    <h4 class="card-title">Customer Accounts</h4>
                                    <a href="add_customer.php" class="btn btn-primary">
                                        <i class="fas fa-plus"></i> Add New Customer
                                    </a>
                                </div>
                                <p class="card-title-desc">Manage all customer accounts for your system</p>

<?php
                                // Display success/error messages
                                if (isset($_SESSION['success_msg'])) {
                                    echo '<div class="alert alert-success">' . $_SESSION['success_msg'] . '</div>';
                                    unset($_SESSION['success_msg']);
                                }
                                
                                if (isset($_SESSION['error_msg'])) {
                                    echo '<div class="alert alert-danger">' . $_SESSION['error_msg'] . '</div>';
                                    unset($_SESSION['error_msg']);
                                }
                                ?>

<div class="table-responsive">
                                    <table id="customers-table" class="table table-striped table-bordered">
                                        <thead>
                                            <tr>
                                                <th>ID</th>
                                                <th>First Name</th>
                                                <th>Last Name</th>
                                                <th>Email</th>
                                                <th>Created At</th>
                                                <th>Updated At</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Fetch all customers
                                            $sql = "SELECT * FROM users ORDER BY created_at DESC";
                                            $result = mysqli_query($conn, $sql);
                                            
                                            if (mysqli_num_rows($result) > 0) {
                                                while ($row = mysqli_fetch_assoc($result)) {
                                                    echo "<tr>
                                                        <td>{$row['id']}</td>
                                                        <td>{$row['first_name']}</td>
                                                        <td>{$row['last_name']}</td>
                                                        <td>{$row['email']}</td>
                                                        <td>" . date('M j, Y g:i A', strtotime($row['created_at'])) . "</td>
                                                        <td>" . date('M j, Y g:i A', strtotime($row['updated_at'])) . "</td>
                                                        <td>
                                                            <div class='btn-group'>";
                                                    
                                                    // View button
                                                    echo "<a href='view_customer.php?id={$row['id']}' class='btn btn-sm btn-info'>
                                                            <i class='fas fa-eye'></i>
                                                          </a>";
                                                    
                                                    // Edit button
                                                    echo "<a href='edit_customer.php?id={$row['id']}' class='btn btn-sm btn-warning'>
                                                            <i class='fas fa-edit'></i>
                                                          </a>";
                                                    
                                                    // Delete button
                                                    echo "<a href='manage_customers.php?delete_id={$row['id']}' class='btn btn-sm btn-danger' onclick='return confirm(\"Are you sure you want to delete this customer?\");'>
                                                                <i class='fas fa-trash'></i>
                                                              </a>";
                                                    
                                                    echo "</div>
                                                        </td>
                                                    </tr>";
                                                }
                                            } else {
                                                echo "<tr><td colspan='7' class='text-center'>No customers found</td></tr>";
                                            }
                                            ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

</div>
            
        </div>

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

</div>

<?php include('includes/rightbar.php')?>

<?php include('includes/scripts.php')?>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage_customers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation