2011 WebEng CS Number 03

St. Rose College
Educational Foundation, Inc.

Requirements:

Due on : February 14, 2011 / 9:00 AM
 
one (1) Database – dbAccess
one (1) Table – tblRecords with two (2) fields
    uname / varchar / 15
    passcode / varchar / 20
at-least five (5) PHP scripts (index.php, login.php, register.php, logout.php, dbconnect.php)

Procedure:

User opens index.php, index.php ask for username and password credentials and displays (also) Option to register if not yet a user
    in Login
        if accepted value for username and password matches with uname and passcode
            display “Welcome back user + uname”
            display logout.php link besides welcome text
        else
            display “Wrong Username and/or Password”
    in Register
        if accepted value for username is not yet in Database
            if username not Empty and Password + Retype-Password Matches
                Insert Information to Database
                display "Congratulations! Information Added to Database"
            else
                display "Required Field(s) is/are Empty!"
        else
            Display "User name + Username + Already Exist!"
 
good luck (** *******!)