<?php

if(isset($_POST['request_date'])) {

  $user_id = $_SESSION['user_id'];
  $first_name = $_SESSION['first_name'];
  $last_name = $_SESSION['last_name'];
//  $request_time = date("d-m-Y H:i:s");
  $lend_status = 1;
  $lend_id = $_POST['lend_id'];
  $requested_start_date = $_POST['requested_start_date'];
  $requested_end_date = $_POST['requested_end_date'];

$STH = $DBH->prepare("SELECT * FROM laptop_system WHERE approved_end_date >= requested_start_date AND approved_start_date <= requested_end_date");
$STH->execute(array($result));


if(!empty($result)){

  echo 'sorry this date is not available';

}
else {

 $STH = $DBH->prepare("INSERT INTO laptop_system (user_id,first_name,last_name,lend_status,requested_start_date,requested_end_date) VALUES(?,?,?,?,?,?)");
 $STH->execute(array($user_id,$first_name,$last_name,$lend_status,$requested_start_date,$requested_end_date));

  echo $first_name . ' your laptop request is now pending';

}
}

?>


<form action="" method="post" >
  <label for="requested_start_date"> Requested Start Date
  <input type="date" name="requested_start_date" value="<?php echo $requested_start_date; ?>">
  </label>
  <label for="requested_end_date">Requested End Date
  <input type="date" name="requested_end_date" value="<?php echo $requested_end_date; ?>">
  </label>
  <input type="submit" name="request_date" value="Request Date">
  <input type="hidden" name="lend_id" value="<?php echo $lend_id; ?>" />
</form>