Create a readAll.php file to read all existing data in the database. On this page, place a button Show All Enrollments. Program this button so that when it is clicked, all enrollment records are read from the database and shown on the web page. Here are the detailed requirements:

a. Use JOIN to combine all three tables so all attributes in this database will be shown.

b. Display the results in the sequence below with commas as separators.

Create a select.php file to read the existing data based on criteria. On this page, place a label and a textbox which takes users input of course title, and another set of label and textbox taking users input of student last name. Then place a button Show Enrollments. Program this button so that when it is clicked, the database will search the course title and student name attributes in the above joined table to find matched records. Perform fuzzy match such that if the course title contains the search keyword AND student last name contains the search keyword, the enrollment record is returned. Here are the detailed requirements:

a. Write a string sanitizing function to pre-screen and sanitize all user inputs

b. You can use LIKE and % in SQL to perform fuzzy matching.

c. Display the results in the sequence below with commas as separators.

i Chrome File Edit View History Bookmarks People Window Help 100% . Thu 5:22 PM Assignments- Cis475-90 1323469 X1458370 e Create A ReadAl.php File M 192.168.64.2 /localhost, | G Create a readAll.php file l | + https://s3.us-east amazonas.com/blackboard earn xythos prod 578bae342181/1323469?response content dispositions line%3B%20lename%2A%3DUTF ::: Apps Apple Gmail Facebook y TwitterInstagrarm ZS xbox.com w wikipedia Blackboard echegg EESPN . USATODAY Linkedin DBoB PayPal N Netflix 1323469 ables (Course, the table should contain those fields as shown below StudentID LastName FirstMidName CourselD Title Credits 1 Alexander Carson 2 Alanso 1050 Chemistry 4022 Microccanamics 1041 Macroeconomics 1045 Calculus 141 Triganametry 2021 Composition 2042 Uterature Meredit AnandArturo 4 Barzdukas Gytis 5 Li 6 JusticePeay 7 Norman aura 8 Olivetto Nind Yan EnrollmentID CourselD StudentID Grade EnrollmentSemester 1 1050 2 4022 3 4041 4 4022 5 1045 6 3141 72021 8 3141 9 2021 10 1050 11 1050 1 92 FA1S 1 76 FA15 1 87 FA15 1 85 FA16 2 89 FA15 2 54 FA15 2 51 FA16 2 62 FA16 2 77 SP17 FA17 FA17 Here are the detailed requirements for attributes: CourselD should be in CHAR(4) data type. Title should in VARCHAR(32) data type. Credits should be in SMALLINT(4) data type. a. Screen Shot 20 pdf ^ Show All X i Chrome File Edit View History Bookmarks People Window Help 100% . Thu 5:22 PM Assignments- Cis475-90 1323469 X1458370 e Create A ReadAl.php File M 192.168.64.2 /localhost, | G Create a readAll.php file l | + https://s3.us-east amazonas.com/blackboard earn xythos prod 578bae342181/1323469?response content dispositions line%3B%20lename%2A%3DUTF ::: Apps Apple Gmail Facebook y TwitterInstagrarm ZS xbox.com w wikipedia Blackboard echegg EESPN . USATODAY Linkedin DBoB PayPal N Netflix 1323469 ables (Course, the table should contain those fields as shown below StudentID LastName FirstMidName CourselD Title Credits 1 Alexander Carson 2 Alanso 1050 Chemistry 4022 Microccanamics 1041 Macroeconomics 1045 Calculus 141 Triganametry 2021 Composition 2042 Uterature Meredit AnandArturo 4 Barzdukas Gytis 5 Li 6 JusticePeay 7 Norman aura 8 Olivetto Nind Yan EnrollmentID CourselD StudentID Grade EnrollmentSemester 1 1050 2 4022 3 4041 4 4022 5 1045 6 3141 72021 8 3141 9 2021 10 1050 11 1050 1 92 FA1S 1 76 FA15 1 87 FA15 1 85 FA16 2 89 FA15 2 54 FA15 2 51 FA16 2 62 FA16 2 77 SP17 FA17 FA17 Here are the detailed requirements for attributes: CourselD should be in CHAR(4) data type. Title should in VARCHAR(32) data type. Credits should be in SMALLINT(4) data type. a. Screen Shot 20 pdf ^ Show All X