Location: PHPKode > projects > Network Asset Management Archive > nama/iaso/this4.php
<?php
$now = date("m/j/y h:i:s",time());
include "../connect.php";
$now = date("j/m/y h:i:s",time());
if ($SERIAL=="") {
$stmt6 = "select a.hostid from hosts a, arp_table b where (b.IP_ADDRESS = '$REMOTE_ADDR') and (a.IPADDRESSSTR=b.IP_ADDRESS)";
} else
{
$stmt6 = "select a.hostid from hosts a, arp_table b where (b.serial = '$SERIAL') and (a.IPADDRESSSTR=b.IP_ADDRESS)";
}
$sth6=ibase_query($dbh,$stmt6);
$row6=ibase_fetch_object($sth6);
$hostid=$row6->HOSTID;
ibase_free_result($sth6);
print "</table>";
if (strlen($hostid)!=0) {
print '<TABLE BORDER = "1">';
$stmt5 = "select distinct a.shortdesc, a.servicetype, a.ports  from services a, servicesfound b where (b.hostid=$hostid) and (a.serviceid=b.serviceid) order by a.PORTS;";
$sth5 = ibase_query($dbh,$stmt5);
while ($row5 = ibase_fetch_object($sth5)) {
    print "<TR><td>";
    print $row5->SHORTDESC . "</td><td>" . $row5->PORTS . "</td><td>" . $row5->SERVICETYPE . "</td></tr>";
}
print "</table>";
}
//$stmt6 = "select distinct * from banners where hostid=$hostid;";
//$sth6 = ibase_query($dbh,$stmt6);
//while ($row6 = ibase_fetch_object($sth6)) {
//}

//print '<input type="submit" name="Submit" value="Submit">';
//print "</form>";

?>

Return current item: Network Asset Management Archive