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

Free Space:

10.28 TB

🔧 Quick Actions

✏️ Editing: delete_branch.php

<?php
session_start();
require_once 'config/db_config.php';

// Check if branch ID is provided via POST
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['branch_id'])) {
    $branch_id = $_POST['branch_id'];

try {
        // Start transaction
        $pdo->beginTransaction();

// Fetch branch image path before deletion
        $stmt = $pdo->prepare("SELECT image_url FROM branches WHERE branch_id = ?");
        $stmt->execute([$branch_id]);
        $branch = $stmt->fetch();

// Delete related records first (due to foreign key constraints)
        // Delete order items and orders
        $pdo->prepare("DELETE oi FROM order_items oi 
                       JOIN orders o ON oi.order_id = o.order_id 
                       WHERE o.branch_id = ?")->execute([$branch_id]);
        $pdo->prepare("DELETE FROM orders WHERE branch_id = ?")->execute([$branch_id]);
        
        // Delete foods and categories
        $pdo->prepare("DELETE FROM foods WHERE branch_id = ?")->execute([$branch_id]);
        $pdo->prepare("DELETE FROM food_categories WHERE branch_id = ?")->execute([$branch_id]);
        
        // Delete taxes
        $pdo->prepare("DELETE FROM taxes WHERE branch_id = ?")->execute([$branch_id]);
        
        // Delete users associated with this branch
        $pdo->prepare("DELETE FROM users WHERE branch_id = ?")->execute([$branch_id]);
        
        // Finally delete the branch
        $pdo->prepare("DELETE FROM branches WHERE branch_id = ?")->execute([$branch_id]);

// Delete branch image file if exists
        if ($branch && $branch['image_url'] && file_exists($branch['image_url'])) {
            unlink($branch['image_url']);
        }

$pdo->commit();
        
        $_SESSION['success'] = 'Branch deleted successfully!';
        
    } catch (PDOException $e) {
        $pdo->rollBack();
        $_SESSION['error'] = 'Error deleting branch: ' . $e->getMessage();
    }
} else {
    $_SESSION['error'] = 'Invalid request.';
}

header('Location: branches.php');
exit;

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: delete_branch.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation