connect_error) { die("Connection failed: " . $conn->connect_error); } $sid = $_GET['sid']; $sensor_type_select = isset($_REQUEST['sensor_type_select']) ? $_REQUEST['sensor_type_select'] : ''; $temp_type = "Fahrenheit"; $sql = "SELECT value FROM sensors_system WHERE name = 'server_temperature'"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { if ($row["value"] == "Celsius") { $temp_type = "°C"; } else { $temp_type = "°F"; } } } $temp_low = ""; $sql = "SELECT value FROM sensors_system WHERE name = 'server_lowtemp'"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { if ($row["value"] != "") { $temp_low = $row["value"]; } else { $temp_low = "-300"; } } } $temp_high = ""; $sql = "SELECT value FROM sensors_system WHERE name = 'server_hightemp'"; $result = $conn->query($sql); if ($result->num_rows > 0) { while($row = $result->fetch_assoc()) { if ($row["value"] != "") { $temp_high = $row["value"]; } else { $temp_high = "3000"; } } } $sql = "SELECT * FROM sensors_info WHERE sid = ".$sid.""; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo ""; echo ""; echo ''; if ($sensor_type_select == "Temperature") { echo ''; if($row["sensor_limit1"] != "") { echo ""; } else { echo ""; } if($row["sensor_limit2"] != "") { echo ""; } else { echo ""; } } else if ($sensor_type_select == "Humidity") { echo ""; echo ""; } else if ($sensor_type_select == "Temperature/Humidity") { if($row["sensor_limit1"] != "") { echo ""; } else { echo ""; } if($row["sensor_limit2"] != "") { echo ""; } else { echo ""; } echo ""; echo ""; } else if ($sensor_type_select == "Soil Sensor") { if($row["sensor_limit1"] != "") { echo ""; } else { echo ""; } if($row["sensor_limit2"] != "") { echo ""; } else { echo ""; } echo ""; echo ""; } else if ($sensor_type_select == "Emergency Button") { echo ""; echo ""; echo ""; } echo ""; echo ''; } } else { echo "Could not find the entry your requested.

"; } $conn->close(); ?>

SID	" . $row["sid"]. "
Sensor ID	" . $row["sensor_id"]. "
Type	"; echo ""; echo ""; if($row["sensor_type"] != "") { $sensor_type_select = $row["sensor_type"]; } echo "Temperature"; echo "Humidity"; echo "Temperature/Humidity"; echo "Soil Sensor"; echo "Emergency Button"; echo "
Name
Group	"; $sql2 = "SELECT * FROM sensors_groups"; $result2 = $conn->query($sql2); if ($result2->num_rows > 0) { echo ""; while($row2 = $result2->fetch_assoc()) { if ($row["sensor_group"] == $row2["gid"]) { echo "".$row2["group_name"].""; } else { echo "".$row2["group_name"].""; } } echo "
State	"; echo ""; if ($row["sensor_state"] == "on") { echo "On"; echo "Off"; } else { echo "Off"; echo "On"; } echo "
Geo-Tag
Calibration (+/-)
Low Temp Limit	".$temp_type."
Low Temp Limit	".$temp_type."
High Temp Limit	".$temp_type."
High Temp Limit	".$temp_type."
Low Humidity Limit	%
High Humidity Limit	%
Low Temp Limit	".$temp_type."
Low Temp Limit	".$temp_type."
High Temp Limit	".$temp_type."
High Temp Limit	".$temp_type."
Low Humidity Limit	%
High Humidity Limit	%
Low Temp Limit	".$temp_type."
Low Temp Limit	".$temp_type."
High Temp Limit	".$temp_type."
High Temp Limit	".$temp_type."
Humidity Limit	%
Soil Moister	%
How Often to Signal (minutes)
Normal Email Address
Texting Email Address
Comment