����
������������������������������������
<?php
header('Access-Control-Allow-Origin: *');
header('Access-Control-Allow-Methods: GET, POST');
header("Access-Control-Allow-Headers: X-Requested-With");
header('Content-type: application/json');

function readCSVFromURL($url) {
    $csvData = [];

    if (($handle = fopen($url, 'r')) !== FALSE) {
        $header = fgetcsv($handle);

        // Remove BOM from the first header if present
        if (strpos($header[0], "\xEF\xBB\xBF") === 0) {
            $header[0] = substr($header[0], 3);
        }

        while (($row = fgetcsv($handle)) !== FALSE) {
            $csvData[] = array_combine($header, $row);
        }

        fclose($handle);
    }

    return $csvData;
}


// Check if the request method is POST
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Get the JSON data from the request body
    $json = file_get_contents('php://input');

    // Decode the JSON data
    $requestData = json_decode($json, true);

    // Check if the 'url' parameter exists
    if (isset($requestData['url'])) {
        // Get the CSV data from the provided URL
        $csvData = readCSVFromURL($requestData['url']);

        // Return the CSV data as JSON
        echo json_encode($csvData);
    } else {
        // If 'url' parameter is not provided, return an error message
        echo json_encode(['error' => 'URL parameter is missing']);
    }
} else {
    // If the request method is not POST, return an error message
    echo json_encode(['error' => 'Invalid request method']);
}
?>