Location: PHPKode > projects > Network Traffic Monitor > online/firms.php
<?php

#Network Traffic Monitor is an application to monitor the network traffic on all SNMP managable devices.
#
#Copyright (c) 2004, Daimler Trust nv <hide@address.com> - Jan Van Hees <hide@address.com>
# 
#This file is part of Network Traffic Monitor.
#
#    Network Traffic Monitor is free software; you can redistribute it and/or modify
#    it under the terms of the GNU General Public License as published by
#    the Free Software Foundation; either version 2 of the License, or
#    (at your option) any later version.
#
#    Network Traffic Monitor is distributed in the hope that it will be useful,
#    but WITHOUT ANY WARRANTY; without even the implied warranty of
#    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
#    GNU General Public License for more details.
#
#    You should have received a copy of the GNU General Public License
#    along with Network Traffic Monitor; if not, write to the Free Software
#    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
/*
* This script provides a user interface 2 list all companies 
*/
require_once("../auth.php");
require_once ("../config.php");
require_once ("HTML/Template/IT.php");
require_once "HTML/Table.php";
if($_POST['port']){
	header("Location: error.php");
	exit;
}
$db = dbLogin();

$tpl = new HTML_Template_IT(TEMPLATEDIR);
$tpl->loadTemplatefile("basic.tpl");

$tpl->setVariable("title","Companies");

$sql = "SELECT cid,compname, address, btw FROM company ORDER BY compname";

$temp = $db->query($sql);
	$i = 0;
	while ($row = $temp->fetchrow()){
		$firm = "<a href=\"userlist.php?f=$row[0]&name=$row[1]\">$row[1]</a>";
		$act = "<a href=\"editfirm.php?f=$row[0]\">Edit</a> / <a href=\"delete.php?type=company&i=$row[0]\">Delete</a>";
		$arr = array($firm, $row[2], $row[3], $act);
		$data[$i]=$arr;
		$i++;
	}//while fetchrow

	//create table
	$tableAttrs = array("width" => "600");
	$table = new HTML_Table($tableAttrs);
	$table -> setAutoGrow(true);

	for($nr = 0 ; $nr < count($data); $nr++) {
		for($i = 0; $i < 5; $i++) {  
			if("" != $data[$nr][$i])
			$table -> setCellContents( $nr+1, $i+1, $data[$nr][$i]);
 		}//for
	}//for
	$altRow = array("bgcolor"=>"silver");	
	$table -> altRowAttributes(1, null, $altRow);
	$table -> setHeaderContents(0, 1, "Name");
	$table -> setHeaderContents(0, 2, "Address");
	$table -> setHeaderContents(0, 3, "BTW");
	$table -> setHeaderContents(0, 4, "Delete");
	$hrAttrs = array("bgcolor" => "silver");
	$table -> setRowAttributes(0, $hrAttrs, true);
	
	$tpl->setVariable("data",$table->toHTML());
	$tpl->setVariable("add", "<a href=\"addfirm.php\">Add Firm</a>");






$content = $tpl->get();
fillFrame($db, $content);
dblogout($db);

?>
Return current item: Network Traffic Monitor