PHP MySQL jQuery tutorial - Cinema Seat Booking
Based on File:Cw1-2017.docx and http://progzoo.net/cw1-2017.zip
Contents
- 1 Unzipping the files
- 2 Looking at the database
- 3 PHP to JSON
- 4 Inject values from MySQL into JSON
- 5 Transforming data from MySQL into JSON
- 6 Taking out the cheats - build the rowLabels and colLabels from the database
- 7 Building the umap structure from the database
- 8 Tidying up
- 9 Making bookings to MySQL
Unzipping the files
Download the files from http://progzoo.net/cw1-2017.zip unpack them and put them on the web.
Looking at the database
PHP to JSON
Inject values from MySQL into JSON
Transforming data from MySQL into JSON
Taking out the cheats - build the rowLabels and colLabels from the database
Building the umap structure from the database
Tidying up
We started with hard coded values and we must be sure that these are all removed.
Making bookings to MySQL
Allow internet users to add bookings to the database.