1#@!#!123s

��JFIF�� 1#@!#!123s
: / www / wwwroot / nagalandsuperleague.co.in / admin /
Filename : get_formation_details.php
back
<?php
// get_formation_details.php
include 'db_connect.php';
header("Content-Type: application/json");

$match_id  = isset($_GET['match_id']) ? intval($_GET['match_id']) : 1;
$team_name = isset($_GET['team_name']) ? $_GET['team_name'] : '';

try {
    // Find the formation record for the match and team.
    $sql = "SELECT * FROM formations WHERE match_id = ? AND team_name = ?";
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("is", $match_id, $team_name);
    $stmt->execute();
    $result = $stmt->get_result();
    $formation = $result->fetch_assoc();

    if ($formation) {
        $formation_id    = $formation['id'];
        $formation_style = $formation['formation_style'];

        // Retrieve player positions for this formation.
        $sql = "SELECT * FROM player_positions WHERE formation_id = ?";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("i", $formation_id);
        $stmt->execute();
        $positions = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);

        echo json_encode([
            "formation_style" => $formation_style,
            "positions"       => $positions
        ]);
    } else {
        echo json_encode([
            "formation_style" => "",
            "positions"       => []
        ]);
    }
    $stmt->close();
} catch (Exception $e) {
    http_response_code(500);
    echo json_encode(["error" => "Server error: " . $e->getMessage()]);
}

$conn->close();
?>