prepare($sql);
$stmt->execute([$_POST['neuer_spieler_name']]);
header("Location: " . $_SERVER['PHP_SELF']);
exit;
}
// --- LOGIK: SCORE HINZUFÜGEN ---
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['add_score'])) {
$sql = "INSERT INTO scores (spieler_id, spiel_id, zeit, hilfe, sterne) VALUES (?, ?, ?, ?, ?)";
$stmt = $pdo->prepare($sql);
$stmt->execute([
$_POST['spieler_id'],
$_POST['spiel_id'],
(int)$_POST['zeit'],
(int)$_POST['hilfe'],
(int)$_POST['sterne']
]);
header("Location: " . $_SERVER['PHP_SELF']);
exit;
}
// --- DATEN ABFRAGEN ---
$stmtGames = $pdo->query("SELECT * FROM spiele ORDER BY id DESC");
$exitGames = $stmtGames->fetchAll(PDO::FETCH_ASSOC);
$stmtAllPlayers = $pdo->query("SELECT * FROM spieler ORDER BY name ASC");
$playersList = $stmtAllPlayers->fetchAll();
$sqlScores = "SELECT s.*, p.name as spieler_name
FROM scores s
JOIN spieler p ON s.spieler_id = p.id
ORDER BY s.sterne DESC, s.zeit ASC";
$allScores = $pdo->query($sqlScores)->fetchAll();
?>
EXIT - Dashboard
 ?>)
|
' |
★ |
Noch keine Scores. | ";
?>
👤 Team/Spieler anlegen