$db->insertTraceroute($id, $value);
}
// Read the data we just inserted and return it to the client
$result = $db->getTraceroute($id);
$out['data'] = $result;
echo json_encode($out);
});
/**
* Get-request to /api/info/basic gets the basic stats for all the executed
* and saved traceroutes so far.
*
* @return {json} Returns the basic info-data in a json-object.
*/
$app->get('/api/info/basic', function () {
$db = new Database();
$timesResults = $db->getAverageHopTime();
$time = round(($timesResults[0]['AVG1'] + $timesResults[0]['AVG2'] + $timesResults[0]['AVG3']) / 3, 3);
$out = array();
$out['numTraces'] = $db->getNumberOfTraces()[0]['COUNT(*)'];
$out['numHops'] = $db->getNumberOfHops()[0]['COUNT(*)'];
$out['hopTime'] = $time;
$out['averageHopsPerRoute'] = $db->getAverageHopsPerRoute()[0]['averageHopCount'];
echo json_encode($out);
});
/**
* Get-request to /api/info/topTraces gets the topTen traced urls for all the executed
* and saved traceroutes so far.
*
* @return {json} Returns the topTraces info-data in a json-object.
*/
$app->get('/api/info/topTraces', function () {
