I am working on a web project where I have different kinds of meeting rooms (room1, room 2, room 3) and more can be added by the admin. Each room have different quantity as well.
So my table structure is
fromtime (Datetime format)
totime (datetime format)
I want to check the availability of rooms according to time depending on the user input. how can I do that?