query('UPDATE `actions` SET `threshold` = ' . $_POST['threshold'] . ' WHERE `unit_id` = 1');
}
// SELECT QUERIES
$total_count = $conn->query('SELECT * FROM `water` WHERE unit_id = 1');
$total = 0;
while($row = $total_count->fetch_assoc()){
$total += $row['count'];
}
if (isset($_POST["date_time_start"]) && isset($_POST["date_time_end"])) {
$results = $conn->query("SELECT * FROM water WHERE date_time BETWEEN '{$_POST['date_time_start']}' AND '{$_POST['date_time_end']}'");
$start_date = $_POST['date_time_start'];
$end_date = $_POST['date_time_end'];
} else {
$date_of_24_hours_ago = date("Y-m-d H:i:s", strtotime("-1435 minutes"));
$results = $conn->query("SELECT * FROM water WHERE date_time >= '$date_of_24_hours_ago'");
$start_date = '';
$end_date = '';
}
$action_res = $conn->query("SELECT * FROM `actions` WHERE unit_id = 1");
$action = $action_res->fetch_assoc();
?>
Search by date