PHP with MySQL Database lab session

Goal:

Develop a website to add, delete and display professors.

The database is called school with one table called professor as we did the last time where

SSN is the primary key

The index.php page looks like this:

$$ The user can fill the professor data and click on save. He$$s redirected back to

index page if the add is successful.

$$ When the link $$display all professors$$ is clicked, we are taken to the page

display.php that gives this if no professors have been added yet

When add professor is clicked, the user is directed to index again.

If some professors were added, it looks like this:

University of the Fraser Valley is located on the unceded territory of the St$$:l$$ peoples. We gratefully

acknowledge our privilege to live and work on these unceded lands.

$2$

If X is pressed, the professor is deleted, and we are redirected back to the display.php

If X is pressed, the professor is deleted using the code in the delete, and we are redirected

back to the display.php page.

Steps:

$1.$ Create professors Table in the school Database if you haven$$t done so far.

$2.$ Create the connection file $$connection$.$php$$

$3.$ Create the index.php page

$4.$ Create the display.php page

$5.$ Create the delete.php page