Untitled



html

<?php
$random = rand();
session_start();
include("dbconn.php");
if (isset($_GET['site'])) {
    if ($_GET['site'] == "nolabel") {
    $_SESSION['site'] = null;
    unset($_SESSION['site']);
  } else {
    $_SESSION['site'] = $_GET['site'];
  }
}
if (isset($_POST['rows'])) {
    $_SESSION['rows'] = $_POST['rows'];
    $rows = $_POST['rows'];
} else {
    if (isset($_SESSION['rows'])) {
        $rows = $_SESSION['rows'];
    }   else {
        $rows = 7;
    }
}
if (isset($_SESSION['site'])) {
            $sql = "SELECT COUNT(*) AS total FROM datbs";
    $result = $db->query($sql) or die ("SQL error: " . $error);
    foreach ($result as $row) $total_datbs = $row['total'];
    $sql = "SELECT COUNT(*) AS total FROM datbs WHERE SUBSTR(name,1,4) = '" . $_SESSION['site'] . "'";
    $result = $db->query($sql) or die ("SQL error: " . $error);
    foreach ($result as $row) $site_datbs = $row['total'];

    $sql = "SELECT * FROM datbs WHERE SUBSTR(name,1,4) = '" . $_SESSION['site'] . "' ORDER BY name";
    if ($rows != "all") {
        $sql .= " LIMIT " . $rowstart . "," . $rows . "";
    }
} else {
  $sql = "SELECT * FROM datbs WHERE SUBSTR(name,1,2) = 'HP' ORDER BY name";
}
$result = $db->query($sql) or die ("SQL error2: " . $error);
foreach ($result as $row) {
   //calculate uptime to show status up or down
    $uptime = strtotime(date("Y-m-d H:i:s")) - strtotime($row['timestamp']);
    $rdphost = substr($row['rdp'],0,-5);
  if ($rdphost != "") {
        $cmd = "nslookup $rdphost | find \"Name\"";
    $getrdpname = exec($cmd);
        $rdpname = substr($getrdpname,5);
        $rdpname = substr($rdpname,0,strpos($rdpname,"."));
    } else {
    $rdpname = "not set";
  }
    if (trim($rdpname) == "") $rdpname = $rdphost; //could not find DNS name

  //$html .= "<dr>\n";

  $html .= "<td colspan='8'></td><dr>\n";

  if ($uptime < 300) {

      $html .= "<td align='center' colspan='8' bgcolor='Green'>" . $row['name'] . "<br>" . $row['ip'] . "<br>" ."</td>\n";

    }
    else {
              $html .= "<td align='center' colspan='8' bgcolor='Red'>" . $row['name'] . "<br>" . $row['ip'] . "<br>" ."</td>\n";

  }
}

$sql = "SELECT SUBSTR(name,1,4) as site FROM datbs GROUP BY name";
$result = $db->query($sql) or die ("SQL error: " . $error);

foreach ($result as $row) {
    $site = $row['site'];

  if ($site <> $lastsite) {

      if ($site == $_SESSION['site']) {
        $siteselect .= "<option selected>" . $site . "</option>\n";
      } else {
        $siteselect .= "<option>" . $site . "</option>\n";
      }

    $lastsite = $site;
  }
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<html>
<head>
    <title>Server Mon</title>
  <META HTTP-EQUIV="Pragma" CONTENT="no-cache">
    <META HTTP-EQUIV="Expires" CONTENT="-1">
  <META NAME="code_monkey" CONTENT="Tim Beacham">
    <link rel="stylesheet" href="style.css" type="text/css" />

 </head>
<body>

<div id="navcontainer">
<table border="1" width="100%" border="1" cellpadding="1" cellspacing="1">
  <tr>
<td colspan="8">
       <li>
            <?php echo $html; ?>
            </li>
       </td>

  </tr>
</div>
</body>
</html>

CSS

#navcontainer ul
{
margin: 0;
padding: 0;
list-style-type: disc;
columns: 7;
-webkit-columns: 7;
-moz-columns: 7;
list-style-position: inline;
}
#navcontainer li
{
float: left;
width: 100%;
}
#navcontainer ul li a
{
text-decoration: none;
padding: 5px;
}