Difference between revisions of "PHP MySQL - Module Feedback Setup"

From Progzoo
Jump to: navigation, search
(Fixing some problems (optional))
(Changing the question number format)
Line 36: Line 36:
==Changing the question number format==
==Changing the question number format==
Dealing with more than one question.
Dealing with more than one question.

Revision as of 12:38, 27 March 2017

Based on File:Cw2-2017.docx and http://progzoo.net/cw2-2017.zip

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.