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);
