function toJson($line, $rowNumber) { static $header = array(); $csvLine = toCsv($line); $parsed = str_getcsv($csvLine, ',', '"', '"'); if ($rowNumber == 1) { $header = $parsed; return; } return json_encode(array_combine($header, $parsed)) . "\n"; }
<?php function toCsv() { //Date Format $date = date("M-d-Y, \\a\\t g.i a", time()); //URI API Endpoint //$uri="https://data.cityofchicago.org/resource/t2qc-9pjd.json"; $uri = $_POST['input_uri']; //Time interval //$interval= $_POST['set_timer']; //Named File $file_name = $_POST['file_name']; //Get File JSON $json = file_get_contents($uri); $filecsv = fopen("dataset/csv/dataset-" . $file_name . "-" . $date . ".csv", "w") or die("Unable to open file!"); $array = json_decode($json, true); $firstLineKeys = false; foreach ($array as $line) { if (empty($firstLineKeys)) { $firstLineKeys = array_keys($line); fputcsv($filecsv, $firstLineKeys); $firstLineKeys = array_flip($firstLineKeys); } fputcsv($filecsv, array_merge($firstLineKeys, $line)); } } toCsv(); header('location:index.html');