PHP Forum

**john_zakaria** · 12-21-2008, 08:00 AM

room_type
rooms_no
persons
checkin
checkout
3 2 1 0000-00-00 0000-00-00
6 3 4 2008-11-14 0000-00-00
6 3 4 2008-11-14 0000-00-00
4 4 5 2008-11-14 2008-11-18
Now I have this table and I want to make SQL STATEMENT to make the following task
To see if the user can make a reservation in a hotel during the checkin and checkout date, by checking the numbers of rooms available in each room type during the checkin and checkout period of time
For example if the user enter number of persons that exceed the person that exists already in the database
And also to check if this period of time is available to make reservation according the the persons number

Note : rooms-type in this example are (3,6,6,4)
room_no in this example are (2,3,3,4)
person (1,4,4,5) -> number of persons

**CouponGuy** · 12-21-2008, 02:31 PM

Well, this seems fairly straightforward, so here is a starting point:

Assumptions:
Table is named availablerooms
Code below is for demonstration purposes and will be updated to prevent SQL injection, etc

PHP Code:


			
<?

//gather variables from form

$room_type = $_POST["room_type"];

$persons = $_POST["persons"];

$checkin = $_POST["checkin"];

$checkout = $_POST["checkout"];



//check if any rows in table meet criteria

$sql = "

   select *

   from availablerooms

   where

      room_type = {$room_type}

      and persons >= {$persons}

      and checkin >= '{$checkin}'

      and checkout <= '{$checkout}'

";

$sql_result = mysql_query($sql);

?>