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

From Progzoo
Jump to: navigation, search
(Store response in the database)
(Store response in the database)
Line 28: Line 28:
 
Send the responses from the user to the database.
 
Send the responses from the user to the database.
 
{{#ev:youtube|CHuk-SygSi8}}
 
{{#ev:youtube|CHuk-SygSi8}}
 +
 +
==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.
 +
{{#ev:youtube|}}

Revision as of 11:45, 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.

EmbedVideo is missing a required parameter.