<?php
require_once 'db.php';

$response = [];

if (isset($_POST['StatisticsID'])) {
    $StatisticsID = mysqli_real_escape_string($link, $_POST['StatisticsID']);

    $sql = "SELECT * FROM statistics WHERE statistics_id='$StatisticsID'";
    $result = mysqli_query($link, $sql);

    if ($result) {
        $userData = [];
        while ($data = mysqli_fetch_assoc($result)) {
            $userData[] = $data;
        }

        $response = [
            'error_flag' => 0,
            'message' => 'Statistics Data fetched successfully!',
            'data' => $userData
        ];
    } else {
        $response = [
            'error_flag' => 1,
            'message' => 'Error executing query: ' . mysqli_error($link)
        ];
    }
} else {
    $response = [
        'error_flag' => 1,
        'message' => 'Invalid request. Missing required parameters.'
    ];
}

echo json_encode($response);