284 lines
15 KiB
PHP
284 lines
15 KiB
PHP
<?php
|
|
$username="corey";
|
|
$password="41945549";
|
|
$database="controls";
|
|
|
|
mysql_connect('127.0.0.1',$username,$password);
|
|
@mysql_select_db($database) or die( "Unable to select database");
|
|
$query = "SELECT * FROM boilers ORDER BY id DESC LIMIT 1";
|
|
$result=mysql_query($query);
|
|
|
|
$num=mysql_numrows($result);
|
|
|
|
mysql_close();
|
|
?>
|
|
|
|
<?php
|
|
$i=0;
|
|
while ($i < $num) {
|
|
$f1=mysql_result($result,$i,"boiler1stmflo");
|
|
$f2=mysql_result($result,$i,"blr1fdtemp");
|
|
$f3=mysql_result($result,$i,"blr1flugas");
|
|
$f4=mysql_result($result,$i,"blr1idtemp");
|
|
$f5=mysql_result($result,$i,"boiler1drmlvl");
|
|
$f6=mysql_result($result,$i,"boiler1idfnspd");
|
|
$f7=mysql_result($result,$i,"boiler1drmpres");
|
|
$f8=mysql_result($result,$i,"boiler1fdwtrflo");
|
|
$f9=mysql_result($result,$i,"boiler2stmflo");
|
|
$f10=mysql_result($result,$i,"blr2fdtemp");
|
|
$f11=mysql_result($result,$i,"blr2fluemp");
|
|
$f12=mysql_result($result,$i,"blr2idtemp");
|
|
$f13=mysql_result($result,$i,"boiler2drmlvl");
|
|
$f14=mysql_result($result,$i,"boiler2idfnspd");
|
|
$f15=mysql_result($result,$i,"boiler2drmpres");
|
|
$f16=mysql_result($result,$i,"boiler2fdwtrflo");
|
|
$f17=mysql_result($result,$i,"boiler3stmflo");
|
|
$f18=mysql_result($result,$i,"blr3fdtemp");
|
|
$f19=mysql_result($result,$i,"blr3fluetemp");
|
|
$f20=mysql_result($result,$i,"blr3idtemp");
|
|
$f21=mysql_result($result,$i,"boiler3drmlvl");
|
|
$f22=mysql_result($result,$i,"boiler3idfnspd");
|
|
$f23=mysql_result($result,$i,"boiler3drmpres");
|
|
$f24=mysql_result($result,$i,"boiler3fdwtrflo");
|
|
$f25=mysql_result($result,$i,"boilr3draft");
|
|
$f26=mysql_result($result,$i,"boiler4stmflo");
|
|
$f27=mysql_result($result,$i,"blr4fdtemp");
|
|
$f28=mysql_result($result,$i,"blr4flugas");
|
|
$f29=mysql_result($result,$i,"blr4idtemp");
|
|
$f30=mysql_result($result,$i,"boiler4drmlvl");
|
|
$f31=mysql_result($result,$i,"boiler4idfnspd");
|
|
$f32=mysql_result($result,$i,"boiler4drmpres");
|
|
$f33=mysql_result($result,$i,"boilr4draft");
|
|
$f34=mysql_result($result,$i,"boiler5stmflo");
|
|
$f35=mysql_result($result,$i,"blr5fdtemp");
|
|
$f36=mysql_result($result,$i,"blr5flugas");
|
|
$f37=mysql_result($result,$i,"blr5idtemp");
|
|
$f38=mysql_result($result,$i,"boiler5drmlvl");
|
|
$f39=mysql_result($result,$i,"boiler5idfnspd");
|
|
$f40=mysql_result($result,$i,"boiler5drmpres");
|
|
$f41=mysql_result($result,$i,"boiler5fdwtrflo");
|
|
$f42=mysql_result($result,$i,"boilr5draft");
|
|
$f43=mysql_result($result,$i,"boiler6stmflo");
|
|
$f44=mysql_result($result,$i,"blr6fdtemp");
|
|
$f45=mysql_result($result,$i,"blr6flugas");
|
|
$f46=mysql_result($result,$i,"blr6idtemp");
|
|
$f47=mysql_result($result,$i,"boiler6drmlvl");
|
|
$f48=mysql_result($result,$i,"boiler6idfnspd");
|
|
$f49=mysql_result($result,$i,"boiler6drmpres");
|
|
$f50=mysql_result($result,$i,"boiler6fdwtrflo");
|
|
$f51=mysql_result($result,$i,"ttlstmflo");
|
|
$f52=mysql_result($result,$i,"livestmpres");
|
|
$f53=mysql_result($result,$i,"exstflow1");
|
|
$f54=mysql_result($result,$i,"exstflow2");
|
|
$f55=mysql_result($result,$i,"gate1");
|
|
$f56=mysql_result($result,$i,"gate2");
|
|
$f57=mysql_result($result,$i,"gate3");
|
|
$f58=mysql_result($result,$i,"exhaustpr");
|
|
$f59=mysql_result($result,$i,"boiler4fdwtrflo");
|
|
$f60=mysql_result($result,$i,"blr2superheat");
|
|
$f61=mysql_result($result,$i,"blr6superheat");
|
|
$f62=mysql_result($result,$i,"blr6superheat");
|
|
$f63=mysql_result($result,$i,"exstflow3");
|
|
$f64=mysql_result($result,$i,"ttlstmflo2");
|
|
$f77=mysql_result($result,$i,"pan8hdrpress");
|
|
$f105=mysql_result($result,$i,"ttlstmflo");
|
|
$f106=mysql_result($result,$i,"boiler7lvl");
|
|
$f107=mysql_result($result,$i,"boiler7drumpress");
|
|
$f108=mysql_result($result,$i,"boiler7feedwater");
|
|
$f109=mysql_result($result,$i,"boiler7steamflow");
|
|
|
|
$f120=mysql_result($result,$i,"boiler8drumlvla");
|
|
$f121=mysql_result($result,$i,"boiler8drumlvlb");
|
|
$f122=mysql_result($result,$i,"boiler8drumlvlc");
|
|
$f123=mysql_result($result,$i,"boiler8lvl");
|
|
$f124=mysql_result($result,$i,"boiler8drumpress");
|
|
$f125=mysql_result($result,$i,"boiler8feedwater");
|
|
$f126=mysql_result($result,$i,"boiler8feedwaterpres");
|
|
$f127=mysql_result($result,$i,"boiler8steamflow");
|
|
$f128=mysql_result($result,$i,"boiler8livesteam");
|
|
$f129=mysql_result($result,$i,"boiler8idfanspd");
|
|
?>
|
|
|
|
<!-- vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv BOILERS vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv -->
|
|
<table class="tftable24k">
|
|
<tr>
|
|
<td width="1000%" align="center" colspan="6" border="0"><font color="#00BFFF"><i>BOILERS 1-6</i></font></td>
|
|
</tr>
|
|
</table>
|
|
<!-- ****************************************** ROW START ******************************************** -->
|
|
|
|
<table class="tftable14k">
|
|
<tr>
|
|
<td bgcolor="#2E2E2E" colspan="2"><font color="#e0e0e0">Total Steam Flow:</font></td>
|
|
<td bgcolor="#2E2E2E" align="right" width="75"><font color="00FF00"><b><?php echo round(($f105+$f109+$f127),0); ?></b></font></td>
|
|
<td bgcolor="#2E2E2E"><font color="#e0e0e0">Kpph</font></td>
|
|
|
|
<td colspan="2"><font color="#e0e0e0">Vapor Pressure:</font></td>
|
|
<td align="right" width="75" id="lsp"><font color="00FF00"><b><?php echo $f77; ?></b></font></td>
|
|
<td><font color="#e0e0e0">PSI</font></td>
|
|
|
|
<td bgcolor="#2E2E2E" ><font color="#e0e0e0">Exhaust Pressure:</font></td>
|
|
<?php
|
|
if ($f97 == 0)
|
|
echo "<td align=\"center\" bgcolor=\"#0B3B17\"><font color=\"#e0e0e0\">A</font></td>";
|
|
if ($f97 == 1)
|
|
echo "<td align=\"center\" bgcolor=\"#8A0808\"><font color=\"#e0e0e0\">M</font></td>";
|
|
?>
|
|
<?php
|
|
$color = "#e0e0e0";
|
|
|
|
if (($f58 >= 0) && ($f58 <= 5))
|
|
$color = "#FF0000";
|
|
else if (($f58 >= 6) && ($f58 <= 13))
|
|
$color = "#FFFF00";
|
|
else if ($f58 >= 14)
|
|
$color = "#00FF00";
|
|
|
|
echo "<td align=\"right\" bgcolor=\"#2E2E2E\"><font color=\"$color\"><b> $f58 </b></font></td>";
|
|
?>
|
|
<td bgcolor="#2E2E2E" ><font color="#e0e0e0">PSI</font></td>
|
|
|
|
<td colspan="2"><font color="#e0e0e0">Live Steam Pressure:</font></td>
|
|
<?php
|
|
$color = "#e0e0e0";
|
|
|
|
if (($f52 >= 0) && ($f52 <= 155))
|
|
$color = "#FF0000";
|
|
else if (($f52 >= 156) && ($f52 <= 165))
|
|
$color = "#FFFF00";
|
|
else if ($f52 >= 165)
|
|
$color = "#00FF00";
|
|
|
|
echo "<td align=\"right\" width=\"75\"><font color=\"$color\"><b> $f52 </b></font></td>";
|
|
?>
|
|
<td><font color="#e0e0e0">PSI</font></td>
|
|
</tr>
|
|
|
|
<!-- ****************************************** ROW END ******************************************** -->
|
|
|
|
</table>
|
|
|
|
<!-- ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ START OF BOILERS ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ -->
|
|
<table class="tftable54k" border="1">
|
|
<tr>
|
|
<td colspan="4" bgcolor="#e06b04" align="center" width="16.6%"><font color="#000000">Boiler 1</font></td>
|
|
<td colspan="4" bgcolor="#b36537" align="center" width="16.6%"><font color="#000000">Boiler 2</font></td>
|
|
<td colspan="4" bgcolor="#e06b04" align="center" width="16.6%"><font color="#000000">Boiler 3</font></td>
|
|
<td colspan="4" bgcolor="#b36537" align="center" width="16.6%"><font color="#000000">Boiler 4</font></td>
|
|
<td colspan="4" bgcolor="#e06b04" align="center" width="16.6%"><font color="#000000">Boiler 5</font></td>
|
|
<td colspan="4" bgcolor="#b36537" align="center" width="16.6%"><font color="#000000">Boiler 6</font></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="left"><font color="#e0e0e0">Steam Flow</font></td>
|
|
<td align="left" width="100"><progress id="progressboilers" max="110" value="<?php echo $f1; ?>"></progress></td>
|
|
<td align="right" width="80"><font color="#e60000"><?php echo $f1; ?></font></td>
|
|
<td align="left" width="65"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left"><font color="#e0e0e0">Steam Flow</font></td>
|
|
<td align="left" width="100"><progress id="progressboilers" max="105" value="<?php echo $f9; ?>"></progress></td>
|
|
<td align="right" width="80"><font color="#e60000"><?php echo $f9; ?></font></td>
|
|
<td align="left" width="65"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left"><font color="#e0e0e0">Steam Flow</font></td>
|
|
<td align="left" width="100"><progress id="progressboilers" max="100" value="<?php echo $f17; ?>"></progress></td>
|
|
<td align="right" width="80"><font color="#e60000"><?php echo $f17; ?></font></td>
|
|
<td align="left" width="65"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left"><font color="#e0e0e0">Steam Flow</font></td>
|
|
<td align="left" width="100"><progress id="progressboilers" max="60" value="<?php echo $f26; ?>"></progress></td>
|
|
<td align="right" width="80"><font color="#e60000"><?php echo $f26; ?></font></td>
|
|
<td align="left" width="65"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left"><font color="#e0e0e0">Steam Flow</font></td>
|
|
<td align="left" width="100"><progress id="progressboilers" max="55" value="<?php echo $f34; ?>"></progress></td>
|
|
<td align="right" width="80"><font color="#e60000"><?php echo $f34; ?></font></td>
|
|
<td align="left" width="65"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left"><font color="#e0e0e0">Steam Flow</font></td>
|
|
<td align="left" width="100"><progress id="progressboilers" max="90" value="<?php echo $f43; ?>"></progress></td>
|
|
<td align="right" width="80"><font color="#e60000"><?php echo $f43; ?></font></td>
|
|
<td align="left" width="65"><font color="#e0e0e0">kpph</font></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Level</font></td>
|
|
<td align="right" width="50"><font color="#12bd5a"><?php echo $f5; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">%</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Level</font></td>
|
|
<td align="right" width="50"><font color="#12bd5a"><?php echo $f13; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">%</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Level</font></td>
|
|
<td align="right" width="50"><font color="#12bd5a"><?php echo $f21; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">%</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Level</font></td>
|
|
<td align="right" width="50"><font color="#12bd5a"><?php echo $f30; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">%</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Level</font></td>
|
|
<td align="right" width="50"><font color="#12bd5a"><?php echo $f38; ?><font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">%</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Level</font></td>
|
|
<td align="right" width="50"><font color="#12bd5a"><?php echo $f47; ?><font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">%</font></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Feed Water</font></td>
|
|
<td align="right" width="50"><font color="#129dbd"><?php echo $f8; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Feed Water</font></td>
|
|
<td align="right" width="50"><font color="#129dbd"><?php echo $f16; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Feed Water</font></td>
|
|
<td align="right" width="50"><font color="#129dbd"><?php echo $f24; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Feed Water</font></td>
|
|
<td align="right" width="50"><font color="#129dbd"><?php echo $f59; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Feed Water</font></td>
|
|
<td align="right" width="50"><font color="#129dbd"><?php echo $f41; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">kpph</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Feed Water</font></td>
|
|
<td align="right" width="50"><font color="#129dbd"><?php echo $f50; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">kpph</font></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Pressure</font></td>
|
|
<td align="right" width="50"><font color="#e2c211"><?php echo $f7; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">psi</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Pressure</font></td>
|
|
<td align="right" width="50"><font color="#e2c211"><?php echo $f15; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">psi</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Pressure</font></td>
|
|
<td align="right" width="50"><font color="#e2c211"><?php echo $f23; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">psi</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Pressure</font></td>
|
|
<td align="right" width="50"><font color="#e2c211"><?php echo $f32; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">psi</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Pressure</font></td>
|
|
<td align="right" width="50"><font color="#e2c211"><?php echo $f40; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">psi</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">Drum Pressure</font></td>
|
|
<td align="right" width="50"><font color="#e2c211"><?php echo $f49; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">psi</font></td>
|
|
</tr>
|
|
<tr>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">ID Fan Speed</font></td>
|
|
<td align="right" width="50"><font color="#0c7300"><?php echo $f6; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">rpm</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">ID Fan Speed</font></td>
|
|
<td align="right" width="50"><font color="#0c7300"><?php echo $f14; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">rpm</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">ID Fan Speed</font></td>
|
|
<td align="right" width="50"><font color="#0c7300"><?php echo $f22; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">rpm</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">ID Fan Speed</font></td>
|
|
<td align="right" width="50"><font color="#0c7300"><?php echo $f31; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">rpm</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">ID Fan Speed</font></td>
|
|
<td align="right" width="50"><font color="#0c7300"><?php echo $f39; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">rpm</font></td>
|
|
<td align="left" colspan="2"><font color="#e0e0e0">ID Fan Speed</font></td>
|
|
<td align="right" width="50"><font color="#0c7300"><?php echo $f48; ?></font></td>
|
|
<td align="left" width="50"><font color="#e0e0e0">rpm</font></td>
|
|
</tr>
|
|
</table>
|
|
|
|
<!-- ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ END OF BOILERS ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ -->
|
|
<!-- ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ END OF PAGE ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ -->
|
|
<?php
|
|
$i++;
|
|
}
|
|
?>
|