// Totaal Input
$query = mysql_query("SELECT SUM(bytes) AS TotalInput, Count(date) AS aantalDagen FROM bandwidth WHERE chain='INPUT'");
while($record = mysql_fetch_object($query)){
$kb = $record->TotalInput / 1048576;
echo "<b>Totaal Binnenkomend: ".number_format($kb,2,",",".")." Mb. in ".$record->aantalDagen." dag(en).";
}
// Totaal Uitgaand
$query = mysql_query("SELECT SUM(bytes) AS TotalOutput, Count(date) AS aantalDagen FROM bandwidth WHERE chain='OUTPUT'");
while($record = mysql_fetch_object($query)){
$kb = $record->TotalOutput / 1048576;
echo "<br><b>Totaal Uitgaand: ".number_format($kb,2,",",".")." Mb. in ".$record->aantalDagen." dag(en).";
}
// Totaal Forwarded
$query = mysql_query("SELECT SUM(bytes) AS TotalForward, Count(date) AS aantalDagen FROM bandwidth WHERE chain='FORWARD'");
while($record = mysql_fetch_object($query)){
$kb = $record->TotalForward / 1048576;
echo "<br><b>Totaal Forward: ".number_format($kb,2,",",".")." Mb. in ".$record->aantalDagen." dag(en).";
}
// Totaal Prerouting
$query = mysql_query("SELECT SUM(bytes) AS TotalPrerouting, Count(date) AS aantalDagen FROM bandwidth WHERE chain='PREROUTING'");
while($record = mysql_fetch_object($query)){
$kb = $record->TotalPrerouting / 1048576;
echo "<br><b>Totaal Prerouting: ".number_format($kb,2,",",".")." Mb. in ".$record->aantalDagen." dag(en).";
}
// Totaal Postrouting
$query = mysql_query("SELECT SUM(bytes) AS TotalPostrouting, Count(date) AS aantalDagen FROM bandwidth WHERE chain='POSTROUTING'");
while($record = mysql_fetch_object($query)){
$kb = $record->TotalPostrouting / 1048576;
echo "<br><b>Totaal Postrouting: ".number_format($kb,2,",",".")." Mb. in ".$record->aantalDagen." dag(en).";
}