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/sp/admin

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: delete-customer.php

<?php
// Enable error reporting for debugging
ini_set('display_errors', 1);
error_reporting(E_ALL);

// Database connection
include 'includes/db.php';

// Check if customer ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    header("Location: manage-customers.php?error=Invalid customer ID");
    exit();
}

$customer_id = intval($_GET['id']);

// Fetch customer data to display name in confirmation
$sql = "SELECT customer_name FROM customers WHERE id = ?";
$stmt = mysqli_prepare($conn, $sql);
if (!$stmt) {
    error_log("Prepare failed for customer query: " . mysqli_error($conn));
    header("Location: manage-customers.php?error=Failed to prepare customer query: " . mysqli_error($conn));
    exit();
}
mysqli_stmt_bind_param($stmt, "i", $customer_id);
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

if (mysqli_num_rows($result) == 0) {
    header("Location: manage-customers.php?error=Customer not found");
    exit();
}

$customer = mysqli_fetch_assoc($result);
$customer_name = $customer['customer_name'];

// Handle form submission for deletion
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    if (isset($_POST['confirm_delete'])) {
        // Start transaction to ensure data consistency
        mysqli_begin_transaction($conn);

try {
            // Delete associated EMI schedule records
            $delete_emi_sql = "DELETE FROM emi_schedule WHERE customer_id = ?";
            $delete_emi_stmt = mysqli_prepare($conn, $delete_emi_sql);
            if (!$delete_emi_stmt) {
                throw new Exception("Failed to prepare EMI delete query: " . mysqli_error($conn));
            }
            mysqli_stmt_bind_param($delete_emi_stmt, "i", $customer_id);
            if (!mysqli_stmt_execute($delete_emi_stmt)) {
                throw new Exception("Error deleting EMI schedule: " . mysqli_error($conn));
            }
            mysqli_stmt_close($delete_emi_stmt);

// Delete customer (total_investment records will be deleted via CASCADE)
            $delete_customer_sql = "DELETE FROM customers WHERE id = ?";
            $delete_customer_stmt = mysqli_prepare($conn, $delete_customer_sql);
            if (!$delete_customer_stmt) {
                throw new Exception("Failed to prepare customer delete query: " . mysqli_error($conn));
            }
            mysqli_stmt_bind_param($delete_customer_stmt, "i", $customer_id);
            if (!mysqli_stmt_execute($delete_customer_stmt)) {
                throw new Exception("Error deleting customer: " . mysqli_error($conn));
            }
            mysqli_stmt_close($delete_customer_stmt);

// Commit transaction
            mysqli_commit($conn);
            mysqli_close($conn);
            header("Location: manage-customers.php?success=Customer and associated records deleted successfully");
            exit();
        } catch (Exception $e) {
            // Rollback transaction on error
            mysqli_rollback($conn);
            $error = $e->getMessage();
            error_log("Deletion error: " . $error);
        }
    } else {
        $error = "Deletion not confirmed.";
    }
}

mysqli_close($conn);
?>

<!DOCTYPE html>
<html lang="en" dir="ltr" data-startbar="dark" data-bs-theme="light">
<?php include 'includes/head.php'; ?>

<div class="startbar d-print-none">
        <div class="brand">
            <a href="index.php" class="logo">
                <span>
                    <img src="assets/images/logo-sm.png" alt="logo-small" class="logo-sm">
                </span>
                <span class="">
                    <img src="assets/images/logo-light.png" alt="logo-large" class="logo-lg logo-light">
                    <img src="assets/images/logo-dark.png" alt="logo-large" class="logo-lg logo-dark">
                </span>
            </a>
        </div>
        <?php include 'includes/leftbar.php'; ?>
        <div class="startbar-overlay d-print-none"></div>

<div class="page-wrapper">
            
            <div class="page-content">
                <div class="container-fluid">
                    
                    <?php
                    $page_title = "Delete Customer";
                    $breadcrumb_active = "Delete Customer";
                    ?>
                    <div class="row">
                        <div class="col-sm-12">
                            <div class="page-title-box d-md-flex justify-content-md-between align-items-center">
                                <h4 class="page-title"><?php echo $page_title; ?> (CUST-<?php echo $customer_id; ?>)</h4>
                                <div class="">
                                    <ol class="breadcrumb mb-0">
                                        <li class="breadcrumb-item"><a href="index.php">Dashboard</a></li>
                                        <li class="breadcrumb-item"><a href="manage-customers.php">Manage Customers</a></li>
                                        <li class="breadcrumb-item active"><?php echo $breadcrumb_active; ?></li>
                                    </ol>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="row">
                        <div class="col-lg-12">
                            <div class="card">
                                <div class="card-header">
                                    <h4 class="card-title">Confirm Delete Customer</h4>
                                </div>
                                <div class="card-body">
                                    <?php if (isset($error)) { ?>
                                        <div class="alert alert-danger"><?php echo htmlspecialchars($error); ?></div>
                                    <?php } ?>
                                    <form method="POST">
                                        <div class="mb-3">
                                            <p>Are you sure you want to delete the customer <strong><?php echo htmlspecialchars($customer_name); ?> (CUST-<?php echo $customer_id; ?>)</strong>? This action cannot be undone and will also delete all related EMI schedules and investment records.</p>
                                        </div>
                                        <div class="d-flex">
                                            <button type="submit" name="confirm_delete" class="btn btn-danger">Yes, Delete Customer</button>
                                            <a href="manage-customers.php" class="btn btn-light ms-2">Cancel</a>
                                        </div>
                                    </form>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<?php include 'includes/rightbar.php'; ?>
                <?php include 'includes/footer.php'; ?>
            </div>
            
        </div>

<?php include 'includes/scripts.php'; ?>
    </body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: delete-customer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation