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_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 = '3' 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 = ""; } } } $plot = 'on'; if ($row["sensor_plot"] == "on"){ $plot = 'off'; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } } else { echo "There were no sensors found. Please run the FindSensors command below to find sensors.

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

ID	Sensor ID	Name	State	Present	Type	Plot Data	Manage
" . $row["sid"]. "	" . $row["sensor_id"]. "	" . $row["sensor_name"]. "	" . $row["sensor_state"]. "	" . $status. "	" . $row["sensor_type"]. "	" . $row["sensor_plot"]. "	Edit Sensor ----- Plot On/Off