<?php
require_once 'db.php';

if (isset($_POST['statistics_id'])) {

    // Extract data from the POST request
    $title = mysqli_real_escape_string($link, $_POST['title']);
    $counter = mysqli_real_escape_string($link, $_POST['counter']);
    $parameter = mysqli_real_escape_string($link, $_POST['parameter']);
    $statistics_id = $_POST['statistics_id'];

    // SQL query to insert data into the 'vehicles' table
    $sql = "UPDATE statistics SET
         title= '$title',
         counter = '$counter',
         parameter = '$parameter'
         WHERE 
         statistics_id = '$statistics_id' ";

    if (mysqli_query($link, $sql)) {
        $response = [
            'error_flag' => 0,
            'message' => 'Statistics Updated Successfully!',
            'statistics_id' => $statistics_id
        ];
        echo json_encode($response);
    } else {
        $response = [
            'error_flag' => 1,
            'message' => 'Failed to update statistics details.'
        ];
        echo json_encode($response);
    }
} else {
    $response = [
        'error_flag' => 1,
        'message' => 'Invalid request. Missing required parameters.'
    ];
    echo json_encode($response);
}