Using PHP and AJax for simple booking system (flat file based so no database needed!)

A simple, free,  easy to use online booking system for theatres, cinemas etc…It is written in PHP and AJAX. This does not use MySQL or other databases instead it is a flat file based (txt), and works with either Linux or Windows Web servers (not tested on Mac servers).

This is only a basic concept of a PHP AJAX online, therefore should not be used in a real world scenario, due to the security issues of flat-files.

view demo of ajax php booking system

(opens in new window)

How does it work?

When a booking is made it is written to a text file. But to get an idea of how it works, view the demo and download the source code (link at the bottom)

It prevents double booking both client side (Ajax) and server-side with the php

In the Ajax file it checks if the file booked seat exists by checking if a file exists corrisponding to the seatnumber (best explained when viewed in source code and demo!)

The source code is Freeware, although please credit me where due if you decided to adapt/ use it for your projects

Downloads

download source code (zip file 210KB)

How to query a reservation database for room availability using Microsoft Access & SQL

How to Query a Reservation Database (by Date) for Room Availability Microsoft Access & SQL

keywords:

• Query room availablity
• Hotel Reservation Database
• Microsoft Access
• check room availablity
• SQL
• How to query a reservation database
• Prevent Double booking

Studying an IT/Computing course and looking how to do a hotel database?

If you are wanting to create a simple reservations database (such as hotel database), you will need to have a query to determine which rooms can be booked for a range of days and prevent double booking…

A few years ago, for my AVCE i created such a system. Basically, its a relational database that uses forms, SQL and some visual basic.
This was created for an AVCE ICT project, but it can be adapted/modified to suite your specification (it includes the technical documentation).
The hotel reservation system was created using Microsoft Access 2002, but it also works in Microsoft Access 2000, as well as Access 2002/XP,2003, and 2007.

The SQL quey checks room availability by seeing which rooms are booked and inversing it thereby showing which rooms are available

read more on Hotel Reservation Database created in Microsoft Access (can also download a template and view a demo)