d076708932
- Redesigned the main page with a modern look and feel. - Added search and filtering functionality for drills. - Implemented pagination for browsing drills. - Added the ability for users to mark drills as favorites.
45 lines
1.2 KiB
PHP
45 lines
1.2 KiB
PHP
<?php
|
|
require_once __DIR__ . '/partials/header.php';
|
|
|
|
// Require login
|
|
if (!is_logged_in()) {
|
|
header('Location: login.php');
|
|
exit();
|
|
}
|
|
|
|
$current_coach_id = get_user_id();
|
|
$drill_id = $_GET['id'] ?? null;
|
|
|
|
if (!$drill_id) {
|
|
header('Location: my_drills.php?error=No drill specified');
|
|
exit();
|
|
}
|
|
|
|
try {
|
|
$pdo = db();
|
|
|
|
// First, verify the drill belongs to the current user
|
|
$stmt = $pdo->prepare("SELECT coach_id FROM drills WHERE id = ?");
|
|
$stmt->execute([$drill_id]);
|
|
$drill = $stmt->fetch();
|
|
|
|
if ($drill && $drill['coach_id'] == $current_coach_id) {
|
|
// Delete the drill
|
|
$delete_stmt = $pdo->prepare("DELETE FROM drills WHERE id = ?");
|
|
$delete_stmt->execute([$drill_id]);
|
|
|
|
header('Location: my_drills.php?success=Drill deleted successfully');
|
|
exit();
|
|
} else {
|
|
// Either drill doesn't exist or user doesn't have permission
|
|
header('Location: my_drills.php?error=Drill not found or you do not have permission to delete it');
|
|
exit();
|
|
}
|
|
|
|
} catch (PDOException $e) {
|
|
error_log("Database error: " . $e->getMessage());
|
|
header('Location: my_drills.php?error=A database error occurred.');
|
|
exit();
|
|
}
|
|
?>
|