Hello Fellow Webmasters,

I am working on a hotel website with php and mysql database.I am abit confused on the approach to use to enable customers to make reservations and pay online. Here are my challenges.

1) Should i use an already developed hotel management system and integrate it to the site to handle reservation? If so , which one is very good and which payment platform can i use for receiving payment ?

2)Should i code the it in PHP? The comparison of dates to enable which rooms are free are a bit tricky. What is the exact query to use to compare the check in and check out dates? Find rooms that have not been booked.

What payment can i integrate in the code to receive payment ?

I will appreciate your public expert advice .

Thanks

Do you know that u can use woocommerce + payment integration plugin for Wordpress to build Hotel Reservation System?
Want to know more whatsapp/call me on 08063718360

laideogunjobi:
Do you know that u can use woocommerce + payment integration plugin for Wordpress to build Hotel Reservation System?
Want to know more whatsapp/call me on 08063718360

I am not using wordpress. Doing the design from scratch, nut you can share for others to learn.

I advise you code from scratch. Use php date () for date comparisons.

And for payment platform, contact your bank or any payment processors online.

Greene66:
I advise you code from scratch. Use php date () for date comparisons.

And for payment platform, contact your bank or any payment processors online.

I am doing so. The only challenge is searching for a room in the database that is before or after check in and checkout date.

IF there is a reservation for 12/5/17 to 15/5/17 if another person wants to make a reservation of same room for 13/5/17 , to be sure that the same room does not show up as vacant before then is a challenge.

Need to know the exact query format for comparing the checkin and checkout dates.

osile2012:


I am doing so. The only challenge is searching for a room in the database that is before or after check in and checkout date.

IF there is a reservation for 12/5/17 to 15/5/17 if another person wants to make a reservation of same room for 13/5/17 , to be sure that the same room does not show up as vacant before then is a challenge.

Need to know the exact query format for comparing the checkin and checkout dates.

It depends on so many factors ,most importantly it depends on ow your database was designed .

Donald3d:

It depends on so many factors ,most importantly it depends on ow your database was designed .

Basic tables

Rooms


Booking

Guest

Booking includes both room and guest primary keys with checkin and checkout dates

osile2012:
Hello Fellow Webmasters,

I am working on a hotel website with php and mysql database.I am abit confused on the approach to use to enable customers to make reservations and pay online. Here are my challenges.

1) Should i use an already developed hotel management system and integrate it to the site to handle reservation? If so , which one is very good and which payment platform can i use for receiving payment ?

2)Should i code the it in PHP? The comparison of dates to enable which rooms are free are a bit tricky. What is the exact query to use to compare the check in and check out dates? Find rooms that have not been booked.

What payment can i integrate in the code to receive payment ?

I will appreciate your public expert advice .

Thanks

For a table with columns room_number, check_in and check_out, use something like this select * from rooms where room_number = '$room_number' and ((date_in >= '2017-05-12' and date_out <= '2017-05-22') or (date_in <= '2017-05-12' and date_out >= '2017-05-22'));

Dermie:


For a table with columns room_number, check_in and check_out, use something like this select * from rooms where room_number = '$room_number' and ((date_in >= '2017-05-12' and date_out <= '2017-05-22') or (date_in <= '2017-05-12' and date_out >= '2017-05-22'));

ok thanks

osile2012:


ok thanks

You're welcome!