Code Examples -> IPTables Bandwidth statics

	Submit Your Code
	SEO Monitor
	UpTime Monitor
	PHP Code Contest
	My Favorite Examples
	My Favorite Articles
	Update Your Profile

More Weber Sites
	PHP Code Search
	Web Development Forums
	Learn MySQL Playing Trivia
	PHPBB2 Templates
	Web Development Index
	Web Development Resources
	Web Development Content

Recommended Links
	PHPClasses
	PHP Editor
	PHP Jobs
	Vision.To Design
	Ajax Tutorials
	PHP Programming Help
	PHP/MySQL Programming
	Webmaster Resources
	Webmaster Forum
	XML meta language
	website builder

Recommended
	Mobile Dev World


BACK		ADD A COMMENT		SEND TO A FRIEND		ADD TO MY FAVORITES		ADD CODE EXAMPLES		PRINT

PHP Code Examples

Title :	IPTables Bandwidth statics
Categories :	PHP, Security, Network	Digital Human
Date :	Mar 31st 2005
Grade :	3 of 5 (graded 3 times)
Viewed :	7788
File :	4123.zip
Images :	No Images for this code example.

Search :	More code by Digital Human
Action :	Grade This Code Example
Tools :	My Examples List

Code

Bandwidth Statics capture tool
Give Apache execude rights to IPTABLES with VISUDO.
apache ALL=(ALL) NOPASSWD: /sbin/iptables

MySQL Database Table

CREATE TABLE `bandwidth`
(
`uid` INTEGER (11) NOT NULL AUTO_INCREMENT ,
`packets` bigint (20),
`bytes` bigint (20),
`chain` varchar (50),
`date` datetime,
PRIMARY KEY (uid)
) TYPE=MyISAM

<?php
$x=1000;
?>

<html>
<script language=javascript>
var count = 0;
var running = true;

function doRewrite() {
if (running) {
count++;

setTimeout("doRewrite()", 1000);
location.reload();
}
}
</script>
<body onLoad="setTimeout('doRewrite()', <? echo $x; ?>)">
</html>

<?php

// MySQL Connection

$con = mysql_connect("localhost","root","va654422") or die("Kan niet connecten.");
$db = mysql_select_db("stats");

// -v -x -L INPUT

$output = exec("sudo iptables -v -x -L INPUT", $in);

echo $in[0];
$input = explode(' ', $in[0]);
echo "<pre>";
echo "Incomming: ".$input[4]." Packets.";
echo " Incomming: ".$input[6]." Bytes.";
echo "</pre>";

// -v -x -L OUTPUT

$output = exec("sudo iptables -v -x -L OUTPUT", $out);

echo $out[0];
$output = explode(' ', $out[0]);
echo "<pre>";
echo "Outgoing: ".$output[4]." Packets.";
echo " Outgoing: ".$output[6]." Bytes.";
echo "</pre>";

// -v -x -L FORWARD

$output = exec("sudo iptables -v -x -L FORWARD", $for);

echo $for[0];
$forward = explode(' ', $for[0]);
echo "<pre>";
echo "Forwarded: ".$forward[4]." Packets.";
echo " Forwarded: ".$forward[6]." Bytes.";
echo "</pre>";

//-t nat -xv -L PREROUTING

$output = exec("sudo iptables -t nat -xv -L PREROUTING", $pre);

echo $pre[0];
$prerouted = explode(' ', $pre[0]);
echo "<pre>";
echo "Prerouting: ".$prerouted[4]." Packets.";
echo " Prerouting: ".$prerouted[6]." Bytes.";
echo "</pre>";

//-t nat -xv -L POSTROUTING

$output = exec("sudo iptables -t nat -xv -L POSTROUTING", $post);

echo $post[0];
$postrouted = explode(' ', $post[0]);
echo "<pre>";
echo "Postrouting: ".$postrouted[4]." Packets.";
echo " Postrouting: ".$postrouted[6]." Bytes.";
echo "</pre>";

// 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 "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 " 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 " 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 " 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 " Totaal Postrouting: ".number_format($kb,2,",",".")." Mb. in ".$record->aantalDagen." dag(en).";
}

mysql_close($con);
?>

Related Code Examples

	A damaged image generator (class) for validating text. CAPTCHA - Completely Automated Public Turing test to tell Computers and Humans Apart Categories : PHP, PHP Classes, Security, GD image library, Security
	Password protection for Phorum 3.1.x with userlevels and log. Categories : PHP, MySQL, Authentication, Security
	IP Blocking Categories : PHP, Security, HTTP
	Session Validation Methods (Security Checks) Categories : PHP, Sessions, Security
	Secure Login Categories : PHP, MySQL, Cookies, Security
	How to get the exit code and result of an exec() command. Categories : PHP, Network
	Securing Web Forms with Simple PHP-CAPTCHA (Completely Automated Public Turing test to tell Computers and Humans Apart) Categories : PHP, Security, GD image library, Sessions
	Generate image with random number (CAPTCHA) Categories : PHP, GD image library, Graphics, Security
	Client classes for Dictionary servers UPDATED: 2000-06-06 Categories : Network, Search, Complete Programs, PHP Classes, PHP
	Anti SQL injection-PHP Categories : PHP, MySQL, Security
	Examines the user's computer for open Netbus (the trojan horse) port and reports the conclusion to the user. Categories : Network, PHP
	A PHP function to encrypt and decrypt a number or string or a combination of the two. Categories : PHP, Encryption, Security
	A Simple Script that stores encrypted messages in databases Categories : PHP, Databases, MySQL, Security
	Create MRTG Graphic from rrd database (Need MRTG and RRDTool installed). Categories : PHP, Network, Graphics
	Protect your email links from being spidered by spam email robots! Categories : PHP, Security, Mail, Email