CSE383-a PHP application called lab11­14 Solved

Description

You are to create a PHP application called lab11­14.php that:

1. Requires the user to authenticate.
   1. Use sessions to keep store the authenticated user name. Only if the user is not in the session variable would you prompt the user for their credentials.
   2. User data is stored in a table called users:
      1. pk
      2. user ­> user name
      3. password ­> hash value of the password created using the password_hash function in php
   3. Once authenticated the php program will display a table with all records in the SchoolData table. The table should have the following information:
      1. School name which should also be a hyperlink to the school url.
      2. Number of Undergraduates.
      3. Median Salary
   4. Once that is working, add a filter option that will limit the schools output based on the Median10YearEarnings. Make sure to validate that the input provided is actually a number.

A sample solution    (https://ceclnx01.cec.miamioh.edu/~campbest/cse383/lab11­14.php) is available to better describe what you should achieve.

Details:

Do this work in your git working copy and make sure the code is submitted to the gitlab repository. All work is to be done in the same file called lab11­14.php

https://miamioh.instructure.com/courses/80211/assignments/868027?module_item_id=1439446           1/2 12/22/2018        11-14 Assignment – DB and Authentication

Users are already populated in the users database. Test users include:

test, test test1, test1

user passwords are hashed using the password_hash function. You should use the password_verify function to verify the password.