Task:

The intent of the final project is to integrate what we learned so far to develop a relatively-comprehensive PHP/Oracle application. Since authentication is one of the major database applications, we will develop a database authentication application for the final project.

Your mission is as follows:

1. Database schema: The database user will be "php" and the password will be "php" as well.
   
   
2. Database and data table: We will use the same table as we created in the previous project (user_table). If the table was dropped for some reason, you may use the SQL script provided here to re-create a table called "user_table."
   
   
3. User input will be performed using the same HTML form used in a previous project. Please note that you are required to use the same variable names as in the form so that the input can be transmitted to your PHP program.
   
   
4. Use your PHP program to perform at least the following authentication checks:
   
   a. (15 points) If the user name is not found from the database table, you will display the following message:
   
   "The user name does not exist. Please go to Create New User section to create your account."
   
   b. (15 points) If the user name and password match with the table, you will display the following message:
   
   "You have successfully logged in the system. You may perform the authorized tasks on the site."
   
   c. (10 points) If the user name exists in the table, but the password does not match, you will display the following message:
   
   "Login failed. Please try to login again."
   
   

PHP Program Requirements:

You are required to develop one PHP program as follows:

1. User input will be provided through the same HTML form as that used in the previous project. (10 points)
   
   
2. Use the Oracle connection parameter file as defined in the previous project (File Name: oracle_parameters.php). Direct specification of the parameters within your main PHP program is not acceptable. The exact spelling of the three parameters remain the same as in the previous project. (10 points).
   
   
3. Database: The PHP program will connect to the Oracle database (schema or user:php; password: php; table name: user_table). (10 points)
   
   
4. You are required to use Oracle bind variable(s) to accomplish the tasks. (20 points)
   
   
5. The PHP program will perform the authentication function as specified above. (40 points)
   
   
6. Your PHP code will be tested for its intended functions by varying user input through the HTML form.
   
   
7. Test your code using a web browser, and "mobiletest.me" or "responsive web design tester" plugin. You may test it in either iPhone 5 or an Android device of your choice. Provide screen shots for testing in a Microsoft Word file. (10 points)
   .
   

Submission Requirements:

1. A PHP Code File: You are required to submit only one PHP code file as specified above. (The HTML form and oracle_parameters.php are not required for submission.) (90 points)
   
   
2. Microsoft File: Provide screen shots of testing the above PHP code using: 1) web browser and 2) "mobiletest.me" or any other tools you can find. (10 points)

Standard for File Name: Please name your file as firstname_lastname_final.php, where firstname and lastname are your first and last name, respectively, and "_" is underscore. Similarly, your Microsoft Word file will be named as firstname_lastname_final.docx. Five (5) points will be taken off if the file is not named according to the convention.

Please submit your project files on D2L according to the deadline established on the course schedule.