function parse_and_store_data($data) { //TESTFROM if (preg_match("/Testing\\sfrom\\s(.*)\\.\\.\\./", $data, $match)) { $testfrom = $match[1]; } //HOSTEDBY DISTANCE PING if (preg_match("/Hosted\\sby\\s(.*)\\)\\s\\W(.*)\\skm\\W\\W\\s(.*)\\sms/", $data, $match)) { $hostedby = $match[1] . ")"; $distance_km = $match[2]; $ping_ms = $match[3]; } //DOWNLOAD SPEED if (preg_match("/Download\\W\\s(.*)\\sMbit/", $data, $match)) { $download_mbitxs = $match[1]; } //UPLOAD SPEED if (preg_match("/Upload\\W\\s(.*)\\sMbit/", $data, $match)) { $upload_mbitxs = $match[1]; } if ($DEBUG) { print "testfrom: {$testfrom}"; print "\nhostedby: {$hostedby}"; print "\ndistance_km: {$distance_km}"; print "\nping_ms: {$ping_ms}"; print "\ndownload_mbitxs: {$download_mbitxs}"; print "\nupload_mbitxs: {$upload_mbitxs}"; print "\n"; } // STORE IN DB $dbconn = check_create_conn(); $QUERY = "INSERT INTO log(timestamp,hostedby,testfrom,distance,ping,downloadspeed,uploadspeed) " . "VALUES(NOW(),'{$hostedby}','{$testfrom}',{$distance_km},{$ping_ms},{$download_mbitxs},{$upload_mbitxs})"; $qresultDB_INSERT = mysqli_query($dbconn, $QUERY); }
// attach WHERE (from, to) if ($last != '') { $QUERY .= " LIMIT {$last}"; } $resultset = mysqli_query($dbconn, $QUERY); $data = "Time{$DELIMITER} Download_mbps{$DELIMITER} Upload_mbps\n"; while ($row = mysqli_fetch_assoc($resultset)) { $timestamp = str_replace("-", "/", $row['timestamp']); $downloadspeed = number_format($row['downloadspeed'], 2, '.', ''); $uploadspeed = number_format($row['uploadspeed'], 2, '.', ''); $data .= "{$timestamp}{$DELIMITER} {$downloadspeed}{$DELIMITER} {$uploadspeed}\n"; } header('Content-Type: text/csv; charset=utf-8'); echo $data; } elseif (strstr("." . $a, 'txt')) { $dbconn = check_create_conn(); $QUERY = "SELECT * FROM ISPEED.log ORDER BY timestamp DESC"; // attach WHERE (from, to) if ($last != '') { $QUERY .= " LIMIT {$last}"; } $i = 0; $resultset = mysqli_query($dbconn, $QUERY); //Only if exact txt if ($a == 'txt') { $data = "Sep='{$DELIMITER}'\n"; } $data .= " N{$DELIMITER} Timestamp{$DELIMITER} Download_mbps{$DELIMITER} Upload_mbps{$DELIMITER} Ping_ms{$DELIMITER} TestFrom{$DELIMITER} Hostedby{$DELIMITER} Distance_km\n"; while ($row = mysqli_fetch_assoc($resultset)) { $i++; $num = sprintf("%4d", $i);