105 lines
4.6 KiB
PHP
105 lines
4.6 KiB
PHP
|
|
<?php
|
|
error_reporting(E_ERROR);
|
|
$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 milling ORDER BY id DESC LIMIT 1)";
|
|
$result=mysql_query($query);
|
|
|
|
$num=mysql_numrows($result);
|
|
|
|
mysql_close();
|
|
?>
|
|
|
|
<?php
|
|
$i=0;
|
|
while ($i < $num) {
|
|
|
|
$f21=mysql_result($result,$i,"mill1lvl");
|
|
$f22=mysql_result($result,$i,"mill2lvl");
|
|
$f23=mysql_result($result,$i,"mill3lvl");
|
|
$f24=mysql_result($result,$i,"mill4lvl");
|
|
$f25=mysql_result($result,$i,"mill5lvl");
|
|
$f26=mysql_result($result,$i,"mill6lvl");
|
|
$f38=mysql_result($result,$i,"mill1spd");
|
|
$f33=mysql_result($result,$i,"mill2spd");
|
|
$f34=mysql_result($result,$i,"mill3spd");
|
|
$f35=mysql_result($result,$i,"mill4spd");
|
|
$f36=mysql_result($result,$i,"mill5spd");
|
|
$f37=mysql_result($result,$i,"mill6spd");
|
|
$f110=mysql_result($result,$i,"dmbeltrunning");
|
|
$f111=mysql_result($result,$i,"tdbeltscale");
|
|
$f112=mysql_result($result,$i,"tdbeltscaleonoff");
|
|
$f113=mysql_result($result,$i,"syrupoverflow");
|
|
$f114=mysql_result($result,$i,"molbreclvl");
|
|
$f115=mysql_result($result,$i,"syruprcvrlvl");
|
|
$f116=mysql_result($result,$i,"amollvl");
|
|
$f117=mysql_result($result,$i,"amoloverflow");
|
|
$f118=mysql_result($result,$i,"bmoloverflow");
|
|
?>
|
|
|
|
|
|
<table class="tftable1">
|
|
<tr>
|
|
<td width="50%" align="center" colspan="5" border="0"><font color="#00BFFF"><i>EAST MILL TANDEM</i></font></td>
|
|
<td width="50%" align="center" colspan="6" border="0"><font color="#00BFFF"><i>WEST MILL TANDEM</i></font></td>
|
|
</tr>
|
|
</table>
|
|
<table class="tftableTEST">
|
|
<tr>
|
|
<td colspan="2" bgcolor="#0B3B17" align="center"><font color="#e0e0e0">Mill 1 LVL</font></td>
|
|
<td bgcolor="#0B3B17" align="left"><font color="#00FF00"><?php echo $f21; ?>%</font></td>
|
|
<td width="200" bgcolor="#0B3B17" align="left"><progress max="100" value="<?php echo $f21; ?>"></progress></td>
|
|
<td colspan="2" bgcolor="#0B3B17" align="center"><font color="#e0e0e0">RPM</font></td>
|
|
<td bgcolor="#0B3B17" align="left"><font color="#00FF00"><?php echo $f38; ?></font></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="2" bgcolor="#D7DF01" align="center"><font color="#000000">Mill 2 LVL</font></td>
|
|
<td bgcolor="#D7DF01" align="left"><font color="#000000"><?php echo $f22; ?>%</font></td>
|
|
<td width="200" bgcolor="#D7DF01" align="left"><progress max="100" value="<?php echo $f22; ?>"></progress></td>
|
|
<td colspan="2" bgcolor="#D7DF01" align="center"><font color="#000000">RPM</font></td>
|
|
<td bgcolor="#D7DF01" align="left"><font color="#000000"><?php echo $f33; ?></font></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="2" bgcolor="#04B404" align="center"><font color="#e0e0e0">Mill 3 LVL</font></td>
|
|
<td bgcolor="#04B404" align="left"><font color="#00FF00"><?php echo $f23; ?>%</font></td>
|
|
<td width="200" bgcolor="#04B404" align="left"><progress max="100" value="<?php echo $f23; ?>"></progress></td>
|
|
<td colspan="2" bgcolor="#04B404" align="center"><font color="#e0e0e0">RPM</font></td>
|
|
<td bgcolor="#04B404" align="left"><font color="#00FF00"><?php echo $f34; ?></font></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="2" bgcolor="#DF7401" align="center"><font color="#e0e0e0">Mill 4 LVL</font></td>
|
|
<td bgcolor="#DF7401" align="left"><font color="#00FF00"><?php echo $f24; ?>%</font></td>
|
|
<td width="200" bgcolor="#DF7401" align="left"><progress max="100" value="<?php echo $f24; ?>"></progress></td>
|
|
<td colspan="2" bgcolor="#DF7401" align="center"><font color="#e0e0e0">RPM</font></td>
|
|
<td bgcolor="#DF7401" align="left"><font color="#00FF00"><?php echo $f35; ?></font></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="2" bgcolor="#5858FA" align="center"><font color="#e0e0e0">Mill 5 LVL</font></td>
|
|
<td bgcolor="#5858FA" align="left"><font color="#00FF00"><?php echo $f25; ?>%</font></td>
|
|
<td width="200" bgcolor="#5858FA" align="left"><progress max="100" value="<?php echo $f25; ?>"></progress></td>
|
|
<td colspan="2" bgcolor="#5858FA" align="center"><font color="#e0e0e0">RPM</font></td>
|
|
<td bgcolor="#5858FA" align="left"><font color="#00FF00"><?php echo $f36; ?></font></td>
|
|
</tr>
|
|
<tr>
|
|
<td colspan="2" bgcolor="#8A0808" align="center"><font color="#e0e0e0">Mill 6 LVL</font></td>
|
|
<td bgcolor="#8A0808" align="left"><font color="#00FF00"><?php echo $f26; ?>%</font></td>
|
|
<td width="200" bgcolor="#8A0808" align="left"><progress max="100" value="<?php echo $f26; ?>"></progress></td>
|
|
<td colspan="2" bgcolor="#8A0808" align="center"><font color="#e0e0e0">RPM</font></td>
|
|
<td bgcolor="#8A0808" align="left"><font color="#00FF00"><?php echo $f37; ?></font></td>
|
|
|
|
</tr>
|
|
<tr>
|
|
|
|
</tr>
|
|
</table>
|
|
|
|
|
|
<?php
|
|
$i++;
|
|
}
|
|
?>
|