1
Download Networked Occupancy Sensor System
Transcript
Networked Occupancy Sensor System
echo "Room " . $row['RmNumber'];
echo "<br><br/>" . $row['RmName'];
}
mysql_close();
?>
<br><br> </font></center>
</div>
<div data-role="content">
<ul data-role="listview">
<center><table><tr><td><br><br><font size=4>
Temperature: <br><br>
Occupied: <br><br>
Lights: <br><br></td><td width=20></td><td><br><br><br><br><big>
<?php
$connection = mysql_connect ('mysql.wpi.edu','noss','gSYc2J') or die
(mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db('noss');
$strSQL = "SELECT * FROM Data WHERE RoomID = '03 ' ";
//
<------- RoomID
$rs = mysql_query($strSQL);
while($row = mysql_fetch_array($rs)) {
echo $row['Temperature'] . " °F<br><br />";
$x = $row['OccupancyStatus'];
$y = $row['LightStatus'];
if ($x == 1) {
echo "Yes <br><br></p>";
}
else{
echo "No <br><br></p>";
}
if ($y == 1) {
echo "On </p>";
}
else{
echo "Off </p>";
}
}
mysql_close();
?>
</big></font><br><br><br></td></tr></table></center>
<li><a href="#page6"><big>Back</big></a></li>
<li><a href="#page"><big>Main Page</big></a></li>
</ul>
</div>
<div data-role="footer">
<!-- <h4>Footer</h4> -->
<br><br><center><font size=5> Networked Occupancy <br><br> Sensor
System</font></center><br><br>
</div>
</div>
<!--Building 2 Page (page3)-->
<div data-role="page" id="page3">
<div data-role="header">
<center><font size=6><br>Building 2 <br><br> </font></center>
</div>
<div data-role="content">
<ul data-role="listview">
<li><a href="#"><big>1st Floor</big></a></li>
<li><a href="#"><big>2nd Floor</big></a></li><br><br><br><br><br><br><br><br>
<li><a href="#page"><big>Back</big></a></li>
<li><a href="#page"><big>Main Page</big></a></li>
</ul>
</div>
<div data-role="footer">
<!-- <h4>Footer</h4> -->
[68]
