connect_errno) {
echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
}
$result=$mysqli->query($sqlquery);
return($result);
}
$oldi=0;
$qstring=$_SERVER['QUERY_STRING'];
parse_str($qstring, $gem);
if(strlen($_SERVER['HTTP_USER_AGENT']) >2) {
include("header.html");
$r=open_database("power", "select * from devices where SN='01100476'");
$gem = mysqli_fetch_assoc($r);
echo "
";
echo "Serial Number: " .$gem['SN']." |
";
echo "Line Voltage: " .($gem['V']/10)." |
";
for ($i=1; $i<41; $i++) {
$r=open_database("power", "select name,alias from circuits where alias='$i' or alias='".$i."A' or alias='".$i."B'");
if ($i % 2 != 0) {
echo "Breaker Position $i | ";
}
if (mysqli_num_rows($r) == 0) {
echo "$i | ";
} else {
while ($row = mysqli_fetch_assoc($r)) {
if ((strpos(($row["alias"]), "A") == TRUE) or (strpos(($row["alias"]), "B") == TRUE)) {
if ($oldi != $i) {
echo "";
if (($oldi != $i) and (strpos(($row["alias"]), "B") == TRUE)) {
echo "".$i."A | ".$i."B | ";
} else {
$r2=open_database("power", "select name,alias from circuits where alias='".$i."A' or alias='".$i."B'");
$a = mysqli_fetch_array($r2);
mysqli_data_seek($r2, 1);
$b = mysqli_fetch_array($r2);
echo "".$i."A | ".$i."B | ";
}
echo " | ";
$oldi=$i;
}
} else {
echo "".$row["alias"]." | ";
}
}
}
if ($i % 2 == 0) {
echo "Breaker Position $i |
";
}
}
$r=open_database("power", "select name,alias from circuits where alias is NULL");
echo "Available Monitoring Inputs |
";
while ($row = mysqli_fetch_assoc($r)) {
echo "".$row["name"]." |
";
}
echo "
";
include("footer.html");
} else {
$r=open_database("power", "select device_id from devices where SN='".$gem['SN']."'");
if ($r->num_rows > 0) {
$r=open_database("power", "update devices set V='" . $gem['V'] . "', c1 = '". $gem['c1'] . "', c2 = '". $gem['c2'] . "', c3 = '". $gem['c3'] . "', c4 = '". $gem['c4'] . "', c5 = '". $gem['c5'] . "', c6 = '". $gem['c6'] . "', c7 = '". $gem['c7'] . "', c8 = '". $gem['c8'] . "', c9 = '". $gem['c9'] . "', c10 = '". $gem['c10'] . "', c11 = '". $gem['c11'] . "', c12 = '". $gem['c12'] . "', c13 = '". $gem['c13'] . "', c14 = '". $gem['c14'] . "', c15 = '". $gem['c15'] . "', c16 = '". $gem['c16'] . "', c17 = '". $gem['c17'] . "', c18 = '". $gem['c18'] . "', c19 = '". $gem['c19'] . "', c20 = '". $gem['c20'] . "', c21 = '". $gem['c21'] . "', c22 = '". $gem['c22'] . "', c23 = '". $gem['c23'] . "', c24 = '". $gem['c24'] . "', c25 = '". $gem['c25'] . "', c26 = '". $gem['c26'] . "', c27 = '". $gem['c27'] . "', c28 = '". $gem['c28'] . "', c29 = '". $gem['c29'] . "', c30 = '". $gem['c30'] . "', c31 = '". $gem['c31'] . "', c32 = '". $gem['c32'] . "' where SN='".$gem['SN']."'");
} else {
$r=open_database("power", "insert devices set V='" . $gem['V'] . "', c1 = '". $gem['c1'] . "', c2 = '". $gem['c2'] . "', c3 = '". $gem['c3'] . "', c4 = '". $gem['c4'] . "', c5 = '". $gem['c5'] . "', c6 = '". $gem['c6'] . "', c7 = '". $gem['c7'] . "', c8 = '". $gem['c8'] . "', c9 = '". $gem['c9'] . "', c10 = '". $gem['c10'] . "', c11 = '". $gem['c11'] . "', c12 = '". $gem['c12'] . "', c13 = '". $gem['c13'] . "', c14 = '". $gem['c14'] . "', c15 = '". $gem['c15'] . "', c16 = '". $gem['c16'] . "', c17 = '". $gem['c17'] . "', c18 = '". $gem['c18'] . "', c19 = '". $gem['c19'] . "', c20 = '". $gem['c20'] . "', c21 = '". $gem['c21'] . "', c22 = '". $gem['c22'] . "', c23 = '". $gem['c23'] . "', c24 = '". $gem['c24'] . "', c25 = '". $gem['c25'] . "', c26 = '". $gem['c26'] . "', c27 = '". $gem['c27'] . "', c28 = '". $gem['c28'] . "', c29 = '". $gem['c29'] . "', c30 = '". $gem['c30'] . "', c31 = '". $gem['c31'] . "', c32 = '". $gem['c32'] . "', SN='".$gem['SN']."'");
}
}
?>