PHP MySQL - Module Feedback Setup
- 1 Preparing GIT (optional)
- 2 Dive in to PHP and MySQL
- 3 Developing SQL statement to get the data you need
- 4 Sections for each module
- 5 Asking a question for each module
- 6 Install your own database
- 7 Store response in the database
- 8 Fixing some problems (optional)
- 9 Changing the question number format
- 10 Showing output
Preparing GIT (optional)
Setting up a project using git and bitbucket.org
Dive in to PHP and MySQL
Welcome the user - looking up the name
Developing SQL statement to get the data you need
Using the command line interface to figure out the SQL you need
Sections for each module
We want one section for each of the three modules being studied.
Asking a question for each module
For each module that the student takes we will ask them to answer one question and allow a response.
Install your own database
You are not allowed to write to the gisq database - time to set up your own.
Store response in the database
Send the responses from the user to the database.
Fixing some problems (optional)
There was a referential integrity missing and we have messed up the data. This video finds the missing data, and puts in the missing integrity constraint.
Changing the question number format
Dealing with more than one question.
Use the radar charts from http://www.chartjs.org/docs/#radar-chart