prepare("SELECT * FROM players WHERE id = ?");
$stmt->execute([$player_id]);
$player = $stmt->fetch();
if (!$player) {
header('Location: admin.php'); // Redirect if player not found
exit;
}
// Fetch all teams
$teams_stmt = $pdo->query("SELECT id, team_name FROM teams ORDER BY team_name");
$teams = $teams_stmt->fetchAll();
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$player_name = trim($_POST['player_name']);
$player_email = trim($_POST['player_email']);
$high_school_year = trim($_POST['high_school_year']);
$season_year = trim($_POST['season_year']);
$team_id = $_POST['team_id'] ?? null; // Get team_id from form
if (!empty($player_name) && !empty($player_email)) {
try {
// Update player details, including team_id
$stmt = $pdo->prepare("UPDATE players SET name = ?, email = ?, high_school_year = ?, season_year = ?, team_id = ? WHERE id = ?");
$stmt->execute([$player_name, $player_email, $high_school_year, $season_year, $team_id, $player_id]);
$_SESSION['success_message'] = 'Player updated successfully!';
} catch (PDOException $e) {
$_SESSION['error_message'] = 'Error updating player: ' . $e->getMessage();
}
}
header('Location: admin.php'); // Redirect back to admin page
exit;
}
?>
Edit Player