Difference between revisions of "PHP MySQL jQuery tutorial - Cinema Seat Booking"

From Progzoo
Jump to: navigation, search
(Created page with "Based on file:cw1-2017.docx and http://progzoo.net/cw1-2017.zip ==Unzipping the files== {{#ev:youtube|DR-n_I2FNgc}} ==Looking at the database== {{#ev:youtube|CTCLG4E5tqs...")
 
(Unzipping the files)
Line 2: Line 2:
  
 
==Unzipping the files==
 
==Unzipping the files==
 +
Download the files from http://progzoo.net/cw1-2017.zip unpack them and put them on the web.
 
{{#ev:youtube|DR-n_I2FNgc}}
 
{{#ev:youtube|DR-n_I2FNgc}}
  

Revision as of 16:07, 21 February 2017

Based on File:Cw1-2017.docx and http://progzoo.net/cw1-2017.zip

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.