Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 4.18.0-553.84.1.lve.el8.x86_64

PHP Version:

8.2.30

User:

u176134211

Directory:

/home/u176134211/domains/aqua-walrus-487298.hostingersite.com/public_html/admin

Free Space:

8.3 TB

🔧 Quick Actions

✏️ Editing: delete-batch.php

<?php
// File: /esarthi/admin/delete-batch.php (Admin Panel - Permanently Delete Batch)

session_start();
// --- 1. SECURITY CHECK ---
if (!isset($_SESSION['admin'])) {
    header("Location: login.php");
    exit();
}

require_once("../config/db.php");

$batch_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
$message = "";

if ($batch_id === 0) {
    $message = "❌ Error: Batch ID not specified for deletion.";
    header("Location: manage-batches.php?msg=" . urlencode($message));
    exit();
}

// --- 2. FETCH BATCH NAME FOR CONFIRMATION MESSAGE ---
$q_batch = $conn->query("
    SELECT b.batch_name, c.course_name 
    FROM batches b
    JOIN courses c ON b.course_id = c.course_id
    WHERE b.batch_id = $batch_id
");

if ($q_batch->num_rows === 0) {
    $message = "❌ Error: Batch ID #{$batch_id} not found.";
    header("Location: manage-batches.php?msg=" . urlencode($message));
    exit();
}
$batch_data = $q_batch->fetch_assoc();
$batch_name = $batch_data['batch_name'];
$course_name = $batch_data['course_name'];

// --- 3. ATTEMPT DELETION ---
$sql = "DELETE FROM batches WHERE batch_id = $batch_id";

if ($conn->query($sql) === TRUE) {
    $message = "🗑️ Success! Batch '<b>{$batch_name}</b>' from '{$course_name}' (ID: {$batch_id}) has been permanently deleted. Linked classes and materials were also deleted.";
} else {
    // Check for Foreign Key Constraint Violation (Error code 1451 is common for FK errors in MySQL/MariaDB)
    if ($conn->errno == 1451) {
        $message = "❌ **FATAL ERROR:** Cannot delete Batch '<b>{$batch_name}</b>'. It has active **Enrollments, Attendance, or Exam records**. You must manually delete or complete all associated student/record data first, or mark the batch as 'Completed'.";
    } else {
        $message = "❌ Error: Database deletion failed. " . $conn->error;
    }
}

// --- 4. REDIRECT ---
header("Location: manage-batches.php?msg=" . urlencode($message));
exit();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: delete-batch.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation