Brief

This platform was built for a small independent cinema specialising in Bollywood movies. Through their dynamic booking platform guest users choose from a range of 'currently screening' movies, and are presented with appropriate dates and session times for that selection. A booking confirmation is generated when the user makes a selection & submits their personal information for the reservation.

The platform was integrated with a MySQL database where a library of movies, schedules and booking records could be safely stored.

Solution

A booking system was required that had a dynamic user interface integrated with a physical database. A lightweight and reactive UI was developed by utilising AJAX database requests in the background and using the results to populate the DOM based upon the user interaction / data request.

Skills

The dynamic functionality was built upon frequent client-database interactions, a key factor to achieving this was through effective management of the data-flow of the application. This ranged from:

• standard database storage & SQL queries,
• dynamic SQL queries,
• passing the data through JSON formatted asynchronous requests (AJAX),
• generating dynamic links/buttons (using html data-attributes) from AJAX results,
• maintaining state using php session variables,
• procedural programming logic to create a new user db record before allowing a booking record to be made,
• assign multiple tickets to a single user/booking using 'for' loops.