Online Booking System

[lethaldesign]

I'm looking to create an online booking system for my guest house but am having trouble finding any tutorials or scripts that will help me.

Does anyone know of any tutorials or free scripts that I could use? It would be of great help!

thanks.

 

[MJB3K]

it depends on what you want your booking system to do?

you need to ask yourself some questions to get it specific to you:

What mysql fiels does it need?
Does it send emails to you when people have booked?
Or will it have a control panel?
What is the booking system used for?
Can people see whether things are booked?
If so, show that they are booked and/or when they will be free.

It is simple enough to build one once you get the basic structure sorted out.

Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[jpadie]

there are a number of code samples for hotel booking systems out there. check out hotscripts for example.

i found that none really addressed the needs of a house booking system. my family owns a number of casitas in southern spain and i ended up writing my own app to provide them with a booking system. i'm two thirds of the way thru and never seem to have time to finish it...

Martin is correct that it is simple to build ... but it is time consuming. particularly if you are not experienced in php and rdbms integration.

 

[benluke4]

i am also interested in learning how to right a booking system, using php and mysql. or finding a suitable pre-built one

I need it to send emails to people and to owners when there is a online booking.

show people when things are booked and when they are free.

have a control panel so that the owner can put in bookings he has taken offline so that the dates will show up booked to ther user.

other than that i dont have that much of a clue how to build it.

I could probably manage the automated emails to people.

so you reckon hunting around on the internet, ill let you know if i come across any!

Ben

 

[jpadie]

the (very slow and more like 2/3 alpha rather than beta) site that i have is at

http://elcanuelo.m-legal.net/main.php.

 

[MJB3K]

How did you get a calender to work so that you get the correct days in each month? That's the only trouble i have in these sort of apps and to get the data to show at the correct place...

any ideas about above ^^ ??

Regards,

Martin

Gaming Help And Info:

http://gaming.webrevolt.biz

 

[CliveC]

If you do not feel able to code the site yourself and want a custom solution, you should perhaps consider one of the online contract programming sites.

What is critical to a good experience is to make very precise (and quantifiable) specifications.

Depending on how many rooms you have you maybe do not even need a database but instead have an easily updatable PHP array. This would be much faster, less error prone, and easier to code.

Hope this helps.

Clive

http://tubularity.com

http://PalliativeCareConsulting.org

 

[benluke4]

could you reccomend one of these sites Chris

Thanks

Ben

 

[CliveC]

I think it was elance.com. the guy I used charged me $50 for a mysql solution that would have probably taken me 20 hours to figure out.

Clive

http://tubularity.com

http://PalliativeCareConsulting.org

 

[benluke4]

Cheers Clive

 

[jpadie]

Martin

How did you get a calender to work so that you get the correct days in each month? That's the only trouble i have in these sort of apps and to get the data to show at the correct place...

it's a combination of things.

you need to know the month and year. then to get the number of days in that month use the following:

$monthstart  =$year ."-".$month."-01";
$dtt = strtotime($monthstart);
$num_days = date("t",$dtt);

to find out the first day of the month

$firstday = date ("w", $dtt);

then it's just a question of a for loop to plot the days (in my example you run the for loop twice for the header, once for the day of the month and once for the day of the week.

then run a for loop and either:
(a) do a db query on every intersection
(b) test against a prefilled array.

the above seems inefficient but was the best way i could come up with to display this kind of data in this manner. the db solution was a bit clunky too, i ended up keeping a separate table of date and house booking to make the lookup speedier and the query simpler.