Introduction to Database Technology - DT Results Introduction to Database Technology - DT Results Year Students Pass Fail (no resit) Resit Withdrawn 2012/13 60 40 7 3 10 2013/14 45 25 5 15 0...

Introduction to Database Technology - DT Results
        Introduction to Database Technology - DT Results
            Year    Students    Pass    Fail (no resit)    Resit    Withdrawn
    2012/13    60    40    7    3    10
    2013/14    45    25    5    15    0
    2014/15    50    35    3    7    5
    2015/16    48    30    8    3    7
    
Problem Solving for Programming – PfP Results
        Problem Solving for Programming – PfP Results
            Year    Students    Pass    Fail (no resit)    Resit    Withdrawn
    2012/13    65    45    7    3    10
    2013/14    55    35    5    15    0
    2014/15    60    45    2    10    3
    2015/16    38    30    8    3    7
    
PHP Task
The Department of Computer Science (DCS) at Birkbeck College, have requested that you develop a prototype main page and link this page to prototype secure intranet pages. Your system should include the following aspects:
7. Main index page, which should provide some dummy content, as an introduction to DCS, plus the following links:
Intranet: links to a secure page which provides access to module results via a login 

Administrator: links to a registration page/form via admin password, which if successful, allows an administrator to set up new members of staff. 

8. Log-in: A member of staff should be able to log-in to the intranet by entering a valid username and password in a form. 

9. Log-out: A logged in member of staff will be able to log-out of the system from any page, and a message will be displayed to this effect returning the user to the index page. 

10. Admin page: A page for an administrator to register a new member of staff to allow them to login to the intranet. The data required for a member of staff to be registered as a user is: 
Title, First name, Surname, Email, Username and Password 

11. The administrator user name should be “admin” and the password should be “dcsadmin01” for testing purposes). 

12. Secure intranet content pages: An intranet index page which links to 3 module results pages (data provided in the FMA resources folder in Moodle). These three pages should show module results for the following modules:
Web Programming using PHP - P1 Results 

Introduction to Database Technology – DT Results 

Problem Solving for Programming – PfP Results 

13. The user should be able to
owse between pages while maintaining their logged-in or out state, regardless of their
owser settings. N.B. the module results pages should only be accessible if a member of staff has successfully logged in (including the administrator user), otherwise only the index page should be available. 

14. All pages should display a link or form to log-in or out depending on the cu
ent user status. If the user is logged in, the page should display the username of the logged in user and if a user logs out they should be redirected to the index page. 

A user navigating to any of the public content pages should be able to view the content directly whether they are logged-in or logged-out. The pages should clearly display their user status (apart from the URL links to https:
www.dcs.
k.ac.uk/... pages). If a logged out user tries to access the intranet pages, they should be politely requested to log-in.
There is no specific requirement to apply any CSS or other formatting to your html output, however, you may do so, if you feel that it adds to the presentation of your solution.
However, the output should use htmlentities and validate co
ectly under the DOCTYPE you have specified.
Hints
Your solution should be as robust as possible while providing a usable experience for users; remember the motto of form submission "Never trust user input". Any security flaws in your final design should be clearly outlined in a learning/development log, which you will need to submit as one of your deliverables. It may also be helpful to carefully consider the following before you begin any coding:
·         ⚫Consider what data you will need to store, what the validation criteria is for it and where you will store it. You are not permitted to use a MySQL (or other) database for this assignment, so you will probably want to store user data in an external file. Consider the security implications of using such a file and set appropriate permissions settings on the server. 

·         ⚫Remember the quickest way to write this application is to avoid repeating any PHP or HTML code. Thus, you will need to do a design and plan out some useful functions and/or include files that you could write once and then reuse throughout your project. 

·         ⚫You will need to maintain state between pages. It would, therefore be useful to review the class slides on PHP security and session and cookie management. 

·         ⚫You will need to modify the given module results data files to facilitate secure access and maintain a session; you are allowed to rename them to have a .php extension to facilitate this. 


__MACOSX/._k
k/.DS_Store
__MACOSX/k/._.DS_Store
k/index.php
?php
    require 'includes/functions.php';
    startSession();
?
!DOCTYPE html PUBLIC "-
W3C
DTD XHTML 1.0 Strict
EN" "http:
www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"
html xmlns="http:
www.w3.org/1999/xhtml" xml:lang="en" lang="en"