Đang Thực Hiện

136442 Rooms Available in Calendar


I'm making the admin area of a hotel booking system in mysql and php, but I just can't figure out how I can select and show rooms in a calendar style (see here: [url removed, login to view]). Text boxes show the value of column "rooms" from "avail" table, that is the number of rooms available for that day for that type of room.

User can input $startdate, $enddate, $hotelid when search is made. When there is no record for a certain date (e.g there are records between 2007-04-11 and 2007-04-18 in the DB, but user searches between 2007-04-11 and 2007-04-20) text boxes should still appear with a value "-1".

I would also like to update the calendar.

For sql stucture: [url removed, login to view]

I'm confused and stuck with loops and arrays.

Thank you.

Kĩ năng: Bất kì công việc gì, MySQL, PHP

Xem nhiều hơn: calendar booking, booking calendar, available, sql update text, php mysql stucture, mysql calendar table, mysql number sql, update text sql, calendar room booking, php mysql booking system rooms, sql update text text, booking calendar php room, hotel room booking php, update gif, php admin calendar, calendar booking system php mysql, calendar mysql php, calendar php mysql booking system, booking system php calendar, calendar update mysql, search update record php, mysql show date, room booking system php, php mysql hotel booking system, hotel system php

Về Bên Thuê:
( 1 Nhận xét )

ID dự án: #1882614