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.23 TB

🔧 Quick Actions

✏️ Editing: delete-course.php

<?php
// File: /admin/delete-course.php
session_start();

// 1. Error Reporting (Temporary for debugging)
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

// 2. Database Connection
// Checking file path relative to /public_html/admin/
require_once("../config/db.php");

// 3. Security Check
if (!isset($_SESSION['admin'])) {
    header("Location: login.php");
    exit();
}

// 4. Validate ID
$course_id = isset($_GET['id']) ? (int)$_GET['id'] : 0;
$message = "";

if ($course_id === 0) {
    header("Location: manage-courses.php?msg=" . urlencode("❌ Error: Valid Course ID required."));
    exit();
}

try {
    // 5. Check if course exists and get name
    $stmt_fetch = $conn->prepare("SELECT course_name FROM courses WHERE course_id = ?");
    $stmt_fetch->bind_param("i", $course_id);
    $stmt_fetch->execute();
    $result = $stmt_fetch->get_result();

if ($result->num_rows === 0) {
        header("Location: manage-courses.php?msg=" . urlencode("❌ Error: Course not found."));
        exit();
    }
    
    $course_name = $result->fetch_assoc()['course_name'];
    $stmt_fetch->close();

// 6. Attempt Delete
    $stmt_del = $conn->prepare("DELETE FROM courses WHERE course_id = ?");
    $stmt_del->bind_param("i", $course_id);

if ($stmt_del->execute()) {
        $message = "🗑️ Success! Course '<b>{$course_name}</b>' has been deleted.";
    } else {
        // Handle Foreign Key Error (batches linked to course)
        if ($conn->errno == 1451) {
            $message = "❌ Error: Cannot delete '<b>{$course_name}</b>' because it is linked to active Batches.";
        } else {
            $message = "❌ Database Error: " . $conn->error;
        }
    }
    $stmt_del->close();

} catch (Exception $e) {
    $message = "❌ System Error: " . $e->getMessage();
}

// 7. Final Redirect
header("Location: manage-courses.php?msg=" . urlencode($message));
exit();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: delete-course.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation