Back To Admin Page | Refresh This Page

connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "SELECT * FROM sensors_info"; $result = $conn->query($sql); if ($result->num_rows > 0) { // output data of each row while($row = $result->fetch_assoc()) { $sensor_id = $row["sensor_id"]; $sensor_dir = "/sys/bus/w1/devices/".$row["sensor_id"].""; if(file_exists($sensor_dir)){ $status = ""; } else { $soil_sensor = exec('/opt/tempberrypi/bin/sn-util-rpi get '.$row["sensor_bus"].' '.$row["sensor_id"].' | grep '.$row["sensor_id"].''); if ($soil_sensor) { $status = ""; } else { $soil_sensor1 = exec('/opt/tempberrypi/bin/sn-util-rpi get 1 '.$row["sensor_id"].' | grep '.$row["sensor_id"].''); $soil_sensor2 = exec('/opt/tempberrypi/bin/sn-util-rpi get 2 '.$row["sensor_id"].' | grep '.$row["sensor_id"].''); $soil_sensor3 = exec('/opt/tempberrypi/bin/sn-util-rpi get 3 '.$row["sensor_id"].' | grep '.$row["sensor_id"].''); if ($soil_sensor1) { $status = ""; $sql_bus = "UPDATE sensors_info SET sensor_bus = '1' WHERE `sensor_id` ='".$row["sensor_id"]."'"; $result_bus = $conn->query($sql_bus); $row["sensor_bus"] = 1; } else if ($soil_sensor2) { $status = ""; $sql_bus = "UPDATE sensors_info SET sensor_bus = '2' WHERE `sensor_id` ='".$row["sensor_id"]."'"; $result_bus = $conn->query($sql_bus); $row["sensor_bus"] = 2; } else if ($soil_sensor3) { $status = ""; $sql_bus = "UPDATE sensors_info SET sensor_bus = '3' WHERE `sensor_id` ='".$row["sensor_id"]."'"; $result_bus = $conn->query($sql_bus); $row["sensor_bus"] = 3; } else { $status = ""; } } } $state = 'on'; if ($row["sensor_state"] == "on"){ $state = 'off'; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; #echo ""; if ($row["sensor_group"] == 0) { echo ""; } else { $sql2 = "SELECT * FROM sensors_groups"; $result2 = $conn->query($sql2); if ($result2->num_rows > 0) { while($row2 = $result2->fetch_assoc()) { if ($row["sensor_group"] == $row2["gid"]) { echo ""; } } } } echo ""; } } else { echo "There were no sensors found. Please run the FindSensors command below to find sensors.

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

ID	Sensor ID	Bus ID	Name	State	Present	Type	Group	Manage
" . $row["sid"]. "	" . $row["sensor_id"]. "	" . $row["sensor_bus"]. "	" . $row["sensor_name"]. "	" . $row["sensor_state"]. "	" . $status. "	" . $row["sensor_type"]. "	" . $row["sensor_geotag"]. "		" . $row2["group_name"]. "	Edit Sensor ----- Set On/Off ----- Reset Sensor