Đang Thực Hiện

136442 Rooms Available in Calendar

Hi,

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 thêm: calendar booking, booking calendar, available, sql update text, php mysql stucture, mysql calendar table, mysql number sql, update text sql, calendar room booking, booking calendar php room, hotel room booking php, update gif, php admin calendar, calendar mysql php, booking system php calendar, calendar update mysql, search update record php, mysql show date, room booking system php, hotel system php, booking system calendar php, hotel room booking mysql, hotel php mysql, php calendar system mysql, mysql room booking

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

Mã Dự Án: #1882614