connect_error) { die("Connection failed: " . $conn->connect_error); } $SetAllOn = isset($_REQUEST["SetAllOn"]) ? $_REQUEST["SetAllOn"] : ""; $SetAllOff = isset($_REQUEST["SetAllOff"]) ? $_REQUEST["SetAllOff"] : ""; $ReSetAll = isset($_REQUEST["ReSetAll"]) ? $_REQUEST["ReSetAll"] : ""; if ($ResetSensor == "Reset Sensor") { $sql = "UPDATE sensors_info SET sensor_name = '', sensor_state = 'off', sensor_setup = 'no', sensor_type = '', sensor_geotag = '', sensor_limit1 = '', sensor_limit2 = '', sensor_limit3 = '', sensor_limit4 = '', sensor_comment = ''"; } if ($SetAllOn == "Set All On") { $sql = "UPDATE sensors_info SET sensor_state = 'on', sensor_setup = 'yes'"; } if ($SetAllOff == "Set All Off") { $sql = "UPDATE sensors_info SET sensor_state = 'off', sensor_setup = 'no'"; } $sql .= " WHERE sid != ''"; #echo "sql = ".$sql."
"; if ($conn->query($sql) === TRUE) { #echo "Records added successfully."; } else { #echo "Could not find the entry your requested."; } $conn->close(); header("Location: update_ebutton.php"); #header("Location: list_sensors.php"); ?>