1#@!#!123s

��JFIF�� 1#@!#!123s
: / www / wwwroot / nagalandsuperleague.co.in / admin /
Filename : league_actions.php
back
<?php
session_start();
if (!isset($_SESSION["admin"])) {
    exit("Unauthorized access");
}

$pdo = new PDO("mysql:host=localhost;dbname=nagalandsuperleague", "nagalandsuperleague", "nagalandsuperleague", [
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION
]);

// Handle POST Requests (Insert / Update)
if ($_SERVER["REQUEST_METHOD"] === "POST") {
    $action = $_POST["action"];

    // 🏆 Add New Team to Standings
    if ($action === "add_team") {
        $stmt = $pdo->prepare("INSERT INTO league_standings (team_name, logo, gp, w, d, l, f, a, gd, p) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
        $stmt->execute([
            $_POST["team_name"], $_POST["logo"], $_POST["gp"], $_POST["w"], 
            $_POST["d"], $_POST["l"], $_POST["f"], $_POST["a"], $_POST["gd"], $_POST["p"]
        ]);
        header("Location: manage_league_standing.php");
        exit();
    }

    // ⚽ Add New Match
    elseif ($action === "add_match") {
        $stmt = $pdo->prepare("INSERT INTO league_matches (match_date, home_team, away_team) VALUES (?, ?, ?)");
        $stmt->execute([$_POST["match_date"], $_POST["home_team"], $_POST["away_team"]]);
        header("Location: manage_matches.php");
        exit();
    }

    // 🥇 Add New Player Ranking
    elseif ($action === "add_player") {
        $stmt = $pdo->prepare("INSERT INTO league_player_rankings (player_name, country_flag, goals) VALUES (?, ?, ?)");
        $stmt->execute([$_POST["player_name"], $_POST["country_flag"], $_POST["goals"]]);
        header("Location: manage_player_rankings.php");
        exit();
    }

    // ✏️ Update Team in Standings
    elseif ($action === "update_team") {
        $stmt = $pdo->prepare("UPDATE league_standings SET team_name = ?, logo = ?, gp = ?, w = ?, d = ?, l = ?, f = ?, a = ?, gd = ?, p = ? WHERE id = ?");
        $stmt->execute([
            $_POST["team_name"], $_POST["logo"], $_POST["gp"], $_POST["w"], 
            $_POST["d"], $_POST["l"], $_POST["f"], $_POST["a"], $_POST["gd"], $_POST["p"], $_POST["id"]
        ]);
        header("Location: manage_league_standing.php");
        exit();
    }

    // ✏️ Update Match
    elseif ($action === "update_match") {
        $stmt = $pdo->prepare("UPDATE league_matches SET match_date = ?, home_team = ?, away_team = ? WHERE id = ?");
        $stmt->execute([$_POST["match_date"], $_POST["home_team"], $_POST["away_team"], $_POST["id"]]);
        header("Location: manage_matches.php");
        exit();
    }

    // ✏️ Update Player Ranking
    elseif ($action === "update_player") {
        $stmt = $pdo->prepare("UPDATE league_player_rankings SET player_name = ?, country_flag = ?, goals = ? WHERE id = ?");
        $stmt->execute([$_POST["player_name"], $_POST["country_flag"], $_POST["goals"], $_POST["id"]]);
        header("Location: manage_player_rankings.php");
        exit();
    }
}

// Handle GET Requests (Delete)
if ($_GET["action"] === "delete_team" && isset($_GET["id"])) {
    $stmt = $pdo->prepare("DELETE FROM league_standings WHERE id = ?");
    $stmt->execute([$_GET["id"]]);
    header("Location: manage_league_standing.php");
    exit();
}

if ($_GET["action"] === "delete_match" && isset($_GET["id"])) {
    $stmt = $pdo->prepare("DELETE FROM league_matches WHERE id = ?");
    $stmt->execute([$_GET["id"]]);
    header("Location: manage_matches.php");
    exit();
}

if ($_GET["action"] === "delete_player" && isset($_GET["id"])) {
    $stmt = $pdo->prepare("DELETE FROM league_player_rankings WHERE id = ?");
    $stmt->execute([$_GET["id"]]);
    header("Location: manage_player_rankings.php");
    exit();
}
?>