jib0723

Hi Barand, Thank you very much. I greatly appreciate your time and help on this. I will study this to understand it better.

Hi Barand, I'm sorry for sending my last post too soon. After reading through that link, I'm still having trouble understanding how to show available timeslots when the duration of a booking is chosen by the user (where it could be 30 minutes, 1 hour, 1.5 hours, or 2 hours long). Is it even possible to do?

Ok. Thank you again for your time and help.

After talking with my group members, I realized that we are handling the time slots differently than I realized. The users can book a meeting room between the hours of 8 AM and 5 PM. They have 4 choices: they can book a room for a length of 30 minutes, 1 hour, 1 hour & 30 minutes, or 2 hours. How would I show available time slots in that scenario? I'm sorry for giving the wrong information in my last posts. Thank you again and I appreciate your time and help.

Hi requinix and Barand, Thank you very much for your help and fast replies. requinix: Our group is still deciding how to display the reservation times. A table would probably be the best way (?). Barand: I greatly appreciate the link that you sent. It looks to be very helpful. If we create the "booking_periods" table, would it store all possible times that the room could be booked (8-8:30, 9-9:30, 10-10:30 etc)? Also, should we move the "date" column into that "booking_periods" table?

Hello, I am working on a team for a class project where we are building a website (with PHP and MySQL) that will allow a user to book a meeting room (inside of a community center). The center houses four meeting rooms. A user has to create an account to be able to login and then reserve a room. They need to be able to delete and modify a reservation. Additionally, administrators have their own account on the website and can see and control all reservations. We have created three database tables (using MySQL): reservation, rooms, users. These are the columns for all of the tables Reservation: resid (Primary Key), roomid (Foreign Key), userid (Foreign Key), date, start_time, end_time, participants (number of people) Rooms: roomid (Primary Key), mincapacity, maxcapacity Users: userid (Primary Key), firstname, lastname, email, password, role (tracks if they are a user or an administrator) We are now trying to figure out how to display reservations that have already been booked (using PHP). Our team has decided that a user can only reserve a room between the hours of 8:00 AM and 5:00 PM. Each reservation will be for 30 minutes at a time. How can we remove a time as an option (example: 9:00 AM- 9:30 AM) if it has already been booked? Thank you in advance for any suggestions. I would greatly appreciate it.