CodeIgniter Forums
Searching room availability between arrival and depature date..PHP - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: Libraries & Helpers (https://forum.codeigniter.com/forumdisplay.php?fid=11)
+--- Thread: Searching room availability between arrival and depature date..PHP (/showthread.php?tid=74801)



Searching room availability between arrival and depature date..PHP - phyu - 11-07-2019

Hi guys...I am now working  the online reservation system for hotel for final year project and i am beginner in php.All the data transcation are done and
 I am stuck at checking room availability between date
My tables are following like this 

Roomtype-------
RoomtypeID
Name
Price
------
Reservation----
ReservationID
RoomtypeID
Arrival date
DepartureDate
------
I want to know how to make the SQL query