query($tableCheckQuery)->num_rows > 0; if (!$tableExists) { $error = "Domain table does not exist."; } else { // Get project name field for this domain $projectNameField = getProjectNameField($conn, $domainTable); // Get the project details $projectQuery = "SELECT `$projectNameField` FROM $domainTable WHERE Project_ID = ? LIMIT 1"; $stmt = $conn->prepare($projectQuery); if ($stmt) { $stmt->bind_param('i', $projectId); $stmt->execute(); $result = $stmt->get_result(); if ($result && $result->num_rows > 0) { $project = $result->fetch_assoc(); $projectName = $project[$projectNameField]; // If confirmed, delete the project if ($confirm) { $deleteQuery = "DELETE FROM $domainTable WHERE Project_ID = ?"; $deleteStmt = $conn->prepare($deleteQuery); if ($deleteStmt) { $deleteStmt->bind_param('i', $projectId); if ($deleteStmt->execute()) { // Redirect to project management page with success message header("Location: project_manage.php?deleted=1&project=" . urlencode($projectName)); exit; } else { $error = "Error deleting project: " . $deleteStmt->error; } $deleteStmt->close(); } else { $error = "Error preparing delete query: " . $conn->error; } } } else { $error = "Project not found."; } $stmt->close(); } else { $error = "Error preparing query: " . $conn->error; } } } // Include header include 'includes/header.php'; ?>

Delete Project

Back to Project Management
Confirm Deletion

Warning: You are about to delete the following project:

Domain:

Project ID:

This action cannot be undone. Are you sure you want to delete this project?

Cancel Yes, Delete Project
close(); ?>