prepare('SELECT user_id FROM tasks WHERE id = :task_id'); $stmt->bindParam(':task_id', $taskId, PDO::PARAM_INT); $stmt->execute(); $task = $stmt->fetch(PDO::FETCH_ASSOC); if (!$task || $task['user_id'] != $userId) { header("Location: manage-tasks.php?error=unauthorized"); exit(); } // Delete applications for the task $stmt = $pdo->prepare('DELETE FROM applications WHERE task_id = :task_id'); $stmt->bindParam(':task_id', $taskId, PDO::PARAM_INT); $stmt->execute(); // Delete the task $stmt = $pdo->prepare('DELETE FROM tasks WHERE id = :task_id'); $stmt->bindParam(':task_id', $taskId, PDO::PARAM_INT); $stmt->execute(); header("Location: manage-tasks.php?success=task_deleted"); exit(); } catch (PDOException $e) { // Log the error and redirect error_log("Delete task failed: " . $e->getMessage()); header("Location: manage-tasks.php?error=db_error"); exit(); }