$arr = str_getcsv($row); if (empty($col_names)) { $col_names = $arr; } else { $line = array(); foreach ($arr as $i => $val) { $line[$col_names[$i]] = $val; } // Clean up data & fill in the blank if (!isset($line['distance_meters']) || empty($line['distance_meters'])) { $line['distance_meters'] = convertDistanceToMeters($line['distance']); } if (!isset($line['time_seconds']) || empty($line['time_seconds'])) { $line['time_seconds'] = convertTimeToSeconds($line['time']); } $line['date'] = cleanupDate($line['date']); $line['pace'] = formatPace($line['time_seconds'], $line['distance_meters']); $races_arr[] = $line; } } // var_dump($races_arr); // debug $json_file = explode(".", $csv_file)[0] . '.json'; if (!file_exists($json_file)) { $json_fh = fopen($json_file, 'w'); fwrite($json_fh, json_encode($races_arr)); echo count($races_arr) . " lines written to {$json_file}\n"; } else { throw new InvalidArgumentException("JSON output file already exists: {$json_file}."); } function cleanupDate($input) {
<?php $mbox = imap_open("{imap.zpush.org:143/notls/norsh}INBOX", "username", "password"); date_default_timezone_set("UTC"); $result = imap_fetch_overview($mbox, "1:*", 0); foreach ($result as $overview) { if (isset($overview->date)) { printf("%s\n", $overview->date); printf("%s\n", cleanupDate($overview->date)); } if (isset($overview->udate)) { printf("%s\n", $overview->udate); } } imap_close($mbox); function cleanupDate($receiveddate) { if (is_array($receiveddate)) { // Header Date could be repeated in the message, we only check the first $receiveddate = $receiveddate[0]; } printf("%s\n", preg_replace("/\\(.*\\)/", "", $receiveddate)); printf("%s\n", preg_replace('/\\(.*\\)/', "", $receiveddate)); printf("%s\n", preg_replace("/\\(.*\\)/", "", $receiveddate)); $receiveddate = strtotime(preg_replace("/\\(.*\\)/", "", $receiveddate)); if ($receiveddate == false || $receiveddate == -1) { printf("cleanupDate() : Received date is false. Message might be broken."); return null; } return $receiveddate; }