clearAll.php

<?php
require_once 'connect.php';
require_once 'functions.php';

if (isLoggedIn() && isAdministrator()) {
	
} else {
	echo "Access prohibited. Please make sure that you are an administrator before trying to view this page. You will now be redirected.";
	header('refresh:5,url=index.php');
	die();
}

if(isset($_POST['user_id']) && isset($_POST["dateFrom"]) && strlen($_POST["dateFrom"]) > 0 && is_numeric($_POST["dateFrom"]) && isset($_POST["dateTo"]) && strlen($_POST["dateTo"]) > 0 && is_numeric($_POST["dateTo"])) {
	$id = $_POST['user_id'];
	$dateFrom = $_POST['dateFrom'];
	$dateTo = $_POST['dateTo'];
	$result = mysqli_query($connect, "UPDATE time_entries SET status = 0 WHERE timeIn > ".$dateFrom." AND timeOut < ".$dateTo." AND user_id = ".$id." ");
	if(!$result) {    
		header('HTTP/1.1 500 Could not update record!');
		exit();
	}
} else {
	//Output error
	header('HTTP/1.1 500 Error occurred, Could not process request!');
    exit();
}

?>