Root Explorer PHP

Editing: delete_company.php

<?php
include('includes/config.php');
session_start();

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // CSRF validation
    if (!isset($_POST['csrf_token']) || $_POST['csrf_token'] !== $_SESSION['csrf_token']) {
        $_SESSION['response'] = ['type' => 'danger', 'message' => 'Invalid CSRF token.'];
        header("Location: companies.php");
        exit;
    }

// Validate and sanitize company ID
    if (!isset($_POST['id']) || !ctype_digit($_POST['id'])) {
        $_SESSION['response'] = ['type' => 'danger', 'message' => 'Invalid company ID.'];
        header("Location: companies.php");
        exit;
    }

$company_id = intval($_POST['id']);
    $file_deletion_errors = [];

// Check database connection
    if (!$conn) {
        $_SESSION['response'] = ['type' => 'danger', 'message' => 'Database connection failed.'];
        header("Location: companies.php");
        exit;
    }

// Begin transaction
    $conn->begin_transaction();

try {
        // Check if company has related products
        $check_products = $conn->prepare("SELECT COUNT(*) as product_count FROM products WHERE company_id = ?");
        $check_products->bind_param("i", $company_id);
        $check_products->execute();
        $result = $check_products->get_result();
        $row = $result->fetch_assoc();
        $check_products->close();
        
        if ($row['product_count'] > 0) {
            throw new Exception("Cannot delete company because it has " . $row['product_count'] . " related product(s). Please delete or reassign the products first.");
        }

// Delete the company
        $stmt = $conn->prepare("DELETE FROM companies WHERE id = ?");
        $stmt->bind_param("i", $company_id);
        $stmt->execute();

if ($stmt->affected_rows === 0) {
            throw new Exception("No company found with ID: $company_id");
        }
        $stmt->close();

// Commit transaction if all DB operations succeeded
        $conn->commit();

// File deletion operations (outside transaction since filesystem can't be rolled back)
        // 1. Delete company images folder
        $uploadDir = rtrim(base_app, '/') . '/uploads/company_' . $company_id;
        if (is_dir($uploadDir)) {
            $files = glob($uploadDir . '/*');
            foreach ($files as $file) {
                if (is_file($file)) {
                    if (!unlink($file)) {
                        $file_deletion_errors[] = "Failed to delete company image: " . basename($file);
                    }
                }
            }
            if (!rmdir($uploadDir)) {
                $file_deletion_errors[] = "Failed to delete company directory";
            }
        }

// Set success message - only show warning if there were actual file deletion errors
        if (empty($file_deletion_errors)) {
            $_SESSION['response'] = ['type' => 'success', 'message' => 'Company and all related data successfully deleted.'];
        } else {
            $message = 'Company deleted from database but some files could not be removed.';
            if (!empty($file_deletion_errors)) {
                $message .= ' Errors: ' . implode(', ', array_unique($file_deletion_errors));
            }
            $_SESSION['response'] = ['type' => 'warning', 'message' => $message];
        }

} catch (Exception $e) {
        $conn->rollback();
        $_SESSION['response'] = ['type' => 'danger', 'message' => 'Deletion failed: ' . $e->getMessage()];
        error_log("Company deletion error: " . $e->getMessage());
    }

header("Location: companies.php");
    exit;

} else {
    // If not POST request
    $_SESSION['response'] = ['type' => 'danger', 'message' => 'Invalid request method.'];
    header("Location: companies.php");
    exit;
}

[ CANCEL ]

Name	Type	Actions
.. (Parent Directory)
📄 add_property.php	FILE	[EDIT]
📄 dashboard.php	FILE	[EDIT]
📄 delete_company.php	FILE	[EDIT]
📄 edit_property.php	FILE	[EDIT]
📁 img/	DIR
📁 includes/	DIR
📄 index.php	FILE	[EDIT]
📄 logout.php	FILE	[EDIT]
📄 properties.php	FILE	[EDIT]
📄 toggle_company_status.php	FILE	[EDIT]
📁 uploads/	DIR
📄 view_company.php	FILE	[EDIT]

[ Root System Explorer ]

Editing: delete_company.php