PHP/Postgresql tutorial

Authors:
Created 2014 by Arnold Rosenbloom

Note: To be done and submitted from the lab. All work should be done in your public_html/LabWeek4 directory created as part of the css tutorial. You probably want to copy the contents of your GuessGame directory to your public_html/LabWeek4 directory.

First a definition (from the Apache website)...

Authentication

Authentication is any process by which you verify that someone is who they claim they are.

Authorization
Authorization is any process by which someone is allowed to be where they want to go, or to have information that they want to have.
Your job is to modify your guessGame so that only authenticated users are authorized to play the game. To do this, create and populate an appuser postgresql table. This should contain usernames and passwords. Next, create a login page which authenticates users and then allows (or not) users to play your guess game. Only authenticated users are authorized to play your guess game. If a non-authenticated user attempts to access protected content, they should be immediately sent to the login page.

I have created a database account for you with the following details

USER: matriculation number (ie. a00XXXXX) PASSWORD: the token I sent you earlier DATABASE: your matriculation number (ie. a00XXXXX)

psql -U USER -d DATABASE -h localhost

\i filename

When you are finished, zip up your LabWeek4 directory , containing both your improved GuessGame as well as your CSS work. and submit LabWeek4.zip to the new cp3101b submit page. We may do a code review with your submission, so make sure that there is no identifying information in your submission.
References: rdbms lecture notes, and PHP/Postgresql examples