This is written completely in HTML and PHP. ADDING A PERSONALIZED WELCOME MESSAGE (SEE CHAPTER 3) [0-10 POINTS]
Add a personalized welcome message to the main pages of your web site (in the header portion of it) using an html form and php code that prompts the user for the first name and last name and then outputs "Welcome to my site, Professor!" if the first name entered is your professor’s first name and the last name entered is your professor’s last name. Otherwise, output "Welcome to my site, first name last name!". The name should be permanent on all pages of the site in the header portion. You will need to create a name. html file and a name. php file in the includes folder for this part of the project to add this code. You are also expected to do validation on the inputs.
ADDING AND DELETING A NEW USER (SEE CHAPTER 4) [0-10 POINTS]
1. (0-5 points) Add a new link after the last query called Add Employee on the main page that will open an html form to prompt the user for information needed to add a new user to the employees table. Take the information entered and add the new user to the employees table. Do a SQL select query on this newly added user (only) to verify it worked (using employee_ID) and output the results for this user only. You should obtain the next available primary key value (i. e., incremented from the current highest value) via code and not allow the user to enter this in the form. Do a SQL select query after the insert to verify it worked. Add the appropriate files to the includes folder for this part of the project. Be sure to ask for input for all attributes. Remember to validate your inputs on your form!
2. (0-5 points) Add a new link after #1 above called Delete Employee on the main page that will open an html form to prompt the user for information needed that will allow them to delete a user from the employees table. The delete should be done using the Primary Key of the user. Once the user enters this key, output all other field values in the employees table for that user and ask them to verify it is the correct user, then check response and either delete the user or don’t, based on their response. Do a SQL select query before and after the delete to verify it worked (last query should show no results). Give the user confirmation that it worked. Add the appropriate files to the includes folder for this part of the project.
ADDING A PERSONALIZED WELCOME MESSAGE (SEE CHAPTER 3) [0-10 POINTS]
Add a personalized welcome message to the main pages of your web site (in the header portion of it) using an html form and php code that prompts the user for the first name and last name and then outputs "Welcome to my site, Professor!" if the first name entered is your professor’s first name and the last name entered is your professor’s last name. Otherwise, output "Welcome to my site, first name last name!". The name should be permanent on all pages of the site in the header portion. You will need to create a name. html file and a name. php file in the includes folder for this part of the project to add this code. You are also expected to do validation on the inputs.
ADDING AND DELETING A NEW USER (SEE CHAPTER 4) [0-10 POINTS]
1. (0-5 points) Add a new link after the last query called Add Employee on the main page that will open an html form to prompt the user for information needed to add a new user to the employees table. Take the information entered and add the new user to the employees table. Do a SQL select query on this newly added user (only) to verify it worked (using employee_ID) and output the results for this user only. You should obtain the next available primary key value (i. e., incremented from the current highest value) via code and not allow the user to enter this in the form. Do a SQL select query after the insert to verify it worked. Add the appropriate files to the includes folder for this part of the project. Be sure to ask for input for all attributes. Remember to validate your inputs on your form!
2. (0-5 points) Add a new link after #1 above called Delete Employee on the main page that will open an html form to prompt the user for information needed that will allow them to delete a user from the employees table. The delete should be done using the Primary Key of the user. Once the user enters this key, output all other field values in the employees table for that user and ask them to verify it is the correct user, then check response and either delete the user or don’t, based on their response. Do a SQL select query before and after the delete to verify it worked (last query should show no results). Give the user confirmation that it worked. Add the appropriate files to the includes folder for this part of the project.