Assignment 4: PHP and mySQL Registration Page
18 December 2015 (5pm)
The purpose of this assignment is for you to demonstrate the
following learning outcomes and for me to assess your achievement
of them.
Students should:
You will be writing a small PHP/SQL application to deal with
the following (fictionalized) problem.
There are 32 students assigned to a module. In order to organize module
demonstrations, the class should be split into four
groups with different time slots. Each group should consist of 8 students.
The module lecturer decided to have a registration
webpage to allow students to sign up for one of the demonstrations.
A student visiting the page should be able to submit her
name, student ID, email address, and book a place in
one of the time slots. For example, the registration Web page of COMP207
looks like this:
The submitted data should be stored in a database which is maintained on a server. The webpage and the server should interact with each other at every step of the registration process. The page should show how many free places are available in each time slot, announcing and blocking all fully booked time slots. After a student makes a data submission, it should check whether the student has been already registered. If not, the data is stored on the server and the student is notified about her registration. Otherwise (if already registered), the student should be prompted to ensure that she wants to change her registration to the new section (and removed from the current one she is registered for).
As a means of checking which students are registered in each section, you should also write a separate webpage that will allow the module lecturer to choose a section and, after querying the database, will display the list of students who are registered in that section to a webpage.
For your assignment, you are to write a registration webpage using HTML, CSS, JavaScript, PHP and mySQL, as outlined above, in order to allow students to register to demonstration timeslots.
The database must fully implement the registration process, maintaining the submitted information. The server and page behavior must meet the requirements listed above. In addition, (basic) help facilities should be provided. A separate page for the lecturer should also be working so that he/she can see the students currently enrolled.
The specific look and feel of the pages as well as
the database implementation is left intentionally vague,
allowing considerable design freedom on your part.
However, the page should have a nice look and the code
should satisfy common standards.
You may also add additional features to your page.
For example, you can add JavaScript and/or PHP functions
which can validate the name (for example, that the
field isn't empty), SID (that it has only numbers in it),
and email fields.
Note: For the purposes of this assignment, you may
assume that I *will* have JavaScript enabled in my
browser. (Of course, that may not be true in other
situations when you are writing your own applications
outside of this course!!)
Important note: It is assumed that your HTML/PHP
code you write will comply with the XHTML Strict 1.0 standards
(or better, such as HTML5). Failure to adhere to proper
web coding standards will result in a loss of marks from your grade.
Please remember to have your webpage(s) online so that
I can access them via a web browser and to submit
them to the
Coursework Submission System
5pm on the day they are due.
When you submit your files,
be sure to include all relevant HTML, CSS, PHP
files. Include an SQL dump of the relevant table(s)
that you are using for this assignment. (Use
the "mysqldump" command to generate this file, as
outlined in the notes.)
Having your webpages online is a necessary part of
this assignment so that I
can accurately assess they are working correctly in terms
of storing data in the database and interacting with
the server.
When submitting your solution, don't forget to include
a completed
Declaration
of Academic Integrity.
This assignment contributes 1/4 of the 75% continuous
assessment part of the course grade. The maximum possible
grade on this assignment is 100 points.
Failure in this task can be compensated by higher marks on
the other assessments of the module.
Grade | Classification | Percentage | Qualitative Description |
---|---|---|---|
A* | Good Distinction | 80+ | Factually almost faultless; perceptive and focused treatment of all issues. Clearly directed; logical; comprehensive coverage of topic; strong evidence of reading/research outside the material presented in the programme; substantial elements of originality and independent thought; very well written. critical and scholarly presentation. |
A | Distinction | 70-79 | Logical; enlightening; originality of thought or approach; good coverage of topic; clear, in-depth understanding of material; good focus; good evidence of outside reading/research; very well written and directed. |
B | Good Pass | 60-69 | Logical; thorough; factually sound (no serious errors); good understanding of material; evidence of outside reading/research; exercise of critical judgement; some originality of thought or approach; well written and directed. |
C | Pass | 50-59 | Worthy effort, but undistinguished outcome. Essentially correct, but possibly missing important points or inadequate treatment. Largely derived from material delivered in the programme, but with some evidence of outside reading/research; some evidence of critical judgement; some weaknesses in expression/presentation. |
D | Compensatable Fail | 40-49 | Incomplete coverage of topic; evidence of poor understanding of material; Poor presentation; lack of coherent argument. Very basic approach to a narrow or misguided selection of material. Lacking in background and/or flawed in structure. |
F | Fail | < 40 | Serious omissions; significant errors/misconceptions; poorly directed at targets; evidence of inadequate effort. Shallow and poorly presented work showing failure in understanding. |
The University's standard policy on lateness penalties will be applied with respect to the latest electronic submission of the assessment. See Section 6 of the Code of Practice on Assessment for further details.