fork download 
  1. <?php
  2. session_start();
  3. if (isset($_POST['submit'])) {
  4. if(!isset($connDB)){
  5. include("DBConn.php");
  6. connDB();
  7. }
  8. $checkInDate = $_POST['checkin'];
  9. $checkOutDate = $_POST['checkout'];
  10. $roomTypeId = $_POST['roomtype'];
  11. $statement = "SELECT total_room FROM room_type WHERE room_type_id = '$roomTypeId'";
  12. if ($result = mysqli_query($mysqli, $statement))
  13. {
  14. while ($row = mysqli_fetch_object($result))
  15. {
  16. $noOfRoom = $row->total_room;
  17. }
  18. }
  19. $statement = "SELECT COUNT(*) AS roomReserved FROM reservation WHERE room_type_id = '$roomTypeId' AND (begin_date <='$checkInDate' AND end_date > '$checkInDate' OR begin_date <'$checkOutDate' AND end_date >='$checkOutDate' OR begin_date >'$checkInDate' AND end_date < '$checkOutDate') ";
  20. if ($result = mysqli_query($mysqli, $statement))
  21. {
  22. while ($row = mysqli_fetch_object($result))
  23. {
  24. $roomTaken = $row->roomReserved;
  25. }
  26. }
  27. $available = $noOfRoom - $roomTaken;
  28. if ($available > 0){
  29. $_SESSION['availability'] = "The room is available. Reserve your room now";
  30. $_SESSION['checkin'] = $checkInDate;
  31. $_SESSION['checkout'] = $checkOutDate;
  32. } else {
  33. $_SESSION['availability'] = "Sorry, not available. Select a different date or a different room type";
  34. $_SESSION['checkin'] = "";
  35. $_SESSION['checkout'] = "";
  36. }
  37. header("Location: reservation.php");
  38. mysqli_close($mysqli);
  39. }
  40. ?>
  41.  
  42.  
Success #stdin #stdout 0.03s 25508KB
comments (?)
stdin 
45
stdout
https://ideone.com/fUDwJk
language:
PHP (php 7.3.5)
created:
6 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!